View Single Post
  #1 (permalink)  
Old April 17th, 2005, 05:05 AM
mike_abc mike_abc is offline
Authorized User
Points: 173, Level: 3
Points: 173, Level: 3 Points: 173, Level: 3 Points: 173, Level: 3
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
Join Date: Dec 2004
Location: , , .
Posts: 30
Thanks: 0
Thanked 0 Times in 0 Posts
Default Crystal Reports Engine in Push Mode


I want to use a report in PUSH mode, that is, to specify user credentials, dataset for that report AT RUN TIME !

The report as such I've created in Designer mode with my credentials on an existing view in the database, but...

at runtime the actual user will have to use :

- his own credentials
- a custom generated dataset via SQL statement (obviously with the same structure as the view) but with a different number of lines, depending on the contents of that SQL statement.

What happened so far:

I used the following code:

Dim objReport As New CrystalDecisions.CrystalReports.Engine.ReportDocum ent

sRepName = sRepPath & sRepName & ".rpt"
objReport.SetDatabaseLogon(sUser, sPassw, sServer, sDataBase)

ReportViewer.ReportSource = Nothing
ReportViewer.ReportSource = objReport


My problem is that it worked !
It shouldn't have worked, since the user for which I supplied the credentials doesn't actually have access to the view, so I presume the report just used the Design time credentials, despite the above code !

How should I do it ? Is there a tutorial on the Internet for CREngine in PUSH mode ?


Reply With Quote