shahzad73
asked on
crystal reports limitations
I am using the crystal reports web server. i want to know the limitations for the crystal reports.
- is it possibile that we can work with temporary tables in the report we create in SQL server. what i want to do is that each report generated on the web should contain its own temporary data stored with the report and send to the client. i want to generate some MIS reports which require some database processing and i can not use permanent temporary tables in SQL server where multiple users are coming simultaniously. any alternative suggestion about this will be appriciated.
- can we dinamically generate the crystal report on the web and then have it send to the client.
If some body send me links to the web for the resources then i will really appriciate fo that.
Shahzad
You cannot store data in a report dynamically at runtime. What you can do is dynamically create your temp tables with variable names, then design your report around an alias. Pass the name of the particular dynamic temp table to the datasource alias to avoid file conflicts, or user collisions.
ASKER
it seems to be interesting to me. can u kindly give me some step by step procedure how to accomplish this specally how to pass the temp table in the report which has been designed around a alise.
Shahzad
ASKER
also can we also pass the temporary table created in SQL Server 7. as u know that SQL Server 7 also support temp tables which has the life time of only when it is being used by the application and after that they are automatically deleted from the database. you suggestion seems to be solve my proble of temp table and multiuser environmnet. also i need the automation code which set the report alise to the temp table. i will check the documnetation but in case i do not found then may be u can provide me the code. thanks
Shahzad
Shahzad
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks for the comments. i rally appriciate this
Shahzad
Shahzad
I am creating a application using Delphi , Interbase and Crystal report 8.5. I would like to know the procedure or website describing how to create report dynamically using variables from delphi. that is the report content should be generated at the runtime using the variables.
I heard that this can be done by using RDC and RCAPI calls.... if some boda can explain with the code it will be very helpfull for me ..
RAJA
I heard that this can be done by using RDC and RCAPI calls.... if some boda can explain with the code it will be very helpfull for me ..
RAJA
ASKER
Shahzad