on 01-28-2014 11:50 PM
.
I am generating a mockup tab(crosstab in crystal reports XIR2).
scenarios#There are 3 developers(example: phani, ram , robert, etc) in my project those who report to my manager.
I need to develop a report to show the total number of crystal reports developed by monthly by each person for the current year and the previous year.
In the below screen shot , i developed the person "phani" count for the present and the previous year.
However, I need to repeat the same mock up tab for the remaining persons (ram, Robert etc.) in the same report.
My problem is that technically I can generate mock up tab for one person in the crystal report, but i don't know, how to generate entire people (phani, ram, robert etc) mock up tab in the one report.
Make sure that your Group1 is on the person who develops the reports. You can configure the group to be "In Specified Order" so that you include the three people who develop reports and then an additional entry for "All Others". You would then format the mock tab using additional groups inside that Group1.
-Dell
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
sorry for the late reply;
Example:
Table.name= {phani, ram, robert,....N number of persons}. // lets say 10 persons
creating mock up tab
// 100 and 9 reports were generated in Jan and Feb by 10 people. In which 4 reports were generated by phani
JAN FEB
[Group by the year #] 2013 Total 100 900
[Group by the
person, Table.name#]2013 phani 4 3
2014 Total 1100 260
2014 phani 7 2
// 1100 and 260 reports were generated in JAN and FEB of year 2014, in which 7 and 2 were generated by phani
I need to develop the same mock up tab for the current year and the previous year of each person (the number of persons may vary ).
Note: Table.name field is dynamic (person count varies between 10-20). and I need to display each person report.
Version# crystal reports XIR2
Hi Phani,
In your sample mock tab you are showing like :
2013 Total
2013 Total - Phani
2014 Total
2014 Total - Phani
----------
2013 Total
2013 Total - Robert
2014 Total
2014 Total - Robert
----------
Is that you want to print '2013 total & 2014 total ' (without developer name) in each block ? If so, you need to create sub report for each person and insert in your main report footer.
or
If you want to print like :
2013 Total - Phani 5
2014 Total - Phani 2
Total Phani 7
2013 Total - Robert 2
2014 Total - Robert 3
Total Robert | 7 |
----------
Then you need to insert a group on person name and insert summary. If you don't have person name field then you may have to extract from '2013 Total - Phani' field by writing a formula.
-Sastry
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Your suggestion is like a static subreports (group by person name) inserted into the main report. But the number of persons may vary for each year and the reports needs to be dynamic
table= table;
Table.name={phani, ram , robert,... n persons}
The number of persons may vary# The number of persons may vary and i need each person report
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.