Problems with Parameters-Accessing Info.

[Kallen]

Hi everyone,

I have this report (with a paramter) and the table/query that feeds this report is located on my server.

A group of us are testing our Crystal reports before we make them available to other users.

What happens is when I send this report to someone (who does not have access to my server), they get an error message telling them that the table/query cannot be found.

This happens evertime they try and refresh the report (hence, enter parameter values).

The data is being stored within the report, so I am confused as to why this is happening.

Someone from another location sent me a report (on their server, that I don't have access to) and the same thing happend.

Is this because the tables/queries and not in a centralized location? or are we doing something wrong.

Any advice at this point would be GREATLY appreciated

Thanks

 

[lyanch]

You have it exactly. It is because the tables/queries are not in a centralized location. The refresh button says "go to the data source and get new data". Since the report can't find the data source, you get the error.

The "save data with report" only saves the data that is pertinent with the current parameters. You need to make your queries/table accessible to everyone who wants to run the report.

Lisa

 

[Kallen]

That's what I thought.

Thanks for the reply though, I just needed someone to re-confirm this.