Deserialization Failed: developed

Showing posts with label developed. Show all posts

Wednesday, March 28, 2012

ReportViewer control doesn't accept Parameters

Hello,
I have developed a web application that uses ReportViewer Web control
supplied with VS 2005 RTM version. The ReportViewer control uses
Network credentials to connect to a remote SQL 2005 server to get the
reports. It works fine for reports that doesn't use any parameters.
But, for the reports that accepts parameters, the reportviewer control
doesn't seem to read the Parameters selected from the drop-down box.
When I click on the "ViewReport" button the report just reloads with
the initial/default parameter. Can someone please advise if I'm missing
anything here?
PS: All the other options of the control works fine (ie., export,
refresh, page navigation, subreports, document map, etc).I have the same problem so we must both be missing something.
Chris
"Raghu" wrote:
> Hello,
> I have developed a web application that uses ReportViewer Web control
> supplied with VS 2005 RTM version. The ReportViewer control uses
> Network credentials to connect to a remote SQL 2005 server to get the
> reports. It works fine for reports that doesn't use any parameters.
> But, for the reports that accepts parameters, the reportviewer control
> doesn't seem to read the Parameters selected from the drop-down box.
> When I click on the "ViewReport" button the report just reloads with
> the initial/default parameter. Can someone please advise if I'm missing
> anything here?
> PS: All the other options of the control works fine (ie., export,
> refresh, page navigation, subreports, document map, etc).
>|||Hey Ragu, I think I've figured it out.
I was setting the network credentials on each page load instead of the first
time the page was loaded.
I had a look at the ReportViewer code through .NET Reflector and found some
code that indicated that parameter values where not read when the credentials
changed.
Chris
"Raghu" wrote:
> Hello,
> I have developed a web application that uses ReportViewer Web control
> supplied with VS 2005 RTM version. The ReportViewer control uses
> Network credentials to connect to a remote SQL 2005 server to get the
> reports. It works fine for reports that doesn't use any parameters.
> But, for the reports that accepts parameters, the reportviewer control
> doesn't seem to read the Parameters selected from the drop-down box.
> When I click on the "ViewReport" button the report just reloads with
> the initial/default parameter. Can someone please advise if I'm missing
> anything here?
> PS: All the other options of the control works fine (ie., export,
> refresh, page navigation, subreports, document map, etc).
>

ReportViewer and Firefox

Running into a weird problem and wanted to see if anyone else had run into it before. I developed a simple web application using the ReportViewer component with an rdlc report. When I run the project through the development web server in VS, everything looks ok in both Firefox and IE 7. I then deployed the app to a test IIS 6 machine. Looks ok in IE 7, but in Firefox (2.0.0.6, the same one I viewed the test with), the data is all compressed to the left and isn't really readable. Exporting the report (PDF or Excel) looks fine. Anyone have any ideas?

I've run into the same problem.

FireFox seems to have issues with all the nesting in the table structure. I've seen a post about adding a blank textbox in the header set to the width of the report as a fix, haven't had a chance to try it out yet......

Burl

|||

Well, the weird thing, like I said, is that the same application on the dev server in VS 2005 runs just fine in Firefox. It's just when it goes to a test "production" IIS 6 box that it starts acting weird.

|||

Found this post, have to try it out later....

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=83322&SiteID=1

Burl

|||

Setting the page header to can't shrink or grow seems to have worked for me. Still strange that it doesn't show problems in both instances.

|||

Hi!

Have you seen this link?:http://msdn2.microsoft.com/en-us/library/ms156511.aspx

Cheers,

Monday, March 26, 2012

ReportViewer 2.0 Control with Credentials Problem

