Skip to Content
author's profile photo Former Member
Former Member

conflict in creating a group by function in mock up tab

.

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.

crosstab.jpg (282.8 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Jan 28, 2014 at 11:59 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 29, 2014 at 06:09 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.