Showing posts with label guys. Show all posts
Showing posts with label guys. Show all posts

Wednesday, March 28, 2012

RSClientPrint Parameter Issues

Hi All

We're having a technical issue integrating the print reports into the portal. I'm hoping maybe some of your guys can help. We're using the RSClientPrint component to print the reports. The problem appears to be a conflict between the & in the URL and the & in the parameter value's cube reference. Below is an HTML code snippet. The 1st button works fine for us, it prints everything and has no & in the parameter's cube references. The second button references specific User and Employee values and therefore has & in the cube reference and generates an error. We tried encoding the & as & but it did not help. Thanks.

<html>
<body>


<OBJECT ID="RSClientPrint" CLASSID="CLSID:FA91DF8D-53AB-455D-AB20-F2F023E498D3"></OBJECT>

<script type="text/javascript">
function Print(ReportServer, ReportParameters, ReportTitle ) {
RSClientPrint.MarginLeft = .5 * 25.4;
RSClientPrint.MarginTop = .5 * 25.4;
RSClientPrint.MarginRight = .5 * 25.4;
RSClientPrint.MarginBottom = .5 * 25.4;
RSClientPrint.Culture = 1033;
RSClientPrint.UICulture = 1033;
RSClientPrint.PageWidth = 11 * 25.4;
RSClientPrint.PageHeight = 8.5 * 25.4;
RSClientPrint.Authenticate = false;
RSClientPrint.Print(ReportServer, ReportParameters, ReportTitle);
}

</script>


<button onclick="Print('http://localhost/reportserver', '/SA/SA.Report.6.Print&SessionSession=[Session].[Session].[All]&UserUser=[User].[User].[All]&TerritoryIdentifier=[Territory].[Identifier].[All]&EmployeeActiveFlag=[Employee].[Active Flag].[All]&EmployeeIdentifier=[Employee].[Identifier].[All]', 'SA.Report.6');"/>

<button onclick="Print('http://localhost/reportserver', '/SA/SA.Report.6.Print&SessionSession=[Session].[Session].&[1]&UserUser=[User].[User].&[1]&[1]&TerritoryIdentifier=[Territory].[Identifier].[All]&EmployeeActiveFlag=[Employee].[Active Flag].[All]&EmployeeIdentifier=[Employee].[Identifier].&[3356953]', 'SA.Report.6');"/>

</body>
</html>

Regards,

Nanda kumar R

&amp; is the encoding of & in xml, try using %26 which is the Url encoding of &.|||

Hi Daniel Reib,

Its working fine.

Thanks,

Regards,

Nanda kumar R

RSClientPrint Parameter Issues

Hi All

We're having a technical issue integrating the print reports into the portal. I'm hoping maybe some of your guys can help. We're using the RSClientPrint component to print the reports. The problem appears to be a conflict between the & in the URL and the & in the parameter value's cube reference. Below is an HTML code snippet. The 1st button works fine for us, it prints everything and has no & in the parameter's cube references. The second button references specific User and Employee values and therefore has & in the cube reference and generates an error. We tried encoding the & as &amp; but it did not help. Thanks.

<html>
<body>


<OBJECT ID="RSClientPrint" CLASSID="CLSID:FA91DF8D-53AB-455D-AB20-F2F023E498D3"></OBJECT>

<script type="text/javascript">
function Print(ReportServer, ReportParameters, ReportTitle ) {
RSClientPrint.MarginLeft = .5 * 25.4;
RSClientPrint.MarginTop = .5 * 25.4;
RSClientPrint.MarginRight = .5 * 25.4;
RSClientPrint.MarginBottom = .5 * 25.4;
RSClientPrint.Culture = 1033;
RSClientPrint.UICulture = 1033;
RSClientPrint.PageWidth = 11 * 25.4;
RSClientPrint.PageHeight = 8.5 * 25.4;
RSClientPrint.Authenticate = false;
RSClientPrint.Print(ReportServer, ReportParameters, ReportTitle);
}

</script>


<button onclick="Print('http://localhost/reportserver', '/SA/SA.Report.6.Print&SessionSession=[Session].[Session].[All]&UserUser=[User].[User].[All]&TerritoryIdentifier=[Territory].[Identifier].[All]&EmployeeActiveFlag=[Employee].[Active Flag].[All]&EmployeeIdentifier=[Employee].[Identifier].[All]', 'SA.Report.6');"/>

<button onclick="Print('http://localhost/reportserver', '/SA/SA.Report.6.Print&SessionSession=[Session].[Session].&[1]&UserUser=[User].[User].&[1]&[1]&TerritoryIdentifier=[Territory].[Identifier].[All]&EmployeeActiveFlag=[Employee].[Active Flag].[All]&EmployeeIdentifier=[Employee].[Identifier].&[3356953]', 'SA.Report.6');"/>

</body>
</html>

Regards,

Nanda kumar R

&amp; is the encoding of & in xml, try using %26 which is the Url encoding of &.|||

Hi Daniel Reib,

Its working fine.

Thanks,

Regards,

Nanda kumar R

sql

Friday, March 23, 2012

RS2005 Web ReportViewer: Unable to set parameters and ReportServerCredentials

