Ordering the Group and sub-report question

[maas]

Hello all,

I have two inquiries:

The first inquiry is that i am grouping a set of data regarding the departments (HR, Finanace, IT, Accounts). My question is, is it possible to order the values as per the requirements (not asc or asc)and how?

The second inquiry is that I am having a sub-report and it has the a formula which calculates the total. How do I pass it to the main report so, I can use it?
(( I am using different tables))

Thanks for your help in advance

 

[lbass]

You can go into the group expert and select "specified order" instead of "ascending" and then order as you wish.

Set up a formula in the sub report footer:

whileprintingrecords;
shared numbervar tot := sum({table.amt});

In the main report, you would have to reference this in a section below the one containing the subreport, so that if the sub is in GH_a, the formula referencing the shared variable would have to be in GH_b, as in:

whileprintingrecords;
shared numbervar tot;
tot * {table.qty}//sample calculation

-LB

 

[maas]

Thank you lbass, i will try this