I have developed a web app that uses forms authentication. I wrote it in
asp.net 2.0. My server is running windows 2003 server standard and IIS. I
have also installed on the same machine SQL Server 2005 with Reporting
Services.
From my webapplication, I have a button that the user can click and then I
have the Report Viewer control generate a report. However, I do not know how
to pass the proper credentials to the report server. I would like to pass
one username and password that has permissions to run that report. My code
is follows:
Private Sub saveRptAs(ByVal s_rptType As String)
Dim warnings As Microsoft.Reporting.WebForms.Warning()
Dim streamids As String()
Dim mimeType As String
Dim encoding As String
Dim extension As String
ReportViewer1.ServerReport.ReportServerUrl = New
Uri("http://myserver/reportserver")
ReportViewer1.ServerReport.ReportPath = "/reports/Individual Report"
Dim test As New NetworkCredential("localuser", "password", "domain")
ReportViewer1.ServerReport.ReportServerCredentials = test
Dim rprameter As ReportParameter = New ReportParameter("user_no",
Profile.DTGVariables.SelectedYMNo)
Me.ReportViewer1.ServerReport.SetParameters(New ReportParameter()
{rprameter})
Dim bytes As Byte() = ReportViewer1.ServerReport.Render(s_rptType,
Nothing, mimeType, encoding, extension, streamids, warnings)
Response.Buffer = True
Response.Clear()
Response.ContentType = mimeType
Response.AddHeader("content-disposition", "attachment;
filename=sample." + extension)
Response.BinaryWrite(bytes)
Response.Flush()
Response.End()
End Sub
When I click on the button I get the following message:
Unable to cast object of type 'System.Net.NetworkCredential' to type
'Microsoft.Reporting.WebForms.IReportServerCredentials'.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.
Exception Details: System.InvalidCastException: Unable to cast object of
type 'System.Net.NetworkCredential' to type
'Microsoft.Reporting.WebForms.IReportServerCredentials'.
Can someone help me with the credentials issue? Do I need to change
Reporting Services to use Forms Authentication?
Your help and insight is greatly appreciated.
Thanks
Nate DoggYou have to create a class that inherits from IReportServerCredentials
interface.
read this post:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=157916&SiteID=1
"Nate Dogg" wrote:
> I have developed a web app that uses forms authentication. I wrote it in
> asp.net 2.0. My server is running windows 2003 server standard and IIS. I
> have also installed on the same machine SQL Server 2005 with Reporting
> Services.
> From my webapplication, I have a button that the user can click and then I
> have the Report Viewer control generate a report. However, I do not know how
> to pass the proper credentials to the report server. I would like to pass
> one username and password that has permissions to run that report. My code
> is follows:
> Private Sub saveRptAs(ByVal s_rptType As String)
> Dim warnings As Microsoft.Reporting.WebForms.Warning()
> Dim streamids As String()
> Dim mimeType As String
> Dim encoding As String
> Dim extension As String
> ReportViewer1.ServerReport.ReportServerUrl = New
> Uri("http://myserver/reportserver")
> ReportViewer1.ServerReport.ReportPath = "/reports/Individual Report"
>
> Dim test As New NetworkCredential("localuser", "password", "domain")
> ReportViewer1.ServerReport.ReportServerCredentials = test
> Dim rprameter As ReportParameter = New ReportParameter("user_no",
> Profile.DTGVariables.SelectedYMNo)
> Me.ReportViewer1.ServerReport.SetParameters(New ReportParameter()
> {rprameter})
> Dim bytes As Byte() = ReportViewer1.ServerReport.Render(s_rptType,
> Nothing, mimeType, encoding, extension, streamids, warnings)
> Response.Buffer = True
> Response.Clear()
> Response.ContentType = mimeType
> Response.AddHeader("content-disposition", "attachment;
> filename=sample." + extension)
> Response.BinaryWrite(bytes)
> Response.Flush()
> Response.End()
> End Sub
> When I click on the button I get the following message:
> Unable to cast object of type 'System.Net.NetworkCredential' to type
> 'Microsoft.Reporting.WebForms.IReportServerCredentials'.
> Description: An unhandled exception occurred during the execution of the
> current web request. Please review the stack trace for more information about
> the error and where it originated in the code.
> Exception Details: System.InvalidCastException: Unable to cast object of
> type 'System.Net.NetworkCredential' to type
> 'Microsoft.Reporting.WebForms.IReportServerCredentials'.
>
> Can someone help me with the credentials issue? Do I need to change
> Reporting Services to use Forms Authentication?
> Your help and insight is greatly appreciated.
> Thanks
> Nate Dogg
>

Tuesday, March 20, 2012

reports problem

I developed an application using VB.NET and ODBC connection to SAGE/SWAN DB files, part of the application searches for .rpt files on the drive and shows the found reports as a list. When the user clicks on one of them the report should open (after asking for parameters!)

Before my application the reports were created using Crystal 7 and used to be viewed with Crystal Passage.

Problem 1: Why does the report always ask for a Username and Password? Is this setting coming from the report or the connection?

Problem 2: After inputting the admin password i keep getting the error: "Failed to open a rowset"

Thanks and should you need any more info let me know1 you need to supply those info from VB.Net
2 Make sure the report is pointing to the relevent database|||Well these reports were created as stand alone reports using Crystal 7 and/or 10 with an ODBC connection to a SAGE database (files). The reports were never opened through a VB application.... but were used on their own!

What I am trying to do is to call a report from a VB.NET application. And I have the following code:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnOK.Click
If Me.ListView1.SelectedItems.Count <> 0 Then
Dim ReportName As String
ReportName = Me.ListView1.SelectedItems(0).Text

Dim frm As New frmViewer
frm.CrystalReportViewer1.ReportSource = ConfigurationSettings.AppSettings("DirPath") & ReportName & ".rpt"
frm.Show()
End If
End Sub

the red line gets the file path (C:\test\myReport.rpt) of the specified report.

The main thing I want in this application is that the user would not need to add any code for a new report..... he would just have to throw the report in a specified directory and select it from there.

Thanks

Monday, March 12, 2012

Reports deployed to Standard edition RS and SQL Server

Hello,
We have successfully developed the reports on our testing machine with SQL Server 2000 Enterprise + Reporting Services 2000 Enterprise. Is there any problem if we deploy the reports to the production machine that runs SQL Server 2000 Standard and Reporting Services 2000 Standard?

Thanks in advance!

Here is some info on licensing:

http://msmvps.com/blogs/anguslogan/archive/2004/10/03/14788.aspx

The report RDL files should be the same in both environments so you should not have any problems.

cheers,

Andrew

Reports cannot be exported to csv format

Hi,

We have developed few reports through SQL Server Reporting Service 2005.
All those reports are columnar graphs (BAR charts).
One of the requirement of the project is to have the ability to export the report in different formats.
Since our reports are columnar graphs we are unable to export it to CSV or MHTML format.
Is there are setting in the report, which allows me to display the values, when exported to csv format?
also is there any setting for MHTML format. Some machine open the report in MHTML format and some machine does not.

Any help would be appreciated.

Thanks in advance!

No replies yet:(

The only solution we can think about is to develop those many reports in tabular format. (only for CSV format)

Any other solution available?

Thanks!

|||

CSV output should include Chart Data. http://msdn2.microsoft.com/en-us/library/aa178937(SQL.80).aspx

If you are not getting data, make sure to set DataElementOutput to true. Here is a link to how it works for XML.

http://msdn2.microsoft.com/en-us/library/aa179497(SQL.80).aspx

|||

Even I read the first MSDN link where it mentions charts can be rendered to CSV. Thats why I am a bit sure that there may be some setting in the properties, which will show the data values in CSV.

I also tried the setting mentioned in the CSV Device Information Settings and mentioned Encoding value for CSV as ASCII. Restarted SQL Server.

I also set the DataElementOutput property to "Output" but still I am not able to see the expected result.

Please do let me know if there is any solution available.

Thanks!

|||

Chart Data is supposed to be exported to CSV.

Can you attach the report definition so I can take a look and diagnose the problem?

Thanks!

|||

Hi Denis,

Following is the report definition. Hope to find some solution to my problem.

Thanks in advance!

<?xml version="1.0" encoding="utf-8"?>
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<DataSources>
<DataSource Name="ML_OLAP_DS">
<DataSourceReference>ML_OLAP_DS</DataSourceReference>
<rd:DataSourceID>2e071b5e-2d8d-4aab-94ff-edf8900886a2</rd:DataSourceID>
</DataSource>
</DataSources>
<BottomMargin>1in</BottomMargin>
<RightMargin>1in</RightMargin>
<ReportParameters>
<ReportParameter Name="startDate">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>[DATE].[Startdate].[All]</Value>
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>Start Date</Prompt>
</ReportParameter>
<ReportParameter Name="endDate">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>[DATE].[Startdate].[All]</Value>
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>End Date</Prompt>
</ReportParameter>
<ReportParameter Name="users">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>[USERS].[WINDOWS LOGON NAME].[All]</Value>
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>Users</Prompt>
</ReportParameter>
<ReportParameter Name="appName">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>[APPLICATIONS].[APPLICATION NAME].[All]</Value>
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>Applications</Prompt>
</ReportParameter>
<ReportParameter Name="chartTitle">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>Ten Most Used Applications</Value>
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>Chart Title</Prompt>
</ReportParameter>
</ReportParameters>
<rd:DrawGrid>true</rd:DrawGrid>
<InteractiveWidth>8.5in</InteractiveWidth>
<rd:SnapToGrid>true</rd:SnapToGrid>
<Body>
<ReportItems>
<Chart Name="MostUsedAppChart">
<Legend>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Position>RightCenter</Position>
</Legend>
<Subtype>Plain</Subtype>
<Title>
<Caption>=RTRIM( Parameters!chartTitle.Value)</Caption>
<Style>
<FontFamily>Arial Black</FontFamily>
</Style>
</Title>
<NoRows>The current report criteria does not satisfy any records.</NoRows>
<Height>6.125in</Height>
<CategoryAxis>
<Axis>
<Title>
<Caption>Applications</Caption>
<Style>
<FontFamily>Arial Black</FontFamily>
</Style>
</Title>
<MajorGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MajorGridLines>
<MinorGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MinorGridLines>
<MajorTickMarks>Outside</MajorTickMarks>
<Min>0</Min>
<Visible>true</Visible>
</Axis>
</CategoryAxis>
<PointWidth>0</PointWidth>
<Left>0.125in</Left>
<ThreeDProperties>
<Rotation>30</Rotation>
<Inclination>30</Inclination>
<Shading>Simple</Shading>
<WallThickness>50</WallThickness>
</ThreeDProperties>
<DataSetName>MostUsedAppDS</DataSetName>
<SeriesGroupings>
<SeriesGrouping>
<StaticSeries>
<StaticMember>
<Label>Value1</Label>
</StaticMember>
</StaticSeries>
</SeriesGrouping>
</SeriesGroupings>
<PlotArea>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<BackgroundColor>LightGrey</BackgroundColor>
</Style>
</PlotArea>
<ValueAxis>
<Axis>
<Title>
<Caption>Occurences</Caption>
<Style>
<FontFamily>Arial Black</FontFamily>
</Style>
</Title>
<MajorGridLines>
<ShowGridLines>true</ShowGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MajorGridLines>
<MinorGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MinorGridLines>
<MajorTickMarks>Outside</MajorTickMarks>
<Min>0</Min>
<Margin>true</Margin>
<Visible>true</Visible>
<Scalar>true</Scalar>
</Axis>
</ValueAxis>
<Type>Column</Type>
<Width>4.5375in</Width>
<CategoryGroupings>
<CategoryGrouping>
<DynamicCategories>
<Grouping Name="chart1_CategoryGroup1">
<GroupExpressions>
<GroupExpression>=Fields!APPLICATION_NAME.Value</GroupExpression>
</GroupExpressions>
</Grouping>
<Label />
</DynamicCategories>
</CategoryGrouping>
</CategoryGroupings>
<Palette>Default</Palette>
<ChartData>
<ChartSeries>
<DataPoints>
<DataPoint>
<DataValues>
<DataValue>
<Value>=Sum(Fields!APPLICATION_INSTANCES_VIEW_Count.Value)</Value>
</DataValue>
</DataValues>
<DataLabel>
<Style>
<FontSize>8pt</FontSize>
</Style>
<Value>=Fields!APPLICATION_INSTANCES_VIEW_Count.Value</Value>
<Visible>true</Visible>
</DataLabel>
<Marker>
<Size>6pt</Size>
</Marker>
</DataPoint>
</DataPoints>
</ChartSeries>
</ChartData>
<Style>
<BackgroundColor>White</BackgroundColor>
</Style>
</Chart>
</ReportItems>
<Height>7.875in</Height>
</Body>
<rd:ReportID>a7bd15d4-cace-4fe8-b2d3-62bc6fc786a8</rd:ReportID>
<LeftMargin>1in</LeftMargin>
<DataSets>
<DataSet Name="MostUsedAppDS">
<Query>
<rd:SuppressAutoUpdate>true</rd:SuppressAutoUpdate>
<CommandText>WITH
MEMBER [DATE].[StartDate].[DateRange] AS
AGGREGATE
( STRTOMEMBER(@.startDate) : STRTOMEMBER(@.endDate), [Measures].CURRENTMEMBER
)
MEMBER [USERS].[WINDOWS LOGON NAME].[UserName] AS
AGGREGATE
( {STRTOSET(@.users)} )
SELECT
NON EMPTY { [Measures].[APPLICATION INSTANCES VIEW Count] } ON COLUMNS,
NON EMPTY TopCount ( Filter ( {[APPLICATIONS].[APPLICATION NAME].[APPLICATION NAME]}, [Measures].[APPLICATION INSTANCES VIEW Count] >= 0 ) , 10, [Measures].[APPLICATION INSTANCES VIEW Count] ) ON ROWS
FROM
(select STRTOSET(@.appName) on 0 from [ApplicationUsage] )
WHERE
(([USERS].[WINDOWS LOGON NAME].[UserName]),[DATE].[StartDate].[DateRange])</CommandText>
<QueryParameters>
<QueryParameter Name="startDate">
<Value>=Parameters!startDate.Value</Value>
</QueryParameter>
<QueryParameter Name="endDate">
<Value>=Parameters!endDate.Value</Value>
</QueryParameter>
<QueryParameter Name="users">
<Value>=Parameters!users.Value</Value>
</QueryParameter>
<QueryParameter Name="appName">
<Value>=Parameters!appName.Value</Value>
</QueryParameter>
<QueryParameter Name="chartTitle">
<Value>=Parameters!chartTitle.Value</Value>
</QueryParameter>
</QueryParameters>
<DataSourceName>ML_OLAP_DS</DataSourceName>
<rd:MdxQuery><QueryDefinition xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://schemas.microsoft.com/AnalysisServices/QueryDefinition"><CommandType>MDX</CommandType><Type>Query</Type><QuerySpecification xsi:type="MDXQuerySpecification"><Select><Items><Item><ID xsi:type="Level"><DimensionName>APPLICATIONS</DimensionName><HierarchyName>APPLICATION NAME</HierarchyName><HierarchyUniqueName>[APPLICATIONS].[APPLICATION NAME]</HierarchyUniqueName><LevelName>APPLICATION NAME</LevelName><UniqueName>[APPLICATIONS].[APPLICATION NAME].[APPLICATION NAME]</UniqueName></ID><ItemCaption>APPLICATION NAME</ItemCaption></Item><Item><ID xsi:type="Measure"><MeasureName>APPLICATION INSTANCES VIEW Count</MeasureName><UniqueName>[Measures].[APPLICATION INSTANCES VIEW Count]</UniqueName></ID><ItemCaption>APPLICATION INSTANCES VIEW Count</ItemCaption><FormattedValue>true</FormattedValue></Item></Items></Select><From>ApplicationUsage</From><Filter><FilterItems /></Filter><Calculations /><Aggregates /><QueryProperties /></QuerySpecification><Query><Statement>WITH
MEMBER [DATE].[StartDate].[DateRange] AS
AGGREGATE
( STRTOMEMBER(@.startDate) : STRTOMEMBER(@.endDate), [Measures].CURRENTMEMBER
)
MEMBER [USERS].[WINDOWS LOGON NAME].[UserName] AS
AGGREGATE
( {STRTOSET(@.users)} )
SELECT
NON EMPTY { [Measures].[APPLICATION INSTANCES VIEW Count] } ON COLUMNS,
NON EMPTY TopCount ( Filter ( {[APPLICATIONS].[APPLICATION NAME].[APPLICATION NAME]}, [Measures].[APPLICATION INSTANCES VIEW Count] >= 0 ) , 10, [Measures].[APPLICATION INSTANCES VIEW Count] ) ON ROWS
FROM
(select STRTOSET(@.appName) on 0 from [ApplicationUsage] )
WHERE
(([USERS].[WINDOWS LOGON NAME].[UserName]),[DATE].[StartDate].[DateRange])</Statement><ParameterDefinitions><ParameterDefinition><Name>startDate</Name><DefaultValues><DefaultValue>[DATE].[Startdate].[All]</DefaultValue></DefaultValues><Caption>startDate</Caption><HierarchyUniqueName>[DATE].[Startdate]</HierarchyUniqueName><ParameterValuesQuery><Statement>WITH MEMBER [Measures].[ParameterCaption] AS '[DATE].[Startdate].CURRENTMEMBER.MEMBER_CAPTION' MEMBER [Measures].[ParameterValue] AS '[DATE].[Startdate].CURRENTMEMBER.UNIQUENAME' MEMBER [Measures].[ParameterLevel] AS '[DATE].[Startdate].CURRENTMEMBER.LEVEL.ORDINAL' SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [DATE].[Startdate].ALLMEMBERS ON ROWS FROM [ApplicationUsage]</Statement><ParameterizedStatement><ReferencedParameters /></ParameterizedStatement></ParameterValuesQuery></ParameterDefinition><ParameterDefinition><Name>endDate</Name><DefaultValues><DefaultValue>[DATE].[Startdate].[All]</DefaultValue></DefaultValues><Caption>endDate</Caption><HierarchyUniqueName>[DATE].[Startdate]</HierarchyUniqueName><ParameterValuesQuery><Statement>WITH MEMBER [Measures].[ParameterCaption] AS '[DATE].[Startdate].CURRENTMEMBER.MEMBER_CAPTION' MEMBER [Measures].[ParameterValue] AS '[DATE].[Startdate].CURRENTMEMBER.UNIQUENAME' MEMBER [Measures].[ParameterLevel] AS '[DATE].[Startdate].CURRENTMEMBER.LEVEL.ORDINAL' SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [DATE].[Startdate].ALLMEMBERS ON ROWS FROM [ApplicationUsage]</Statement><ParameterizedStatement><ReferencedParameters /></ParameterizedStatement></ParameterValuesQuery></ParameterDefinition><ParameterDefinition><Name>users</Name><DefaultValues><DefaultValue>[USERS].[WINDOWS LOGON NAME].[All]</DefaultValue></DefaultValues><Caption>users</Caption><HierarchyUniqueName>[USERS].[WINDOWS LOGON NAME]</HierarchyUniqueName><ParameterValuesQuery><Statement>WITH MEMBER [Measures].[ParameterCaption] AS '[USERS].[WINDOWS LOGON NAME].CURRENTMEMBER.MEMBER_CAPTION' MEMBER [Measures].[ParameterValue] AS '[USERS].[WINDOWS LOGON NAME].CURRENTMEMBER.UNIQUENAME' MEMBER [Measures].[ParameterLevel] AS '[USERS].[WINDOWS LOGON NAME].CURRENTMEMBER.LEVEL.ORDINAL' SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [USERS].[WINDOWS LOGON NAME].ALLMEMBERS ON ROWS FROM [ApplicationUsage]</Statement><ParameterizedStatement><ReferencedParameters /></ParameterizedStatement></ParameterValuesQuery></ParameterDefinition><ParameterDefinition><Name>appName</Name><DefaultValues><DefaultValue>[APPLICATIONS].[APPLICATION NAME].[All]</DefaultValue></DefaultValues><Caption>appName</Caption><HierarchyUniqueName>[APPLICATIONS].[APPLICATION NAME]</HierarchyUniqueName><ParameterValuesQuery><Statement>WITH MEMBER [Measures].[ParameterCaption] AS '[APPLICATIONS].[APPLICATION NAME].CURRENTMEMBER.MEMBER_CAPTION' MEMBER [Measures].[ParameterValue] AS '[APPLICATIONS].[APPLICATION NAME].CURRENTMEMBER.UNIQUENAME' MEMBER [Measures].[ParameterLevel] AS '[APPLICATIONS].[APPLICATION NAME].CURRENTMEMBER.LEVEL.ORDINAL' SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [APPLICATIONS].[APPLICATION NAME].ALLMEMBERS ON ROWS FROM [ApplicationUsage]</Statement><ParameterizedStatement><ReferencedParameters /></ParameterizedStatement></ParameterValuesQuery></ParameterDefinition><ParameterDefinition><Name>chartTitle</Name><DefaultValues><DefaultValue>Ten Most Used Applications</DefaultValue></DefaultValues><Caption>chartTitle</Caption><ParameterValuesQuery><ParameterizedStatement><ReferencedParameters /></ParameterizedStatement></ParameterValuesQuery></ParameterDefinition></ParameterDefinitions></Query></QueryDefinition></rd:MdxQuery>
</Query>
<Fields>
<Field Name="APPLICATION_NAME">
<rd:TypeName>System.String</rd:TypeName>
<DataField><?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Level" UniqueName="[APPLICATIONS].[APPLICATION NAME].[APPLICATION NAME]" /></DataField>
</Field>
<Field Name="APPLICATION_INSTANCES_VIEW_Count">
<rd:TypeName>System.Int32</rd:TypeName>
<DataField><?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[APPLICATION INSTANCES VIEW Count]" /></DataField>
</Field>
</Fields>
</DataSet>
</DataSets>
<Width>4.75in</Width>
<InteractiveHeight>11in</InteractiveHeight>
<Language>en-US</Language>
<TopMargin>1in</TopMargin>
</Report>

|||No luck yet?|||

It appears to be an error in Books Online: CSV renderer does not render chart data, while XML renderer does. Sorry about confusion.

One way you can export chart data is by applying XSL transformation to the XML data output of the report:

http://msdn2.microsoft.com/en-us/library/aa178953(SQL.80).aspx

Reports cannot be exported to csv format

Hi,

Any help would be appreciated.

Thanks in advance!

No replies yet:(

The only solution we can think about is to develop those many reports in tabular format. (only for CSV format)

Any other solution available?

Thanks!

|||

CSV output should include Chart Data. http://msdn2.microsoft.com/en-us/library/aa178937(SQL.80).aspx

If you are not getting data, make sure to set DataElementOutput to true. Here is a link to how it works for XML.

http://msdn2.microsoft.com/en-us/library/aa179497(SQL.80).aspx

|||

Even I read the first MSDN link where it mentions charts can be rendered to CSV. Thats why I am a bit sure that there may be some setting in the properties, which will show the data values in CSV.

I also tried the setting mentioned in the CSV Device Information Settings and mentioned Encoding value for CSV as ASCII. Restarted SQL Server.

I also set the DataElementOutput property to "Output" but still I am not able to see the expected result.

Please do let me know if there is any solution available.

Thanks!

|||

Chart Data is supposed to be exported to CSV.

Can you attach the report definition so I can take a look and diagnose the problem?

Thanks!

|||

Hi Denis,

Following is the report definition. Hope to find some solution to my problem.

Thanks in advance!

|||No luck yet?|||

It appears to be an error in Books Online: CSV renderer does not render chart data, while XML renderer does. Sorry about confusion.

One way you can export chart data is by applying XSL transformation to the XML data output of the report:

http://msdn2.microsoft.com/en-us/library/aa178953(SQL.80).aspx

Monday, February 20, 2012

Reporting Services: timeout issue

Hi there,

I've just developed this big report in RS SQL 2000 that includes 6 subreports (repeated for each item in the database) and that should print some 800 pages. A light version of the report that only queries part of the data (about 10%, for testing purposes) run with success, including all subreports in about 15 minutes. Once I try to test the report with all the data (all subreports and the main report query directly from the cube in AS), it fails under three different scenarios:

1st: The timeout setting is left as the default 1800 seconds. After half an hour the report gets partially displayed and the subreports that were not processed within the 30 minutes period display only "The subreport data could not be displayed".

2nd: The timeout value is set not to time out. After about 2 hours, the report fails ("The page cannot be displayed"). I checked all log files and the only one I could identify as related to this was the following:

SQL Server Scheduled Job 'ReportScheduler_CreateJobs' (0x4A64EE6822172C478B4DBF1E385699D6) - Status: Failed - Invoked on: 2006-01-09 13:00:00 - Message: The job failed. The Job was invoked by Schedule 1 (DailyRun). The last step to run was step 1 (spc_sched_CreateJobs).

3rd: Tried to export the file to PDF instead of rendering as HTML. I got the message on the page "Action Cancelled" and an IE message box displaying a "Permission Denied" error.

I've tried many things and ran out of ideas. If anyone could give me any suggestions, I'd greatly appreciate it.

Thanks,

érico Maia

Are you generating these reports from a web-service?|||The reason I ask that question is that there is a very obscure 'Flag' that is set by default to ignore any new Timeout value set for the web service timeout. It is located on the generated class interface. I don't remember the exact name of this flag, but maybe this will help you in looking to solve this problem. If I can remember its name I will post on this board. Obviously, there is an issue with this solution, which is, any time you re-generate the web interface class you will have to reset this.|||

Hi,

The report is executed directly from the RS web interface. I'm trying now to generate it via a subscription, but also without success. After increasing the time out settings of all config files I know of, the report fails exactly at the 120 minutes mark.

Thanks,

érico

|||

Hi érico

Did you manage to find a solution to your problem? I am experiencing exactly the same behaviour.

-- TINUS

|||I am having similar issues that I am trying to resolve as well, running 2KSP4 1042. It's a new issue for us, as all of our reports worked fine until I started composing some large combination reports which take a significant amount of runtime (an hour or better). Due to the complexities of one of the reports involved, batching it is difficult (though not impossible), but some of the reading I've done lends me to believe that it may not even fix the problem.

The report attempts to execute, and the control indicates that it's processing, but eventually results in the "Page cannot be displayed" error, while the RS navigation tools still function normally. Furthermore, I can navigate to other reports and operate them, but if I navigate back to the report in question, the control immediately goes to the "Page cannot be displayed" message. I have to close and reopen IE for the control to attempt to start the report again.

I've seen this in one or two other rare circumstances before, and after reloading the browser, the report would render, but this is the first time I've consistently gotten this error message, and I have to think it's because of the lengthy runtime of the reports in question. One has 34 subreports in it (each of which has a runtime of 2-3 minutes), and the other is just a very in-depth query which (depending on parameters selected) could be run once or upwards of 60 times (with totaling at the end). I've disabled the RS timeout for the affected reports and it doesn't seem to help at all (I believe previously I was just getting rsProcessingAborted).

Reporting Services: timeout issue

Hi there,

3rd: Tried to export the file to PDF instead of rendering as HTML. I got the message on the page "Action Cancelled" and an IE message box displaying a "Permission Denied" error.

I've tried many things and ran out of ideas. If anyone could give me any suggestions, I'd greatly appreciate it.

Thanks,

érico Maia

Hi,

Thanks,

érico

|||

Hi érico

Did you manage to find a solution to your problem? I am experiencing exactly the same behaviour.

-- TINUS

Reporting Services: timeout issue

Hi there,

3rd: Tried to export the file to PDF instead of rendering as HTML. I got the message on the page "Action Cancelled" and an IE message box displaying a "Permission Denied" error.

I've tried many things and ran out of ideas. If anyone could give me any suggestions, I'd greatly appreciate it.

Thanks,

érico Maia

Hi,

Thanks,

érico

|||

Hi érico

Did you manage to find a solution to your problem? I am experiencing exactly the same behaviour.

-- TINUS

Reporting Services X64 major problem

Hi,

We have a product that is developed in ASP and works with SQL Server 2000 or 2005. Since it’s an ERP, we also use Reporting Services 2000 or 2005. Our application needs 3 registered DLLs that were, a long time ago, developed to support our entire application.

Since we are using Windows Server 2003 x64 editions in our clients with SQL Server 2005 x64 edition, we managed to register the 32 bit DLLs in the 64 bit system. We installed them as a COM+ component, ran the command “cscript.exe adsutil.vbs set W3SVC/AppPools/Enable32BitAppOnWin64 true” and our application worked fine.

This command caused the IIS to use the .NET 2.0 32 bit version so that our DLLs could be correctly invoked.

But now Reporting Services doesn’t work because it needs the 64 bit version of the .Net framework. When I try to connhecto to localhost/reports, I get the error "%1 is not a valid Win32 application".

Is there any workaround to this problem so that i can deploy the application and the database in the same machine?

This means that there is no way to install SQL Server 2005 x64 and Reporting Services X86 in the same machine...?

Reporting Services X64 major problem

Hi,

This command caused the IIS to use the .NET 2.0 32 bit version so that our DLLs could be correctly invoked.

Is there any workaround to this problem so that i can deploy the application and the database in the same machine?

This means that there is no way to install SQL Server 2005 x64 and Reporting Services X86 in the same machine...?

Wednesday, March 28, 2012

ReportViewer control doesn't accept Parameters

ReportViewer and Firefox

Monday, March 26, 2012

ReportViewer 2.0 Control with Credentials Problem

Tuesday, March 20, 2012

reports problem

Monday, March 12, 2012

Reports deployed to Standard edition RS and SQL Server

Reports cannot be exported to csv format

Reports cannot be exported to csv format

Monday, February 20, 2012

Reporting Services: timeout issue

Reporting Services: timeout issue

Reporting Services: timeout issue

Reporting Services X64 major problem

Reporting Services X64 major problem

Deserialization Failed

Blog Archive

About Me