i need a Summary of main report

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

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

Post Author: amr_foci

CA Forum: General

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

good luck

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

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

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

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.

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

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

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