This Problem was in Jun'08 do you this I'm still Struggling with same problem..?

Instead of adding visible & invisible condition. Just add page break "before" second table.

As I'm working on SQL Server 2008 Reporting Services. Export to Excel file with tab names are not yet implemented. :hehe:

These Global Variables can be used only in the page header and page footer. 🙂

Use Following expression

="Page No. " + cstr(Globals!PageNumber) + " of " + cstr(Globals!TotalPages)

Good Luck

Sandip Shinde

I also tried for this finicality. But it seems that Export is finicality which is completely coded by Microsoft & while Executing/Exporting report we have any control on this.

Let...

You are working on file some one created right.

First thing if Command Type = Test then there should be some SQL Query in CommandText.

If command Type = SP then there...

Don't go to properties...

As per my instructions.. RIGHT CLICK on Column Header. & got to Column Visibility.

Ok VS 2003 is your development environment. Let me know which SQL Server you are using..?

Any ways I just checked with my project & in my Matrix table.

Right Click on...

I know only three versions or SSRS i.e. 2000, 2005 & 2008

I don't how how you are working on SSRS 2003.

Let me know the correct version which you are working...

Hi,

// Ensure Directory Security settings for default web site in IIS is "Windows Authentication".

string url = "http://localhost";

// Create a 'HttpWebRequest' object with the specified url.

HttpWebRequest myHttpWebRequest = (HttpWebRequest)WebRequest.Create(url);

//...

Meghna,

You can use column visiblity with your expression(condition) to hide columns in SSRS Reports.

I hope this will suit your requirement.

Let me know if you have any queries.

wish u all the...

First make it in your mind that you can give access to same domain users only.

This is possible by using Reporting Services Web Service Interface.

i.e. http://ReportServerName/ReportServer/ReportService.asmx

By using...

=Dataset("dataSetName").CommandText.ToString()

This is not available at Local Mode..

Please refer following link

http://www.sqlservercentral.com/Forums/Topic539264-150-1.aspx

Wish you all the best

Sandip