Hey guys,
I'm using the report viewer web control in my web application. I got it
somewhat working but now I'm stuck:
1) I can't set the parameters for the report. When I call SetParameters and
pass a ReportParameter array, it complains that this report doesn't have
parameter 'XYZ'. But in reality it does. My suspicion was that the
ServerReport object is not filled with report data yet.
So I called GetParameters beforehand to see if it would initialize the
parameters collection. Then I found out that the parameters collection is
set to read-only, which means I can't set parameter values in an initialized
parameter collection.
Last try was to call SetParameters after calling GetParameters but I got the
same exception as when calling w/o GetParameters.
2) I need to pass ReportServerCredentials to RS because of course ASPNET
does not have access rights to RS. The only property that is not read-only
underneath the ReportServerCredentials property is the
ReportServerCredentials itself, which is of type IReportServerCredentials.
So far I couldn't find any credentials object that implements this
interface.
Anybody any idea?
Thanks, ChristophI have the same problem, did anyone ever respond to you?
"Christoph Wienands" wrote:
> Hey guys,
> I'm using the report viewer web control in my web application. I got it
> somewhat working but now I'm stuck:
> 1) I can't set the parameters for the report. When I call SetParameters and
> pass a ReportParameter array, it complains that this report doesn't have
> parameter 'XYZ'. But in reality it does. My suspicion was that the
> ServerReport object is not filled with report data yet.
> So I called GetParameters beforehand to see if it would initialize the
> parameters collection. Then I found out that the parameters collection is
> set to read-only, which means I can't set parameter values in an initialized
> parameter collection.
> Last try was to call SetParameters after calling GetParameters but I got the
> same exception as when calling w/o GetParameters.
> 2) I need to pass ReportServerCredentials to RS because of course ASPNET
> does not have access rights to RS. The only property that is not read-only
> underneath the ReportServerCredentials property is the
> ReportServerCredentials itself, which is of type IReportServerCredentials.
> So far I couldn't find any credentials object that implements this
> interface.
> Anybody any idea?
> Thanks, Christoph
>
>

Wednesday, March 7, 2012

RS inserts improper page breaks in report

Hi guys,
I try to find for an answer for this problem, but to no available, it drives
me crazy now.
I am getting a page break on each details row in a table. The table has 3
headers, one is a subreport, and a details row which contains a subreport;
there is no footers. The subreport in the details row contains another
subreport that has a table with 1 header and 1 details row, each has a
subreport. It's like so 3 levels deep.
My problem occurs in the first table, the subreport in the details line is
always generated on a new line. I check all the option with BreakPageAt End
and such, but everything is unchecked.
Any ideas.
Thanks!
RobertDo you have any grouping going on in the table? If so check the
grouping properties and see if you any of the 'page break' before or
after options set...
Cheers,
Ben|||There is the default group that is created but nothing is group on and both
'page break at start' and 'page break at bottom' are unchecked.
I don't know if it is relevant, but the page break only occurs when the
report is in 'print layout' mode.
Thanks!
Robert
sullins602 wrote:
>Do you have any grouping going on in the table? If so check the
>grouping properties and see if you any of the 'page break' before or
>after options set...
>Cheers,
>Ben|||Well, I did some more testing. By observation, it looks to me like RS
calculates all the rows in all my nested subreports, and if the number of
rows is bigger than the space left on the page, it assumes a break is needed.
Ouch.
Anybody else encoutered that?|||Yes we have this behaviour all the time and we raised a support incident with
Microsoft. They didn't want to know - as far as they are concerned it is
working as designed. They told us there is an implicit keeptogether on
anything within list but that using tables should be ok. Are you using lists
anywhere in your sub-reports?
"R Jakubowicz" wrote:
> Well, I did some more testing. By observation, it looks to me like RS
> calculates all the rows in all my nested subreports, and if the number of
> rows is bigger than the space left on the page, it assumes a break is needed.
>
> Ouch.
> Anybody else encoutered that?
>|||Hi Tom,
Yeah tell me about it.
Did you find a hack for it?
And no, i'm not using lists at all, I use tables though.
Tom wrote:
>Yes we have this behaviour all the time and we raised a support incident with
>Microsoft. They didn't want to know - as far as they are concerned it is
>working as designed. They told us there is an implicit keeptogether on
>anything within list but that using tables should be ok. Are you using lists
>anywhere in your sub-reports?
>> Well, I did some more testing. By observation, it looks to me like RS
>> calculates all the rows in all my nested subreports, and if the number of
>[quoted text clipped - 3 lines]
>> Anybody else encoutered that?
--
Message posted via http://www.sqlmonster.com

Saturday, February 25, 2012

RS and HTTPS

Hi Guys
Do you know:
Can you tell me if it's possible to use ONLY the Reporting Services section
of a web server on HTTPS and the rest of the web server on standard HTTP?
Thanks
DylanIf by 'the rest of the web server' you mean the Report Manager, then no.
Report Manager detects what the Report Server web interface is using and
adjusts accordingly.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dylan Kruger" <carmellobear1@.hotmail.com> wrote in message
news:ujc07edhEHA.3980@.TK2MSFTNGP12.phx.gbl...
> Hi Guys
> Do you know:
> Can you tell me if it's possible to use ONLY the Reporting Services
section
> of a web server on HTTPS and the rest of the web server on standard HTTP?
> Thanks
> Dylan
>