I have Report which consist of 3 charts and all are straight table
1)Employee Id ,Name,Number ,etc.
2)Field A, Field B ,Field C
3)Field D, Field E ,Field F
All these are columns.
Now in Report I have put banding on bases of "Employee Id" and there are 1000 Employees.
Requirement:
Now there are result in 2nd and 3rd chart where we don't have data for some employees. So I want report only for those whose data and details are present.
What is happening now:
Report is getting generated for Employees who data is not present keeping everything blank in chart.Which I don't want
are you generating these PDF via publisher? or simple from within the QVW itself and saving the resulting report to PDF?
If within the QVW itself, there is an option on the report to adjust the initial selection in addition to doing the banding. So you could think about creating a bookmark which selects down and reduces the possible values within Employee Id so that only those with data remain (or make this selection manually before running the report).
The other option is to maybe create a new field in your load script, which performs some logic checks on your data and only populates those Employee Id's where there is possible data. This option would only be good for a fixed report though. Banding could then be done on this field.
