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

i need a Summary of main report

Post Author: khalafawy

CA Forum: General

I have Report contain three colid name quantity 1 name1 102 name2 5 3 name3 20.......... total 35this for example areport contain more than one page . the request :i need a Summary of main report (subreport or cross-tab) contain 1- recordCount2- total of quantity for each pageas this tablepagenumber recordCount total of quantity1 3 35 2 ... ... thanks for help

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

13 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 19, 2008 at 08:26 AM

    Post Author: amr_foci

    CA Forum: General

    i think you could create a summary fileds and insert group which to be repeated every page

    good luck

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 19, 2008 at 09:03 AM

    Post Author: khalafawy

    CA Forum: General

    thanks mr Amr for your response

    But I have Problem

    How I can insert group which to be repeated every page

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 19, 2008 at 09:30 AM

    Post Author: amr_foci

    CA Forum: General

    i've sent you how to do it, check ur inbox

    good luck

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 19, 2008 at 11:03 AM

    Post Author: khalafawy

    CA Forum: General

    Dear friend

    Thank you for your help, but it's seem to me that you didn't understand what I need from report so I'll explain for you

    Consider that page number 1 contain the following data

    No

    Name

    Quantity

    1

    Ahmed

    10

    2

    Ali

    20

    3

    Amr

    5

    Total

    35

    Consider that page number 2 contain the following data

    No

    Name

    Quantity

    4

    alfred

    5

    5

    Jozeph

    15

    6

    sara

    20

    Total

    40

    And so on ...

    This part of report I finished it. The problem that I need page contain the flowing data depending on page number and it's contain from main report.

    Page number

    Name count

    Total Quantity

    1

    3

    35

    2

    3

    40

    I hope that my request is clear .

    Thanks for your time

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 19, 2008 at 12:01 PM

    Post Author: amr_foci

    CA Forum: General

    your example was so clear ya mr khalafawy,, but really i have no solution for it right now

    i worked on it for hours but got no soultion yet, wat you want is to aggregate by page number in a separate block,, that i've no solution for it now, but wat i was telling you before to aggregate using the page number was for every page independent,

    i will look for it more, coz i'm interested to know if it cab be done, if i got any solution i'll keep you informed,

    good luck

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 19, 2008 at 05:05 PM

    Post Author: khalafawy

    CA Forum: General

    Thank you very much Mr AmrI hope you get solution coz i'm need it stronglyif i got solution my project will be copmleted

    Rembmer that i was trying found solution since tow months by my self but i Couldn't found solution .I wish you look for it good luckthanks for you

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 21, 2008 at 05:48 AM

    Post Author: Jagan

    CA Forum: General

    I reckon you could just dump this info into arrays in the page footers and print the contents in the report footer.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 21, 2008 at 06:10 AM

    Post Author: amr_foci

    CA Forum: General

    Jagan ,, do you know how to dump the dynamic values for the page number into an array?

    thank you

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 21, 2008 at 07:01 AM

    Post Author: khalafawy

    CA Forum: General

    thank you :but I don't know how to dump the dynamic values for the page number into an array

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 21, 2008 at 10:53 PM

    Post Author: Jagan

    CA Forum: General

    Type "array" into the index tab in the help and have a read on the associated items too.I haven't actually tried this but I think it should work... :)I've also just written this here, not in Crystal so please excuse typos etc.The basics are:

    1) Create a formula in the group header to reset the page's counts, e.g.whileprintingrecords;numbervar rec_count := 0;numbervar rec_total := 0;

    2) Create a formula in the details to increment rec_count and tally total_quantity, e.g.whileprintingrecords;numbervar rec_count := rec_count +1;numbervar rec_total := rec_total + {table.quantity};

    3) Create a formula in the page footer to store this info, e.g.whileprintingrecords;numbervar array arr_count;numbervar array arr_total;numbervar rec_count;numbervar rec_total;redim preserve arr_count[pagenumber];redim preserve arr_total[pagenumber];arr_count[pagenumber] := rec_count;arr_total[pagenumber] := rec_total;

    4) Create a formula in the report footer to print the info, e.g.whileprintingrecords;numbervar array arr_count;numbervar array arr_total;local stringvar str;local numbervar i;for i := 1 To ubound(arr_count) Do //the two arrays have the same number of elements( //play with the formatting, totext etc. I've been lazy here and used implicit conversion... str := str & i & chr(9) & arr_count[i] & chr(9) & arr_total[i] & chr(10) & chr(13););str

    Add a comment
    10|10000 characters needed characters exceeded

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.