Groups | Blog | Home
all groups > sql server reporting services > july 2004 >

sql server reporting services : Parameters through URL, Pie Chart area padding, and PDF formatting



MSNews
7/26/2004 3:18:40 PM
I have an application with three different issues.

First of all, to open my report the users click on a user-specific asp.net
formatted URL that contains the parameters. When the report opens, it
displays the parameter names with the parameter values at the top. Is there
a way to get rid of this bar or even just have it default to hidden? I know
that the user could forge a URL to potentially access a different report,
but I just don't want them to be able to have incredibly easy "type here to
access someone else's report" kind of access. I also know that this can be
hidden by unchecking the parameter prompt option under the report manager,
but that defeats the whole purpose, as I wouldn't be able to pass a
user-specific parameter at all.

Secondly, is there any way to change the amount of padding around a pie
chart other than resizing the whole chart area itself? It seems like no
matter how big or small I make it, there is an incredibly large amount of
whitespace around the chart and legend.

Thirdly, when I export the report to a PDF, a few of the table rows bleed
off of the first page. I'm ok with it not fitting all on one page, but for
some reason, it's putting a whole blank page in before it continues the rest
of the table on the third page. Anyone know why this would happen?

thanks,
Casey

Brian Hartman [MSFT]
7/26/2004 8:00:55 PM
You can hide the entire parameters area by adding rc:parameters=false to the
URL. In SP1, if you want to hide just some of the parameters, then in
Report Manager, keep the Prompt option checked by set the prompt string to
an empty string.

Keep in mind that none of these options are secure. Hiding a parameter does
not enforce any security. To be secure, you should base your report on the
User!UserID parameter.

--
This posting is provided "AS IS" with no warranties, and confers no rights

[quoted text, click to view]

Abdul Malik Said
7/27/2004 9:20:16 AM
Brian,

I have the instructions to hide some parameters using SP1. Unfortunately
when I have a mix of hidden and shown parameters, I get:

"A Runtime Error has occurred. Do you wish to debug?
Line: 80
Error: Object Required"

When I debug the error in MS Script Editor, it takes me to the following
code:

// Update the state of a nullable parameter.
function UpdateParam(nullChkBox)
{
// If the null checkbox itself is not enabled, don't change the state
// of the parameter controls. The null check box is disabled when
// a data driven parameter has outstanding dependencies
if (nullChkBox.disabled)
return;

This only happens when I have some hidden and some shown parameters. Am I
doing something wrong?

Thanks,
Abdul Malik Said

[quoted text, click to view]

Brian Hartman [MSFT]
7/27/2004 10:14:12 AM
You are not doing anything wrong. This is a known bug. This happens when
you hide a parameter that normally has a null check box. If the parameter
does not need to be nullable, making it non-nullable will fix the problem.
Otherwise there is no workaround.

--
This posting is provided "AS IS" with no warranties, and confers no rights

[quoted text, click to view]

AddThis Social Bookmark Button