It is recommended to use one query using JOINS, but if that is not possible, you can use LOOKUP in SSRS 2008 R2. Lookup is not available in SSRS 2008...

I tried both Covering Index as well as Derived Table options, but no use :crying:

Here is my actuall query:

DECLARE @varBegin_Date datetime

DECLARE @varEnd_Date datetime

DECLARE @varCoSub varchar(100)

DECLARE @varPIC int

DECLARE @varStatus varchar(10)

DECLARE @varInvoice_Status...

This behaviour is not with any specific report, this happen with any report on server. And since the same report works fine sometime, I'm sure it is nothing to do...

That is exactly what i did, and it work.

But what I want is to hide Header completely like if you unselect Page Header from Report Properties.

What happening is when...

There is no direct way to set Page Orientation in SSRS 2000. You can do this in "Report Properties", select "Layout" tab, and set the following properties like:

Page Width =...

Instead of using 0, trying using "Nothing", like:

=IIF(ReportItems!DataRow2_Floorspace_Total.Value <> Nothig, .....

Hope this will help.

The report will remain the same and in same window, only thing that will change is sorting.

It wouldn't effect printing at all, whatever you see on screen is what...

If you are using SSRS 2000, there is no functionality, but there is a way around that works great!

Here is what you need to do:

Create a internal report parameter with...

Take a look at these sites:

http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/rsdepgd.mspx

http://www.awprofessional.com/articles/article.asp?p=357694&rl=1

Hopefully these will answer all your questions (regarding SSRS )

John,

Look at  my post here:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=150&messageid=275181

May be it help!!

Never mind found the solution.

For those having the issue:

In IIS, ReportServer application mapping should have this one entry:

"..\Microsoft.NET\Framework\v1.1.4322\aspnet_isapi.dll" for Extension = * and All Verbs = Ture.

Huhhh....

Well it depends what your setup is, because Integrated Windows authentication only works with IE, not with Netscape and other browsers. It worked for me because we were in an...

Well, SSL is the standard for secure websites now a day.

We have also used SSL for one of our...

"Although SQL Server Reporting Services is not expressly designed for Internet report deployment scenarios, you can successfully place Reporting Services on an Internet-facing Web server ................."

I think you are talking about Query Deisgner, not GENERIC Query Designer, anyways, you can just modify you query in any of the pane and other panes will automatically reflects...