Crystal Subreport Problem

[Developer2007]

Hi,

This is kind of hard to explain, but here goes.

I created a report with a subreport. Everything works fine locally. However on the client machine the sub report is missing fields (or displaying wrong data).

Example:

Main report has these fields:
"EmloyeeNo"
"Name"
"No Of Sales"


Subreport has these fields:
"Category"
"No Of Sales"
"YTD No Of Sales"


The subreport displays the "No of Sales" from the Main Report. The the "Category" and "YTD No Of Sales" fields are missing.

It looks like the subreport doesn't carry it's command over.

Hope that's understandable

[jsham]

First, there must between the table in the main report and subreport which I assume is going to be the "EmloyeeNo".

There are are two possible causes to the problem you raised:

1. The sub-report link is not established properly. Check that you pass the "EmloyeeNo" in the main report to the subreport so that the subreport can read in the "Category", "No Of Sales" and "YTD No Of Sales".

2. There is no data for the "Category" and "YTD No Of Sales" of the employee you selected. Either enter some data for the employee or choose another employee with data.