change of datasource

building reports crystal reports
1

hi,

we have been working with cystal reports 2011,there we have reports which were pointing to a table now we changed the that table with a new table with same structure.
that report have the subreport which have prompts and the main report have only one prompt but after changing the table , the main report is asking for an extra prompt which was there in subreport. :hb:
and that prompt is there while running the subreport before but after changing the table that prompt is not there in subreport.

please help how can we add the prompt in the subreport so that it would not ask while running the main report

thanks in advance,
sheetal

sheetu (BOB member since 2012-03-27)

2

Assuming the main report and the subreport use the same table, start out with your original report. Go to the subreport and do a Set Location there. Then go to the main report and do Set Location there as well. By separating out the Set Location calls instead of depending on it to propagate down from the main report, you may avoid the problem. If that doesn’t work, I suspect this may be a bug in Crystal 2011.

-Dell

hilfy :us: (BOB member since 2007-04-16)

3

hi Hilfy,

thanks for the reply,
i have the done the same but report is not working fine :frowning:

-sheetal

sheetu (BOB member since 2012-03-27)