Support Forum - Multiple sorting bands using same field

09/18/2024 11:48 Andy Pelton wrote: 

Hi, 

Is is possible in FRB to have the same field used in multiple sorting bands?

I have a report that finds no results with a particular filter when 3 of the
bands have the same field in (a date field).

The table the report is using is a view (SQL backend)

The sorting bands are as follows
SB1 YEAR(View:appdate)
SB2 MONTH(View:appdate)
SB3 View:appdate
SB4 View:apptime

The record filter is the following, View:appdate >= startdate AND View:appdate
<= enddate AND View:status = 0 AND View:Type = 2

startdate and enddate are calculated fields set at the start of the report

This will find no results.  

However, 
If I remove sorting bands SB1 and SB2 then the report runs fine.

Or if I remove the "View:Type = 2" from the filter then the report also runs
fine.

I don't quite understand what is happening here.

What I want to be able to do is break a list of appointments into the year and
month they were made, with totals for each month.

Report Builder V3.36

Thanks.
09/19/2024 07:56 YF Yap wrote: 

If your database is SQL, then the sorting bands will always caused problem.
I normally set the view order manually.

RptInvoiceRT::View{Prop:Order} = '+INH:InvNo'

Name:
E-Mail: (will not be published)
Subject:Multiple sorting bands using same field


Message body:

Verification code:

Please, do not include any URLs into the message.
Otherwise, your message will be rejected and IP blacklisted automatically.
Off topic messages will be deleted by moderator.