Sorting a report by a variable

Rhonda

I have a complex report with several queries linked together and then numerous calculations using variables in the design.
After days of work getting it perfect the customer tells me he wants the report sorted by one of the variables which is a calculation based on the values from 2 sub queries

Before I rip the whole thing apart to get the calculated field into the query I thought I'd ask if there is a technique to sort a report based on the value of a variable on the Design page rather than the Sort tab of a query on the Data page.

Thanks in advance.

Rhonda Ridge

nicocizik

Hi Rhonda,

ReportBuilder simply outputs the data it is given so all sorting needs to be done during pre-processing (i.e. in the DB). The one exception is the crosstab component which sorts data internally however I'm uncertain this control will give you the output you are after.

Rhonda

I suspected as much. Thanks anyway