SQL script as data source

building reports crystal reports
1

Hi there,

I’m creating a simple report in crystal. Initially it’s connecting to the universe but I was trying to test a SQL script as a datasource.

Here’s what I did.

  1. created SQL Command, but did not create any parameters at this point
  2. created the report and the parameters
  3. Used Select Expert to filter the data

When I ran the report, i believe it’s executing the query before applying the filter.
So I tried to create the parameters in the ‘Command’ screen. But they never got saved. What did I miss?

Do I need both parameters defined in the report and the ‘Command’ screen?

Thanks.

sofia (BOB member since 2009-01-09)

2

Hi there,

Can you show us the SQL query you’re using?

  • Usually, when you create a parameter in a Command (SQL query), the parameter is automatically created in the report itself, as long as the parameter is used in your SQL query.

zorgov (BOB member since 2008-12-16)

3

Once u have specified parameters in command, u donot need to specify parameters in report designer and should n’t use parameters in filters in select expert

jayad (BOB member since 2008-07-11)