Displaying all data

[MerChen]

I have a report which shows summary data by a grade. So in my databand I have a grade field and also a count and an average salary. My goal for this report is to show all grades values (1 to 10) even though I may place filter on it. My ideas to solve this (in theory) are:

1) To have a new dataset just containing a grade field and with the values 1 to 10 and then linking to my original dataset by grade. The report would then use the new dataset as it's primary data source. Is this possible - to manually create a dataset and populate it?

2) To hard code it. So my databand would have 10 rows of fields that says if grade is equal to 1 then display count and average; if grade is equal to 2 then display count and average, etc...

Would any of these ideas work? I'm still learning the tool so any other suggestions and help would be most appreciated.

[Alex K.]

Hello,

Your question is not quite clear. If you have grade in your main dataset, you will not need to create an additional dataset. In this case, you can use grouping by the field, as well as be able to apply the necessary filters and calculations. The idea is that this is the easiest way.
Could you, please send us a simple example of data in the form you have them originally obtained.

Thank you.

[MerChen]

Thanks for your reply Aleksey. It's employee data and each employee is assigned a grade. The values of the grade range from 1 to 10. Currently, if I run a report for the entire population, I will have a report listing all grades along with the count and average salaries. However, if I choose to run the report filtering for a small department or my population changes, I may only get grades 4, 5, 7, 8, 9 and 10 appear on the report - because this department does not contain any employees in the other grades. How do I show all grades on the report (obviously the count and the average for the missing ones would be 0)?

Let me know if still unclear, thanks.

[Alex K.]

Hello,

If we understand you task correctly, please, see the sample report in attachment.

Thank you.

[MerChen]

Thanks Aleksey. However, my PC isn't recognising those files. Can you tell me what I need to open them?

[Alex K.]

Hello,

Sorry. Please download attached files in previous post again.

Thank you.

[MerChen]

Thanks Aleksey this is exactly what I'm after and should meet the requirement for the report I'm building. Anticipating a possible question down the line, what would you do if the set of grades expanded from 1-10 currently to 1-10 and also A-E?

[Alex K.]

Hello,

You can use variable (type char) and in event After Print on master databand use

Code: Select all

GradeSymbol = (char)((int)GradeSymbol + 1);

Please see the sample report.

Thank you.