Data source change on main rpt causes subrpt to fail

[jowilliams]

I have changed a the data source of an existing report that contains a subrpt - it was using 16 tables, now it uses a VIEW. Now when I run the report (via a PowerBuilder application) it returns no data (but neither does it report any errors). My guess (and it is a guess because I'm new to the 'delights' of Crystal) is that the subreport is not returning anything.

The subreport which returns data based on two parameters passed in from the main report. Since the source of the data on the main rpt has changed, I have changed the columns that link to the subrpt to now reference the appropriate columns of the view.

The subreport is essentially unchanged - and it has no common tables/views with the main rpt. The ONLY thing I have changed are the names of the two columns that get passed in from the main rpt and that are linked to existing parameters in the subreport.

I have tried totally deleting the existing parameters in the subrpt and recreating them, just in case Crystal had somehow got out of synch.

Does anyone have a clue?
Jo

 

[kenhamady]

Are the two new columns the same data types, lengths, etc as the old ones?

Also, check the parameters and selection formula of the old report and make sure there aren't any vestiges of the old connections still there. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)