Solved

crystal reports limitations

Posted on 2001-07-20
7
353 Views
Last Modified: 2008-02-01



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
0
Comment
Question by:shahzad73
  • 4
  • 2
7 Comments
 
LVL 1

Author Comment

by:shahzad73
ID: 6301568
i am using version 7 of the crystal reports

Shahzad
0
 
LVL 4

Expert Comment

by:YodaMage
ID: 6302215
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.
0
 
LVL 1

Author Comment

by:shahzad73
ID: 6320901

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
0
Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

 
LVL 1

Author Comment

by:shahzad73
ID: 6320916
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
0
 
LVL 4

Accepted Solution

by:
YodaMage earned 100 total points
ID: 6326849
As far as it goes, create a table as a template, Create report around it. Then pass your relavent table name at runtime to Crpe component.

Crystal never uses ACTUAL tables for anything. It creates an array of alias and table name information. This is stored in the table property of the crpe component. You can view this list and change items in the itemindex of the tables property at runtime.

As for actual code for changing this in a standalone CR setup, couldn't tell you, as I do all this in Delphi which really won't help you. My DRRYAN could tell you more as far as making the change in CR itself at runtime.
0
 
LVL 1

Author Comment

by:shahzad73
ID: 6327359
thanks for the comments. i rally appriciate this

Shahzad
0
 

Expert Comment

by:OGURaja
ID: 8671982
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
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

775 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question