Ok, here is my question, hope I can make myself vey clear about it:

I've been using the reportBuilder of VFP But There are something that this tool is not capable to do so I want to start working with the crystal reports as a Report Tool. I do not have problems about designing the reports in Crystal environment nor running these reports within VFP, my problem is about Multiusers reports.

What I mean with this? Lets try giving a situation:

Sometimes i build the reports and use the tables in the dbc, but sometimes I have to build a cursor and get all the data I need from other tables and put them in the cursor; then I run the Report, and the report doesn't have anything in the dataenvironment and has the Private datasession disabled this force to the report to take the fields from the current opened table or cursor. This cursor is always either in c:\temp or in memory but must of the time is in c:\temp I mean I create it in the workstation , not in the sever.

Since the Crystal report has a Table linked to the Report itself, my question is:

How can I tell the report to use the cursor that is in memory or the free table I create locally and it is placed on the temp dir of the workstation instead of the Linked table in its own "DataEnvironment" (if I can call it that)?

I don't want to have this temporary tables or cursor in the DBC niether as Free tables nor as Local views because It is better for me to create this thing in the workstation to reduce the Server work.

This way, several users can run the same report at the same time but with diferent tables as data source.

is there a way to do this?, I rad in a thread that you can tell the report wich table has to use in runtime, is it that true? is it possible? How can I do this?

please somebody help me to achive this I really love to start using Crystal reports as my report tool



Thks in advance

Karben Selim Mejia