Yes I'm using the data pane but I need to check if the @Location parameter has been entered yet. If it is use it in the WHERE clause, otherwise don't.

This...

But if @Date or @DateRange is empty wouldn't that crap out? Also, this looks like something from a stored procedure or query analyzer, I don't think this syntax would work...

The If statements you wrote are the correct logic, the problem is that I'm writing this in the Data pane of Visual Studio and the syntax is iif, not the...

You can right-click in the "Fields" window in the left pane and Add your fields one at a time manually. If you have multiple fields with the same name you'll...

Check your URL address when you try to open your report, it must point to

http://epm.misnet.com.ph/epmreports. It point to your internal RS, that's why you can

not open report from...

Hi eyal,

I too am about to make a custom installer. In .NET you can use Process() to execute rs.exe and pass variables. The problem I'm having is how to...

resolved:

Check your IE address when you open your report, it must point to

http://yourserver/reports. It point to your internal RS, that's why you can

not open report from internet. It...

Here's a good explaination:

http://www.sqlservercentral.com/columnists/bknight/reportingservicesconditionalformatting.asp

Greg

For starters, look into the rs.exe for deploying. Then you can incorporate that into your code. This is what I will be doing and I'll try to do this with...

Hi David,

I was watching this thread because I too was thinking of writing a windows script to help with deployment. I'm new to C# and was wondering if you could...

Hi Imran,

I am also using the reportviewer control. For the ServerURL and ReportPath properties, I am getting these settings from my web.config file for ease of implementation from development to...