I get the following error:
CRAXDRT Error Ocurred on Server - 2147192179: Error detected by Database DLL.
I pass the PatientID from another form into this page that instantiates the Report object and then also pass the userID and the password to open the report and the subreports that this main...
Hi Amit,
I was getting the errors because then I was working with CR 8.0 Apparently when CR 8.0 is installed, then it changes the default setting of the ODBC registry values. There were several articles in their knowledge base which mentioned several steps to use in order to restore the ODBC...
Hi,
I am using CR 8.5 and IE 5.5.
Apparently to release the current licenses used by the users, the Cleanup.asp clears the sessions whenever the the users closes the report.
I have set up a web page which the users log on and see the reports by clicking on a link. These reports pop up in a...
Hi,
I use the SmartViewActiveX to view my reports. Since this file references to CleanUp.asp to clean the session so that once the report is closed, the viewer can see another report. It is a way of releasing the licenses.
Apparently, Before viewing the reports, the users have to login into...
Hi,
Using the examples of the ASPXMPS85.exe, I wrote the code to log into the report with the sub reports.
My main report has 7 sub-reports and all of them are linked to the main report. It is only in the main report that I have a parameter ?PatientID. I pass a parameter PatientID from the ASP...
Hi,
Using the examples of the ASPXMPS85.exe, I wrote the code to log into the report with the sub reports.
My main report has 7 sub-reports and all of them are linked to the main report. It is only in the main report that I have a parameter ?PatientID. I pass a parameter PatientID from the ASP...
Hi Malcolm,
In all the folders where there are reports, I have the following files:
1. AlwaysRequiredSteps.asp
2. MoreRequiredSteps.asp
3. SmartViewerActiveX.asp
4. rptServer.asp
But I do not have the file cleanup.asp
Do I need to include this file as well in the folders that hold the...
Hi,
I developed all the reports in version 8.0 and then upgraded the reports to version 8.5,
I have a page with links and when I click on a link, I see the report in a new browser window. All this worked fine in CR 8.0 ( I was able to see all the 25 reports)
Now with CR 8.5, after seeing the...
Hi!
I have a framed set of ASP pages which the viewer sees only logging into the log on form. The log on form takes in the NT Username and the pass word and then creates a session id based on the username, the domain name and adds a few random numbers to create a unique session id.
At the...
Hi,
I have a text box. Below this I have a table where there
is a HTML table that stores in the person's first name,
person's last name, person's SSN in three different
columns. Rows are generated dynamically based on the no.
of records returned by the query. All the results in the
table...
Can I mail you the report and the ASP file that pulls information from the Pubs database. I did all the searching, but I shall search again.
Do reply if I can send the files. My email address is coolpersona@hotmail.com
Padmaja.
I am able to see the records shown in the report viewer when the ODBC is Pubs Sample Database. But when I point the ASP page to the Pub Test ODBC and the Pubs_Duplicate database, then I do not get to see any information in the report viewer because the report when designed points to pubs sample...
Hi,
The setLogonInfo method used in ASP pages takes in the DSN name, the database name, userid and password. For instance,
crtable.SetLogonInfo "Pubs Sample Database", "pubs", cstr(userid), cstr(password)
When I develop a report based on the titles table of the pubs...
Hi,
The setLogonInfo method takes in the DSN name, the database name, userid and password. For instance,
crtable.SetLogonInfo "Pubs Sample Database", "pubs", cstr(userid), cstr(password)
When I develop a report based on the titles table of the pubs database, I choose the...
Hi,
I have a successfully been able to access a report developed in 8.5 which when designed was connected to one ODBC name (ODBC_1). I do not get any errors now. Except for the table name, I stripped off the databasename.dbo before the table name. I am able to see the results of the report. I...
Hi,
I have a report in 8.5 which when designed was connected to one ODBC name (ODBC_1). Except for the table name, I stripped off the databasename.dbo before the table name. I am able to see the results of the report. I pass a Patient ID and am able to see the report in the browser window.
My...
In all the examples for the ASP pages that interact with the Crystal Reports, I found a lot of properties and also the hierarchy of some of the objects being used.
Where can find a detailed documentation of the objects, their properties and the methods used by a particular object ?
For...
Hi,
I am pulling data from the titles table of the Pubs database.
I get to see all the titles of the database. Now all the titles start with different letters. How can create a formula that will look only into the first letter of the title field and then show a different category for each...
Hi,
All these days, my reports ran off the CR 8.0. I upgraded the CR 8.0 to CR 8.5 All my reports open from ASP pages. All these reports take 3 parameters and show information fulffilling the three parametrs. It woked fine till I upgraded the CR to 8.5.
Now when I click on the button on the...
I have seen all the examples given in the sample files. Is it really necessary to use a DSN. Can we connect to the CR from the ASP in a DSN-less way by providing all the values given by the DSN in the ASP pages ?
If the DSN is the only way, then is the DSN to be set up at each and every client...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.