Appending Parameters without URL string

[jkb17]

Is there anyway to append parameters to a Report Object programmitcally instead of via the URL string?

For example,

Query = "Select * " & _
"From CI_INFOOBJECTS Where SI_PROGID='CrystalEnterprise.Report' And SI_NAME = '" & ReportFileName & "'"

'execute the query and get report info
Set Result = IStore.Query(Query)

'Retrieve the first report returned.
Set ReportObject = Result.Item(1)

'Retrieve the report interface.
Set ReportInterface = ReportObject.PluginInterface

Now with the following code and a for loop

ReportInterface.ReportParameters.ParameterName

I could print out each parameter name.

In the help files I see that there is a Add method as well as a CLear methood. There is a ReportParameterValues collection available as well. Is there any way that I can use this?

Thank you

bye

 

[jkb17]

Is there a way to log on to the DSN without passing the username and password in the URL string?

That seems to be the most pressing issue. The client doesn't want their username and password info to be included in the URL string.

 

[tdevpar]

Check out the sample ASP code from Seagate. There is an example there on how to do that using ASP.