Sub Report Problem

[mdctsg]

Hello

I have a main and a sub report. The main report consists of CompanyName, Packages(Shipped), Cost, Date. I use a date parament to retrieve the data. In my sub report I have State, Packages, Cost, Date. Also I ma using another date paramenter in the sub report. My probelm is although both fields appear in the parameter (Date, Date(State) when I choose the date range for the states it comes up with the page of the main report but with no data. Then the link is on the page and I need to click the link to get the data. And when I choose the Date to get the company sort the data will appear but the link comes up blank. Basically what I want to do is when I choose the main report also have the sub report ready if the user needs it. Is this possible. It is set to on demand and re-import

Thanks
Bob

 

[Madawc]

I've found that a subreport can't access a parameter directly - rather, it acts like it's accepted it and then does nothing with it.
A work-round is to move the parameter value to a formula field and then link this to the sub-report. If there's a better way, I'd be interested to know. Madawc Williams
East Anglia
Great Britain

 

[mdctsg]

Thanks for replying
I am not quite sure how to do that

Bob

 

[Madawc]

Create a formula field. Look down the accessable fields, and the parameter should be there. Click on it, and you get a 'formula field' which is just a shell for the parameter. But Crystal treats it differently, at least it did when I was having a similar problem Madawc Williams
East Anglia
Great Britain