Crystal Query Issues

[PavanKumarU]

Hi,
We are using asp, RDC to view, export reports via web. I have the following issues *only* when the reports are using crystal query instead of a stored procedure or table links.

Issue:
The report login fails when I use the following code. The same code works fine when the report uses stored procedures. Not able to find a work around either and no info on this (except for some *known issues* with database links on crystal site, as usual!!)

if not Session("oRpt&quot.Database.tables.count=0 then

for ntablecount=1 to Session("oRpt&quot.Database.tables.count
Session("oRpt&quot.Database.tables(nTableCount).ConnectionProperties("dsn&quot =lsdsn
Session("oRpt&quot.Database.tables(nTableCount).ConnectionProperties("DataBase&quot=lsdb
Session("oRpt&quot.Database.tables(nTableCount).ConnectionProperties("User Id&quot=lsdbId
Session("oRpt&quot.Database.tables(nTableCount).ConnectionProperties("Password&quot=lspwd
next
End if

I hope i am clear abt the problem. Any help is much appreciated.
Thanks
Pavan

 

[synapsevampire]

I'll assume Crystal 9 here:

Here's the connectivity whitepaper:

http://support.crystaldecisions.com/library/kbase/articles/c2012058.asp

-k

 

[PavanKumarU]

hello k,
Thanks for replying. I have checked out the document specified in the article you mentioned and also another doc (for older reports) thats called "cr_rdc_dbconnectivity.pdf", but neither of the reports mentioned anything about logging into the query or even using query.
Do you have further info about it please?
Any info is much much appreciated.
To elaborate on my problem:
1)How do i know at runtime that the report is using crystal query and not anything else?
One way i could think of isto get the table name which shows as "Query" whenever it uses a crystal query as its data source. Even if i overcome this issue further:

2) How can i "login" to this query? Do i really login to this query or would i login to the database, but pass the login info to query, and query inturn would pass the sql and this login info to the database? I am confused!! Hope u I didnt confuse you too!!

3)What kind of dataconnection would this be? i.e is it a native, odbc or oledb?

Thanks again for ur inputs. Highly appreciate them.
Thanks
Pavan

 

[synapsevampire]

Crystal Queries are a bad idea.

I missed that in your first post, and since you checked for earlier versions of Crystal (stiull have no idea what version you're using):

http://support.crystaldecisions.com/library/kbase/articles/c2007877.asp

-k

 

[PavanKumarU]

Hello K,
Thanks again for a promt reply.
I am sorry for not mentioning the version. We are using Crystal Reports 9, standard.
About the issues, I have read the article you mentioned. Crystal report suggests the usage of a stored proc, active data etc in this article but really doenst provide any info on how actually to login to the query. I am frustrated with crystal.
Please lemme know if you have any code on this.
Thanks
Pavan