Hi-lite the row with the error in the expression and click the "Configure Error Output" button at the bottom of the dialog. What error information does it return?

Multiply the expression for your interactive sort by negative 1

Export it to a .csv file instead.

I don't believe you can truly disable a parameter. But you have a couple of possible options.

The first option would be to populate the available value of the undesired...

I have never tried this, and something in the back of my mind is telling me this won't work...but...Try to move the section you want to repeat on every page...

Ninja's_RGR'us (5/12/2011)

---

Hey nice script. I played with it and added the username of the subscription owner. Not too hard but might save some research!

SELECT

cat.[Name]...

2008 has a - for a 0 built in. When I choose it the expression it creates is:

0.00;(0.00);'-'

Try putting that in your format.

I don't really understand your issue. Are you trying to manipulate your dataset query to return the right data in both cases, or are you trying to display or...

I have not used but it seems to me that you need to return a status from the bat file in order for the task to know if the bat...

The short answer is yes, but the hard part is writing the dataset query that will behave properly. Probably you will have to build 2 mostly identical blocks of...

All report subscriptions are SQL Server Agent jobs. Find the job in SSMS, right click it and choose "Start Job at Step".

Unfortunately all report subscriptions jobs have a cryptic...

Create a permanent single column blank table for your multiple parameters. In the data driven portion of the subscription truncate the table then write the chosen or default parameters...

rock on dude:cool:

pumpkins

Set the PageBreakAtEnd property to True for the daily table. The page break should force the next table onto the next tab in the workbook.