crystalreportviewer object displays DHTML

[ciscowiz]

I have an ASP page written in vb.net that displays cr9 reports located outside the project. We use SQL Server 2000 for the DB. The page displays the reports in HTML but we currently use the activex viewer. Is there any way to make the crystalreportviewer object use the activex viewer?
Or better yet is there someway you can make the viewer call CE9 and send the url? Please let me know if more info is needed

Thanks,
Bryan

 

[synapsevampire]

You can use URL pass through:

http://support.businessobjects.com/library/kbase/articles/c2016644.asp

http://support.businessobjects.com/communityCS/TechnicalPapers/ce8_urlcommands.pdf.asp

Within the URL you can specify the viewer.

-k

 

[ciscowiz]

The second link looks like what I need but maybe you can lcarify this for me:

Since we are using CE9 and our reports are called through the URL, the report's datasource can be changed through the url as well? Because that's basically what I was doing in code using the crystalreportsviewer object. Creating a reportdocument object and loooping through the tables, applying logon info, etc.

 

[Turkbear]

Hi,
AKAIK,No..Using the URL method only allows those parameters listed in the doc Synapse referred you to..

 

[ciscowiz]

I thought in the doc it specified database login parameters, I guess I am wrong.

 

[Turkbear]

Hi, Oops, read too fast..Apparently you can:
-----------------------------------------------------
Method 2 - USER and PASSWORD command to pass logon
credentials, server name and database name
The USER and PASSWORD command can be used to pass logon credentials as
well as the server name and database name. This can be done for both the main
report and subreport.
Syntax
Main Report
User-<servername>.<databasename>& Password-
<servername>.<databasename>
Subreport
User-<servername>.<databasename>@<subreportname>&
Password-<servername>.<databasename>@<subreportname>
Example
Main Report
The example below illustrates how to pass the following values to the report:
server name .systemdsn.
database name .xtreme.
user name .vantech.
password .1234.

http://myServer/myVirtualDirectory/viewrpt.cwr?usersystemdsn.

xtreme=vantech&password-systemdsn.xtreme=1234
Subreport
The example below illustrates how to pass the following values to the subreport:
server name .systemdsn.
database name .pubs.
user name .vantech.
password .1234.
subreport .sr.

http://myServer/myVirtualDirectory/viewrpt.cwr?usersystemdsn.

pubs@sr=vantech&passwordsystemdsn.
pubs@sr=vantech

--------------------------------------------------

Learning is an ongoing process...