Reports and subreport

[Viper]

Hello,

I have a report called ytd stats

and a subreport that pulls some figures for the ytd stats

my subreport is sorting by month just fine

But when i add it to the main report it then sorts it alphabetically

Why would this happen

I want my subreport to show exactally the way it looks when i run it
seperately

 

[Allen Browne]

If you want to define how the report should be sorted, you must use the
Sorting And Grouping box (View menu, in report design.)

 

[Viper]

The problem is
The subreport is grouped just fine
it shows
jan , feb, mar, apr, may etc

But when i put the subreport into another report
it shows
aug,apr,dec
do you see what i mean
Can i get the supreport to show the way i have it
i dont want the main report to sort anything
The subreport does all of the sorting
I can not get it to work with the sorting or grouping options either

 

[Allen Browne]

As I explained, the sorting is *undefined*, if you don't specify it in the
Sorting'n'Grouping. It might work, or it might not, depending on what else
is going on.

So, the solution is going to be to change the source query so it returns the
values 1 to 12 instead of the names of the months. You can sort on that, and
then format the dates so the month names show on the report.