PavanKumarU
Programmer
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".Database.tables.count=0 then
for ntablecount=1 to Session("oRpt".Database.tables.count
Session("oRpt".Database.tables(nTableCount).ConnectionProperties("dsn" =lsdsn
Session("oRpt".Database.tables(nTableCount).ConnectionProperties("DataBase"=lsdb
Session("oRpt".Database.tables(nTableCount).ConnectionProperties("User Id"=lsdbId
Session("oRpt".Database.tables(nTableCount).ConnectionProperties("Password"=lspwd
next
End if
I hope i am clear abt the problem. Any help is much appreciated.
Thanks
Pavan
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".Database.tables.count=0 then
for ntablecount=1 to Session("oRpt".Database.tables.count
Session("oRpt".Database.tables(nTableCount).ConnectionProperties("dsn" =lsdsn
Session("oRpt".Database.tables(nTableCount).ConnectionProperties("DataBase"=lsdb
Session("oRpt".Database.tables(nTableCount).ConnectionProperties("User Id"=lsdbId
Session("oRpt".Database.tables(nTableCount).ConnectionProperties("Password"=lspwd
next
End if
I hope i am clear abt the problem. Any help is much appreciated.
Thanks
Pavan