did you try using running totals? the other way is creating others variables to summarize your subreport variable per group.

example shared numbervar sample := sample + you variable.
you should have to create one per group if you desire a total for each one and place them in the same section that your subreport variable is on your report.

Hi

Edited by Sastry - 27 Apr 2014 at 2:52am

hi

rather than opening a new thread I though I might ask here as its slightly related.

Is there any way to sort a report by one of my variables i.e. if I used one of my variables to calculate gross profit, how can I sort the report then to list the top ten most profitable jobs?

edit
When reporting the top ten most profitable jobs in a given period, I dont want to group by sales person or customer so I removed all my groupings and just have my subreport in the details section. The output looks fine, its reporting how much is invoiced against each job. I just need to order this in such a way that it sorts by the most profitable up top.



thanks
marc


Edited by marco007 - 30 Apr 2014 at 5:26am

I'm back to the drawing board on this I think (as you probably suspected) The calculated invoiced amount is not right. I think it needs to be grouped by job at least to get the variables to fire in the right order.

If I group by job however it applies a sort at that point though does it not, so I probably cannot sort by my variable after that then..?

I'll outline this a little clearer after the weekend when I have some time.
thanks for your help so far

hi folks

still at this one

lockwelle - thanks for your reply. I gave up on sorting the report by the variable values. It would be nice to be able to do it but not critical for me in this instance so I didnt persevere.

I do have another problem to solve which Im hoping you folks may be able to help me with. My report works fine now but I'm being asked to nest this whole report as a subreport in a larger monthly end report that I have built. The idea is that management just want to see the bottom line on this profitability report i.e. just the totals.

I can do this by hiding each of the group headers and group footers below except for group 1 footer which has the salesperson totals which I am interested in.

Group1 header - by sales person
Group2 header- by Customer
Group3 header- by job > group3 header has subreport calculating total invoiced by job
Details - lists all invoices by job
Group3 footer has all of my job details, part num, est costs , act costs, Variable calling in the value from the subreport in the header section.
Group 2 footer - totals by customer
Group 1 footer - totals by salesperson.

THe problem I'm finding is, when I hide the output of group3 header, my total invoiced value is not calculated correctly (just outputs 0) this seems to be because my subreport for totalling what is invoiced is placed in the group 3 header.

The subreport does not seem to run if I hide or suppress this section. I tried to work around this by making it very small and colouring the font white but this is not ideal because I need to summarise this report down to one line and if this group header is visibile it has the same efffect as adding blank lines into the report.

Is this normal behavior that once the header is hidden that it would result in the subreport not running at all? I would have thought that the hide attribute would just affect the visibility of the section, that it should not stop it from running?

Is there some other trick I can use to hide this section?

thanks