Can Crystal read a value from a Querystring?

[ericb1]

Not sure how to approach this, but I had a report all formatted, but as it turns out, I need to insert some data into a database first.

So I was hoping I could use whatever (asp, or .net) to enter the data into the db, then open a new window with the report in it, and pass along some unique ID's so that the report, could read that into a parameter field, and generate the report.

Something like: reportserver/viewrpt.cwr?id=618&apsuser=username&dataID=something

where the report can have a parameter called dataID, and rather than prompting the user for it, it can read it from the URL of the report.

Or am I going about this the wrong way? Is there some easier way to do it? I think .net can embed a report, so I don't know if that's the way to go? ANY help is greatly appreciated, thanks!

 

[synapsevampire]

You need to learn what version of Crystal you have, or intend to get.

Crystal can do what you state.

You might also call reports from SQL depending upon the database.

Try posting specifics.

-k

 

[ericb1]

Sorry thanks for the help! I have Crystal Reports10, and I run the reports from Crystal Enterprise10. The data is in SQL server 2000 (on a different server).

Not sure how to call the report from SQL? Basically, I need some type of form or SQL to enter some bits of data first into a SQL database, then, immediately after that, open the report and call the ID that I just entered.

From reading other posts, I know that Crystal doesn't have any native database editing capabilities, it only reads from the data. So I assumed I was on my own to create some type of interface to first get the data in there.

But thanks again, any advice on the best/easiest way to do this would be great!