How to conditionally move field?

User enters a starting quarter and a year. I need to display 10 quarters and their years in line:
2005 . . . 2006
Q3 Q4 Q1 Q2 Q3 Q4 ...
Obviously, position of a year field will change based on whether we start from Q1 or from Q4.
Is there a way to do it?I'd probably put each variation in different sections and suppress each section accordingly.
Alternatively, use a non-proportional font and build up a string to display the year values with front space padding as required.

how to conditionally get the data

Hi,

In Reporting Service, how to conditionally get the data? Let's say, I don't want the line

when the Status field is "inactive" and Eff_Date<"1/1/2006"

I conditionally hided the Visibility of this line. But when i tried to get the subtotal, this line's Quantity info still was included into the subtotal.

I tried to use the Filter box of the dataset to do it, but don't know how.

Can anybody please help me out?

Thanks a lot.

What kind of datasource are you using?

How to conditionally create Flat File Destination for Lookup Redirects

Hi all,

I am redirecting the critical lookup errors to the flat files. These flat files got created regardless if there are lookup errors or not.

Is there a better way to conditionally create them only when there are lookup errors?

Thanks.

Its not really possible, no.

What you could do is count the number of records (using a ROWCOUNT component). Then, probably in the OnPostExecute eventhandler for the data-flow, delete the file if the rowcount is zero.

Or you could push everything into a recordset destination and then, in the eventhandler, push the stuff into a flat file IF the rowcount is greater than zero.

-Jamie