473,473 Members | 2,039 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

I need help changing the connection string in ASP for Crystal Reports 9

1 New Member
Hello everyone,

I need help creating an asp page to view a crystal report, which requires that that I change the database connection dynamically. I thought I had this problem licked in CR7 (the version of crystal the report has been designed in) but when I tried to deploy CR7 to my server I found that I could not install the ASP components on IIS 6.0 (even using the manual installation method). I had a CR9 dev edition update, which came with a copy of RAS. I installed CR9 and RAS and successfully deployed the report with a surprisingly small amount of code. The problem is that it prompts for all parameters and the database logon. I need to be able to change the name of the database that the report uses through my ASP (not ASP.net) web page, instead of allowing the report to connent to the database saved with the report. I would also like to be able to pass it the log on credentials and parameters. I've included the code I'm currently using below.

Thanks in advance

<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252" %>
<% Option Explicit
Response.ExpiresAbsolute = Now() -1

Dim HTMLViewer
Dim ObjectFactory

Set ObjectFactory=CreateObject("Crystalreports.ObjectF actory.2")
Set HTMLViewer = ObjectFactory.CreateObject("CrystalReports.Crystal ReportViewer")
With HTMLViewer
.ReportSource = "C:\Program Files\Crystal Decisions\Report Application Server 9\Reports\ClaimReview\Invoice_SQL_Works.rpt"
.IsOwnPage = true
End With

On Error Resume Next
call HTMLViewer.ProcessHttpRequest (Request, Response)
if Err.number <> 0 then
Response.Write Err.Description
Err.Clear
end if

%>
Aug 31 '06 #1
0 2511

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Stedak | last post by:
We are trying to use untyped reports in a C# application. Since the reports are being written by a third party the connection information needs changed at runtime. It will always be a ODBC SQL...
5
by: Mike | last post by:
I am writing a .NET application in C# that uses Crystal Reports. I want the crystal reports to grab information from a database no matter where the database is located. To do this, I want to...
2
by: fatboy | last post by:
I'm trying to change the database and server on a report that was created using integrated security e.g. report was created pointing to the server 'testserver' and database 'testdb' and at runtime...
0
by: Atif | last post by:
Hi All My problem is not related with this group BUT i have got a clue from here that's why i am posting this question over here. I am using Crystal Reports 9 with MySQL and SQL Server....
2
by: news.microsoft.com | last post by:
Hi, (Vb.net 2003 and Crystal report.net) If my application already has a connection, how can I use it in the crystal report. I have designed some reports using the designer with vs.net03,...
7
by: Bernie Yaeger | last post by:
I can't believe that there aren't lots of developers who: 1. create a crystal report that connects to sql server 2. calls the report using the crystalreportviewer control to view it and then,...
11
by: NewGuytoNetworking | last post by:
I have an XML that my company sends out daily it used to be created by SQL but I now have to use crystal reports and I can't seem to get it to line up the same. Please help with any references or how...
2
by: hmznzr | last post by:
i am using b.net 2005. i am generating a crystal report. but when i work in a different computer i have to set the location of the database of the report before i generate. is their any dynamic way...
0
by: akshaycjoshi | last post by:
Most of you people are already familier with the working of crystal reports unlike me.I am working on an application when I have no other option but to use CR. It is very diff. for me to read an...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
muto222
php
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.