Connect to SQL Server using ASP

[JuliaFarber]

Hi,

I have a report which is based on SQL Server stored procedure. The client version works fine. But when I use ASP to connect to report, connectivity is false.
I am using crtable.SetLogInfo "server","db","user","password"

Does anyone know why?What am I doing wrong?

Thank you.
Julia

 

[pgtek]

hi here this might hekp you
In Crystal Reports version 8 and 8.5 ASP applications main report parameters must be set on the main report and subreport parameters must be set on the subreport. Below is some example code for passing values to a main report and subreport.
-----------------------------------------------------------

In this example the report is seen as having 4 main report parameters and 2 subreport parameters.

Note: Subreport-linking parameters do not need to be set with version 8 and 8.5.

set ReportDatabase = Session("oRpt&quot.Database

'Set the Table object and logon (1 table only)
set crdatabasetables = ReportDatabase.Tables
set crtable = crdatabasetables.Item(1)
crtable.SetLogonInfo "ODBCDSNname", "", cstr(userid), cstr(password)

'Create subreport database object, get table(s), login
set CRSubreports = session("oRpt&quot.OpenSubReport("testsub.rpt&quot
set ReportDatabase2 = CRSubreports.Database
Set crdatabasetables2 = ReportDatabase2.tables
Set CRtable2 = crdatabasetables2.Item(1)
crtable2.SetLogonInfo "ODBCDSNname", "", cstr(userid), cstr(password)

'Get handles to parameters in main report (there are 2)
set Session("ParamCollection&quot = Session("oRpt&quot.Parameterfields
Set ThisParam1 = Session("ParamCollection&quot.item(1)
Set ThisParam2 = Session("ParamCollection&quot.item(2)

'Set values for the parameters
ThisParam1.SetCurrentValue cstr("paramvalue1&quot,12
ThisParam2.SetCurrentValue cstr("paramvalue2&quot,12

'Get handles to parameters in SUB report (there are 2)
set Session("SubRptParamCollection&quot = CRSubreports.Parameterfields
Set ThisParam1 = Session("SubRptParamCollection&quot.item(1)
Set ThisParam2 = Session("SubRptParamCollection&quot.item(2)

'Set values for the parameters (these were previously set in the main report.
ThisParam1.SetCurrentValue cstr("paramvalue4&quot,12
ThisParam2.SetCurrentValue cstr("paramvalue3&quot,12

For more sample ASP applications to use as templates for your Crystal Reports web applications please download the file aspxmps8.exe (for version 8.0) or aspxmps85.exe (for version 8.5) from our support site at:

http://support.crystaldecisions.com/downloads