cancel
Showing results for 
Search instead for 
Did you mean: 

conflict in creating a group by function in mock up tab

Former Member
0 Kudos

.

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.

Accepted Solutions (1)

Accepted Solutions (1)

DellSC
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

I found the solution.

Its very simple.

creating a group by function in the report footer , that leads the report grow dynamically

Answers (1)

Answers (1)

former_member205840
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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