Showing posts with label header. Show all posts
Showing posts with label header. Show all posts

Friday, March 30, 2012

Remove header using URL access

I have a report that has parameters. The report is called from a webpage using URL access. I know how to remove the toolbar or parameters with "&rc:Toolbar=false or &rcStick out tonguearameters=false". I want to remove only the header which displays SQL Server Report Services, the folder it is found in, the report name, Home | My Subscription | Help , Search for box, and the tabs (View, Properties, History, and Subscriptions). I cannot find an URL access parameter that will only remove this header information. I want to keep the parameter box and the toolbar. Does anyone have any ideas on the subject?

Fred

For this type of customization of report manager, you will probably need to create your own application in Visual Studio 2005 and use a report viewer.

Report manager is not very customizable.

|||

How difficult would it be to write a program to display the parameters like Reporting Services does and to use the selected parameter to refresh the report like Reporting Services does? Any samples?

Fred

|||

You can do this by linking to the report via the reportserver virtual directory rather than the report manager.

Try navigating to http://<your_server>/reportserver and then click through to your report. You will see that the report parameters and toolbar are still visible. Copy the URL and get your application to link to that instead.

|||

Adam,

Yes, this displays the parameters and toolbar, but it also displays the header information which is above the parameter section. I do not want my endusers to see this information ( as mentioned in the first post in this series). This information allows the user to navigate Report Manager which will confuse them. I only want them to see the report with the parameters and toolbar.

Fred

|||

Fred,

Can I suggest that you actually try the solution or read the post properly before commenting!

My suggestetion is based on a live system and I assure you it delivers exactly what you have desribed.

When I navigate to my report using the following URL https://servername/reportserver?%2fReports%2fReport+1&rs:Command=Render

I see this:

If I add &rc: parameters=collapsed to the URL I get this:

I popup my window from a piece of javascript where I use the following code:

Code Snippet

function openReport(name, parameters)

{

if(typeof(parameters) == "undefined") parameters = "";

var encodedName = name;

while(encodedName.indexOf(" ") != -1)

{

encodedName = encodedName.replace(" ", "+");

}

encodedName = escape(encodedName);

var URL = "/reportserver?%2fReports%2f"
+ encodedName
+ "&rs:Command=Render&rc:parameters=collapsed"
+ parameters;

var features = "resizable=yes"
+ ",location=no"
+ ",menubar=no"
+ ",status=no"
+ ",toolbar=no"
+ ",width=" + screen.width
+ ",height=" + screen.height
+ ",top=0"
+ ",left=0";


window.open(URL, "", features).focus();

return true;

}

|||

Adam,

I apologize. I did not read your post correctly. I was using Report Manager and navigated to my report from the home page. Once I used the ReportServer directory I saw that it was exactly what I wanted.

Thank you,

Fred

Remove header using URL access

I have a report that has parameters. The report is called from a webpage using URL access. I know how to remove the toolbar or parameters with "&rc:Toolbar=false or &rcStick out tonguearameters=false". I want to remove only the header which displays SQL Server Report Services, the folder it is found in, the report name, Home | My Subscription | Help , Search for box, and the tabs (View, Properties, History, and Subscriptions). I cannot find an URL access parameter that will only remove this header information. I want to keep the parameter box and the toolbar. Does anyone have any ideas on the subject?

Fred

For this type of customization of report manager, you will probably need to create your own application in Visual Studio 2005 and use a report viewer.

Report manager is not very customizable.

|||

How difficult would it be to write a program to display the parameters like Reporting Services does and to use the selected parameter to refresh the report like Reporting Services does? Any samples?

Fred

|||

You can do this by linking to the report via the reportserver virtual directory rather than the report manager.

Try navigating to http://<your_server>/reportserver and then click through to your report. You will see that the report parameters and toolbar are still visible. Copy the URL and get your application to link to that instead.

|||

Adam,

Yes, this displays the parameters and toolbar, but it also displays the header information which is above the parameter section. I do not want my endusers to see this information ( as mentioned in the first post in this series). This information allows the user to navigate Report Manager which will confuse them. I only want them to see the report with the parameters and toolbar.

Fred

|||

Fred,

Can I suggest that you actually try the solution or read the post properly before commenting!

My suggestetion is based on a live system and I assure you it delivers exactly what you have desribed.

When I navigate to my report using the following URL https://servername/reportserver?%2fReports%2fReport+1&rs:Command=Render

I see this:

If I add &rc: parameters=collapsed to the URL I get this:

I popup my window from a piece of javascript where I use the following code:

Code Snippet

function openReport(name, parameters)

{

if(typeof(parameters) == "undefined") parameters = "";

var encodedName = name;

while(encodedName.indexOf(" ") != -1)

{

encodedName = encodedName.replace(" ", "+");

}

encodedName = escape(encodedName);

var URL = "/reportserver?%2fReports%2f"
+ encodedName
+ "&rs:Command=Render&rc:parameters=collapsed"
+ parameters;

var features = "resizable=yes"
+ ",location=no"
+ ",menubar=no"
+ ",status=no"
+ ",toolbar=no"
+ ",width=" + screen.width
+ ",height=" + screen.height
+ ",top=0"
+ ",left=0";


window.open(URL, "", features).focus();

return true;

}

|||

Adam,

I apologize. I did not read your post correctly. I was using Report Manager and navigated to my report from the home page. Once I used the ReportServer directory I saw that it was exactly what I wanted.

Thank you,

Fred

sql

Monday, March 26, 2012

Remove "blank" space?

I have a report that contains a table with two rows. Each of these rows
contains a table with a header row, detail row and footer row. When the
report loads, these inner tables expand to 5-20 rows of data. All well and
good. However, sometimes the top inner table has no data to render. But when
the report renders, this space is blank (the height of the row of the outer
table). So there's a big gap of whitespace at the top of the report.
Is there any way to have this space shrink to nothing (or nearly nothing)?
Or at least very small? I can't seem to find any way to make this happen.
Thanks,
Ripleywrite an expression on the visibilty expression
"Ripley" <ripley@.ihatespam.com> wrote in message
news:epyIiUg0GHA.4228@.TK2MSFTNGP06.phx.gbl...
>I have a report that contains a table with two rows. Each of these rows
>contains a table with a header row, detail row and footer row. When the
>report loads, these inner tables expand to 5-20 rows of data. All well and
>good. However, sometimes the top inner table has no data to render. But
>when the report renders, this space is blank (the height of the row of the
>outer table). So there's a big gap of whitespace at the top of the report.
> Is there any way to have this space shrink to nothing (or nearly nothing)?
> Or at least very small? I can't seem to find any way to make this happen.
> Thanks,
> Ripley
>sql