I see why you're getting all your records back without limits.

Let's look at some pseudocode for your script:

Set @where variable = "WHERE "

if param1 not empty then

filter...

Yes.

The most significant difference between using Excel and a typical SQL data source is the data source type selection.

Before you start, make sure you have Excel Files set up as...

Why are you casting regdate as an int? You will be better off converting whatever is in regdate into some date format. Try CONVERT(DATETIME,regdate,101) AS REGDATE. That will...

I use the following query for a dataset gathering data from the Report Server database. It gets used in a report set to distribute by subscription each morning after...

This is by no means an optimal solution but it's the best I think there is right now.

Once your customers have generated the report to the screen and have clicked...

I don't believe there is (out of the box). if anybody does know a way to do it, that would be great.

Another option (especially if you've got a report with many expressions that could result in divide by zero situations is to use a Custom Code function.

In the Code...

Brandi,

I'll be very surprised if it's this simple but I'll ask anyway. Can't you use just the detail dataset and then group on product and month to let SSRS...

Here are some other links that may be helpful.

Expression examples: http://msdn2.microsoft.com/en-us/library/ms157328.aspx

Function Definitions: http://msdn2.microsoft.com/en-us/library/c157t28f(vs.71).aspx

Best Practices for reporting:

http://www.ssw.com.au/ssw/Standards/Rules/RulesToBetterSQLReportingServices.aspx

http://msdn2.microsoft.com/en-us/library/bb395166.aspx

Out of the box, this is not supported in SSRS. That being said, some in our company have had some limited success with creating macros and or .net applications...

I wonder if it just doesn't like * as a delimiter, trying to multiply something. Can you change it to something more traditional like a comma?

That syntax looks correct. What result are you getting?

Tammi Harris (11/28/2007)

---

I can't get the following to work:

=IIf(First(Fields!PositionType.Value, "devCECS")="3",false,true)

I want to show or hide depending on this text within the specificed field. The field may contain other values...