Hello all
I have a Crystal 8 report which contains a subreport. This subreport is linked to the main report by a single parameter. So far so good.
My problem is this:
because the report needs to run against several different versions of my database (Informix), I have to use the old method of joining tables (select x from table1, table2, outer table3 where... and so on)
When I use the visual linking expert, Crystal creates the Query using LEFT OUTER JOIN etc. so I manually edit the query. the trouble is this seems to stop the subreport link parameter field from working so my subreport lists ALL the data where it should be selecting records based on the parameter value.
I'm not exactly a newbie to crystal but I'm certainly no expert either so fogive me if I'm being stupid.
If anyone has seen anything like this before or can let me know where I should start looking I'd be grateful.
Thanks in advance
CMR
I have a Crystal 8 report which contains a subreport. This subreport is linked to the main report by a single parameter. So far so good.
My problem is this:
because the report needs to run against several different versions of my database (Informix), I have to use the old method of joining tables (select x from table1, table2, outer table3 where... and so on)
When I use the visual linking expert, Crystal creates the Query using LEFT OUTER JOIN etc. so I manually edit the query. the trouble is this seems to stop the subreport link parameter field from working so my subreport lists ALL the data where it should be selecting records based on the parameter value.
I'm not exactly a newbie to crystal but I'm certainly no expert either so fogive me if I'm being stupid.
If anyone has seen anything like this before or can let me know where I should start looking I'd be grateful.
Thanks in advance
CMR