General information
Forum:
Microsoft SQL Server
Category:
Reporting Services
>>>If I cut and paste the SQL shown into my SQL Management Studio I get a different result. More rows are selected.
>
>More rows are selected in the Query Analyzer than show in the sub report?
>
>If that's the case, are there any selection specifications in the sub report?
>
>What is the data source? Is is the database or a dataset?
Hi Bill
Yes. I'm running the sub report separately in crystal.
There are selection specs in crystal. A start and end date and an organisation ref..
Entering those parameters in crystal gives me one row of results.
If I then display the SQL used and paste that into the management studio I get 4 rows..
The datasource is several tables from an SQL2005 database.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only