• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 435
  • Last Modified:

Pass Parameter to Crystal Report through ASP Page

Hi

Sort of a newbie to crystal.  I have a .rpt file.  It does a bunch of stuff which basically involves connecting to the DB and then pulling back information into the report.  It requires one parameter to be passed in.  That parameter is called @recid.  Once the report knows the record id, it gets the information from the DB for that record.  

So, I need the user to fill out the form which collects their information and inserts it into the DB which the report will read from.  Then, I get back the record id and I need to pass it to the CrystalRuntime.Application.10 object in ASP and then generate a pdf of the report in the user's browser.  Here is what I need to know:  How do i pass the parameter to the crystal object?

Thanks
David
0
lsrbby
Asked:
lsrbby
  • 3
1 Solution
 
vidruCommented:
Have you downloaded the asp samples for CR 10?
http://support.businessobjects.com/communityCS/FilesAndUpdates/aspxmps10.exe.asp

I've got some of the older samples.  Typically, there is a SimpleParameterFields.asp sample application that demonstrates how to pass a parameter.

-dave
0
 
mlmccCommented:
That should have the example.  Do you have CR 10 Developer or Advanced edition?

mlmcc
0
 
lsrbbyAuthor Commented:
I'm using cr10 developer.  Actually, I see the part in the sample for passing the parameter.  what I really need is a list of all the methods and properties of the crystalruntime object for classic ASP.  If i had that, I would probably be good to go.

however, if that isn't available, here is my current issue:

When i save the report (.rpt file) without data and then try to call it through my classic asp code i get this error--

Error Occurred Reading Records: Logon failed. Details: ADO Error Code: 0x80040e4d Source: Microsoft OLE DB Provider for SQL Server Description: Login failed for user 'WebReports'. SQL State: 42000 Native Error: 18456

So, i'm thinking i need the properties of the runtime object so i can pass the login,password,datasource, etc. to the report.

Again, if i save the report with data everything works fine.  but obviously this does me no good because each time the report runs it has different data associated with it.
0
 
mlmccCommented:
There should be an example in the file for passing logon parameters.  

Here is a sample in VB.Net
http://support.businessobjects.com/library/kbase/articles/c2010371.asp

SQL logon info
http://support.businessobjects.com/library/kbase/articles/c2010275.asp

mlmcc
0
 
mlmccCommented:
Glad i could help

mlmcc
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now