I am a total newbie to CR and CE. I have craeted a rpt that runs off a stored procedure in a sql server db. To run the report it requires two params which are currently being supplied statically. What I would like to do is call the report via an asp page. I have The Standard CE installed that came with CR 9. How would I go about calling the report either through eportfolio or some othre option? I need to also pass the two parameters. Please try to be as specific as your time will allow since I am pretty ignorant about this stuff right now.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Deploy rpt via web
- Thread starter thysonj
- Start date
Hi,
I assume you want the values for the parameters to be supplied by the end user? If so, you need to design that ie. use the parameters in your record selection or formula, etc.
You save the report into CE. Note, when you select Save As from the file menu - you'll see Enterprise button down the left hand side. This allows you to save the report into CE.
Make sure your CE machine has the same DSN set up as a datasource as your development machine.
Once you have done this, go to the EPortfolio via your browser, navigate to the folder on CE you saved the report into and select the report. The View option will run the report on demand. Note, in the Crystal Management Console (CMC), in Objects, choose your report - there is a tick box to make sure that the user always get's prompted for new parameter values.
That's the overall process to save and view a report from CE. Hope this helps.
cheers...J
I assume you want the values for the parameters to be supplied by the end user? If so, you need to design that ie. use the parameters in your record selection or formula, etc.
You save the report into CE. Note, when you select Save As from the file menu - you'll see Enterprise button down the left hand side. This allows you to save the report into CE.
Make sure your CE machine has the same DSN set up as a datasource as your development machine.
Once you have done this, go to the EPortfolio via your browser, navigate to the folder on CE you saved the report into and select the report. The View option will run the report on demand. Note, in the Crystal Management Console (CMC), in Objects, choose your report - there is a tick box to make sure that the user always get's prompted for new parameter values.
That's the overall process to save and view a report from CE. Hope this helps.
cheers...J
- Thread starter
- #3
thanks...i had gotten that far...the problem was that the param was a dynamic param that changed everytime we ran a report. it wasn't much of an option to make the user enter the report id into the param request form. eventually i ended up implementing it a different way.
did the trick
Code:
[URL unfurl="true"]http://1.1.1.1/hsi/run/viewrpt.cwr?id=516&apsuser=admin&apspassword[/URL]
=pass&apsauthtype=Enterprise&init=actx&promptex-@ReportID=309did the trick
- Status
Similar threads
- Locked
- Question