all groups > sql server reporting services > july 2004 >
sql server reporting services :
Parameters through URL, Pie Chart area padding, and PDF formatting
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
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] "MSNews" <coronaride@yahoo.com> wrote in message news:eWvD881cEHA.2268@TK2MSFTNGP12.phx.gbl... > 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, 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]" <brianhartman@hotmail.com> wrote in message news:udhkwX4cEHA.2236@TK2MSFTNGP10.phx.gbl... > 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 > > "MSNews" <coronaride@yahoo.com> wrote in message > news:eWvD881cEHA.2268@TK2MSFTNGP12.phx.gbl... > > 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 > > > > > >
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] "Abdul Malik Said" <diplacusis@hotmNOSPAMail.com> wrote in message news:eDP$%23K7cEHA.3512@TK2MSFTNGP12.phx.gbl... > 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 > > "Brian Hartman [MSFT]" <brianhartman@hotmail.com> wrote in message > news:udhkwX4cEHA.2236@TK2MSFTNGP10.phx.gbl... > > 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 > > > > "MSNews" <coronaride@yahoo.com> wrote in message > > news:eWvD881cEHA.2268@TK2MSFTNGP12.phx.gbl... > > > 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 > > > > > > > > > > > >
Don't see what you're looking for? Try a search.
|
|
|