Subreport show unwanted column which is not included

[sikkilamkiran]

hi,

I have a peculiar probelm,
i have a sub report which shows dimesion name, fromdate and to date columns , the link to main report is process_id,dim_name,dim_value...
when im running the report process id is geeting querried in the sub report which is just a condition column but not a actual column in the sub report. stiill the proces id column is getting querried in the sub report so im getting duplicate columns ,
can any one tell me how to avoid that process_id column to be removed from the sub report query.

-
kiran

 

[synapsevampire]

Try posting technical i9nformation:

crystal version
database/connectivity used
example data
Expected output

In CR 9 and above you can write your own query and add it as a Command, in which case you can avoid using the column in the select statement as Crystal does in CR 9 and above.

Check the Database-Show SQL Query to learn what Crystal is passing.

Then copy it out and paste it into a Command object to use that instead, and then eliminate any columns in the SELECT protion that you don't want.

Another option, which I prefer, would be to create a View on the database as the datasource.

-k

 

[lbass]

Please explain the structure of your main report and where you have placed the subreport. You probably need a group on process_ID and to place the subreport in the corresponding group section, but it's hard to tell without more information.

-LB