I want to display the data points as a scatter chart with a line for
'expected'. I can mix bar and line but not scatter and line. Also tried to
over-lay two chart (which of course fails when viewed in html.As you have already found out - the approach of overlapping charts does only
work for image-based renderers (e.g. Preview, PDF, TIFF), but not for HTML.
It is possible to achieve what you want with a "scatter line" chart natively
in RS 2000 SP1. However, this is not trivial and the shown approach has the
limitation that you cannot use the default chart legend (you may want to
check my custom legend sample available either in the archives of this
newsgroups or on Brian Welcker's blog:
http://blogs.msdn.com/bwelcker/archive/2005/05/20/420349.aspx).
In addition, you would need to prepare the data in a special way (e.g. with
a stored procedure) so that it contains both, the individual datapoints as
well as the line data. Attached is a sample RDL - it will require some
careful study! It is just a proof of concept that it is possible to do this
in RS 2000 SP1.
The RDL sample is copy&pasted to the bottom of this posting.
--
Robert M. Bruckner
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"GH" <GH@.discussions.microsoft.com> wrote in message
news:6E0AA4E3-B6E6-4CBC-91DC-4A1C6028CE70@.microsoft.com...
>I want to display the data points as a scatter chart with a line for
> 'expected'. I can mix bar and line but not scatter and line. Also tried
> to
> over-lay two chart (which of course fails when viewed in html.
=============================================================
<?xml version="1.0" encoding="utf-8"?>
<Report
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition"
xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<RightMargin>1in</RightMargin>
<Body>
<ReportItems>
<Chart Name="chart1">
<ThreeDProperties>
<Rotation>30</Rotation>
<Inclination>30</Inclination>
<Shading>Simple</Shading>
<WallThickness>50</WallThickness>
</ThreeDProperties>
<Style>
<BackgroundColor>White</BackgroundColor>
</Style>
<Legend>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Position>RightCenter</Position>
</Legend>
<Palette>Default</Palette>
<ChartData>
<ChartSeries>
<DataPoints>
<DataPoint>
<DataValues>
<DataValue>
<Value>=Sum(Fields!X.Value)</Value>
</DataValue>
<DataValue>
<Value>=Sum(Fields!Y.Value)</Value>
</DataValue>
</DataValues>
<DataLabel />
<Style>
<BorderWidth>
<Default>3pt</Default>
</BorderWidth>
<BorderColor>
<Default>=iif(Fields!SeriesId.Value >= 100,
iif(Fields!SeriesId.Value >= 200, "DodgerBlue", "GreenYellow"),
Nothing)</Default>
</BorderColor>
<BorderStyle>
<Default>Dotted</Default>
</BorderStyle>
</Style>
<Marker>
<Type>Square</Type>
<Size>6pt</Size>
</Marker>
</DataPoint>
</DataPoints>
</ChartSeries>
</ChartData>
<CategoryAxis>
<Axis>
<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>
<Scalar>true</Scalar>
</Axis>
</CategoryAxis>
<DataSetName>DataSet1</DataSetName>
<PointWidth>0</PointWidth>
<Type>Scatter</Type>
<Top>0.125in</Top>
<Title />
<Width>4.75in</Width>
<CategoryGroupings>
<CategoryGrouping>
<DynamicCategories>
<Grouping Name="chart1_CategoryGroup1">
<GroupExpressions>
<GroupExpression>=Fields!Id.Value</GroupExpression>
</GroupExpressions>
</Grouping>
<Label>=Fields!Id.Value</Label>
</DynamicCategories>
</CategoryGrouping>
</CategoryGroupings>
<Height>3.875in</Height>
<SeriesGroupings>
<SeriesGrouping>
<DynamicSeries>
<Grouping Name="chart1_SeriesGroup1">
<GroupExpressions>
<GroupExpression>=Fields!SeriesId.Value</GroupExpression>
</GroupExpressions>
</Grouping>
<Label>=Fields!SeriesId.Value</Label>
</DynamicSeries>
</SeriesGrouping>
</SeriesGroupings>
<Subtype>SmoothLine</Subtype>
<PlotArea>
<Style>
<BackgroundColor>LightGrey</BackgroundColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</PlotArea>
<Left>0.625in</Left>
<ValueAxis>
<Axis>
<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>
</Chart>
</ReportItems>
<Style />
<Height>4.375in</Height>
</Body>
<TopMargin>1in</TopMargin>
<DataSources>
<DataSource Name="Northwind">
<rd:DataSourceID>43c9f73e-1490-476c-8572-d6b0d099d9a8</rd:DataSourceID>
<ConnectionProperties>
<DataProvider>SQL</DataProvider>
<ConnectString>data source=(local);initial
catalog=Northwind</ConnectString>
<IntegratedSecurity>true</IntegratedSecurity>
</ConnectionProperties>
</DataSource>
</DataSources>
<Width>6.5in</Width>
<DataSets>
<DataSet Name="DataSet1">
<Fields>
<Field Name="Id">
<DataField>Id</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="SeriesId">
<DataField>SeriesId</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="X">
<DataField>X</DataField>
<rd:TypeName>System.Decimal</rd:TypeName>
</Field>
<Field Name="Y">
<DataField>Y</DataField>
<rd:TypeName>System.Decimal</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>Northwind</DataSourceName>
<CommandText>select 10 as Id, 0 as SeriesId, 1 as X, 1 as Y union
all
select 11 as Id, 0 as SeriesId, 1.6 as X, 1.4 as Y union all
select 12 as Id, 0 as SeriesId, 2.7 as X, 3 as Y union all
select 13 as Id, 0 as SeriesId, 4 as X, 4 as Y union all
select 20 as Id, 1 as SeriesId, 1.5 as X, 2 as Y union all
select 21 as Id, 1 as SeriesId, 4 as X, 3 as Y union all
select 100 as Id, 100 as SeriesId, 1.2 as X, 1.0 as Y union all
select 101 as Id, 101 as SeriesId, 1.7 as X, 1.5 as Y union all
select 102 as Id, 102 as SeriesId, 1.9 as X, 2.2 as Y union all
select 103 as Id, 103 as SeriesId, 2.3 as X, 2.7 as Y union all
select 104 as Id, 104 as SeriesId, 3.0 as X, 3.1 as Y union all
select 105 as Id, 105 as SeriesId, 3.7 as X, 3.8 as Y union all
select 200 as Id, 200 as SeriesId, 1.6 as X, 2.2 as Y union all
select 201 as Id, 201 as SeriesId, 1.9 as X, 2.3 as Y union all
select 202 as Id, 202 as SeriesId, 2.3 as X, 2.4 as Y union all
select 203 as Id, 203 as SeriesId, 2.9 as X, 2.5 as Y union all
select 204 as Id, 204 as SeriesId, 3.3 as X, 2.9 as Y union all
select 205 as Id, 205 as SeriesId, 3.8 as X, 3.0 as Y</CommandText>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
</DataSet>
</DataSets>
<LeftMargin>1in</LeftMargin>
<rd:SnapToGrid>true</rd:SnapToGrid>
<rd:DrawGrid>true</rd:DrawGrid>
<rd:ReportID>70f720a6-1b18-43f1-a9d5-2d24de087995</rd:ReportID>
<BottomMargin>1in</BottomMargin>
<Language>en-US</Language>
</Report>|||Did you mean you can mix Bar and line in a chart? If yes, how did you do it?
Thanks in advance.
"GH" wrote:
> I want to display the data points as a scatter chart with a line for
> 'expected'. I can mix bar and line but not scatter and line. Also tried to
> over-lay two chart (which of course fails when viewed in html.|||You can display individual items up to render as lines.
Set the chart up to be a bar chart. Add 2 values. Go to properties for the
2nd value and [I think] go to the 2nd tab. There should be a check box for
"Display or Render as Line".
"jxu" <jxu@.discussions.microsoft.com> wrote in message
news:AE549848-174D-41D0-B20F-90CBFD34BF55@.microsoft.com...
> Did you mean you can mix Bar and line in a chart? If yes, how did you do
> it?
> Thanks in advance.
> "GH" wrote:
>> I want to display the data points as a scatter chart with a line for
>> 'expected'. I can mix bar and line but not scatter and line. Also tried
>> to
>> over-lay two chart (which of course fails when viewed in html.|||I posted a question regarding this scenario and how it effects the legend. I
created the chart you described below but now the legend also got updated
with a second series and I do not want this. The line I plotted does not
require legend entries. How do I get rid of these?
"Tim Dot NoSpam" wrote:
> You can display individual items up to render as lines.
> Set the chart up to be a bar chart. Add 2 values. Go to properties for the
> 2nd value and [I think] go to the 2nd tab. There should be a check box for
> "Display or Render as Line".
> "jxu" <jxu@.discussions.microsoft.com> wrote in message
> news:AE549848-174D-41D0-B20F-90CBFD34BF55@.microsoft.com...
> > Did you mean you can mix Bar and line in a chart? If yes, how did you do
> > it?
> > Thanks in advance.
> >
> > "GH" wrote:
> >
> >> I want to display the data points as a scatter chart with a line for
> >> 'expected'. I can mix bar and line but not scatter and line. Also tried
> >> to
> >> over-lay two chart (which of course fails when viewed in html.
>
>
Showing posts with label reporting. Show all posts
Showing posts with label reporting. Show all posts
Monday, March 19, 2012
Friday, March 9, 2012
Missing ReportViewer WebControl
Hello:
I'm trying to integrate reports with my .NET 1.1 application (using VS2003).
I've installed SQL Server Reporting Services 05 Standard Edition, yet I do
not see the ReportViewer control in the normal installation folder - in
fact, the only folder installed under Samples is Databases, containing the
sample tutorial databases.
Trying to patch the installation didnt obviously reveal where the file would
be installed from.
Any thoughts?
ThanksI just found this:
http://www.microsoft.com/downloads/details.aspx?familyid=8a166cac-758d-45c8-b637-dd7726e61367&displaylang=en
Which I *assume* contains my controls, but its not compatible with .NET 1.1.
So I'll rephrase my question :)
I have a .NET app with some forms that I'd like to provide direct links to
their Reporting Services counterparts in PDF format. I need to pass values
to the stored procedure parameters for each respective report, however. This
is the part I am unsure of.
I do not want the user to be prompted for values, because several of the
procedures contain values that the user will not know. Instead I was hoping
to pass these either within the report querystring, but I am not sure how to
do this. I thought the ReportViewer control would do the trick but it
appears it wont. I cannot convert the app to 2.0 because a significant
amount of time has already been invested in code and fixing compatibility
issues is not within our timeline.
Can anyone please provide me with a direction? Thank you.
"Elliot Rodriguez" <elliotrodriguezatgeemaildotcom> wrote in message
news:eZ5szc$YGHA.3936@.TK2MSFTNGP05.phx.gbl...
> Hello:
> I'm trying to integrate reports with my .NET 1.1 application (using
> VS2003).
> I've installed SQL Server Reporting Services 05 Standard Edition, yet I do
> not see the ReportViewer control in the normal installation folder - in
> fact, the only folder installed under Samples is Databases, containing the
> sample tutorial databases.
> Trying to patch the installation didnt obviously reveal where the file
> would be installed from.
> Any thoughts?
> Thanks
>|||You have two options. One is to use webservices. You get a stream back with
the format in PDF. You pass it all the parameters. The other option is to
use URL integration. You could embed the IE web control and give it the
appropriate URL. The URL string can specify rendering format as well as the
parameters.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Elliot Rodriguez" <elliotrodriguezatgeemaildotcom> wrote in message
news:u2Nu8h$YGHA.3328@.TK2MSFTNGP02.phx.gbl...
>I just found this:
> http://www.microsoft.com/downloads/details.aspx?familyid=8a166cac-758d-45c8-b637-dd7726e61367&displaylang=en
> Which I *assume* contains my controls, but its not compatible with .NET
> 1.1.
> So I'll rephrase my question :)
> I have a .NET app with some forms that I'd like to provide direct links to
> their Reporting Services counterparts in PDF format. I need to pass values
> to the stored procedure parameters for each respective report, however.
> This is the part I am unsure of.
> I do not want the user to be prompted for values, because several of the
> procedures contain values that the user will not know. Instead I was
> hoping to pass these either within the report querystring, but I am not
> sure how to do this. I thought the ReportViewer control would do the trick
> but it appears it wont. I cannot convert the app to 2.0 because a
> significant amount of time has already been invested in code and fixing
> compatibility issues is not within our timeline.
> Can anyone please provide me with a direction? Thank you.
> "Elliot Rodriguez" <elliotrodriguezatgeemaildotcom> wrote in message
> news:eZ5szc$YGHA.3936@.TK2MSFTNGP05.phx.gbl...
>> Hello:
>> I'm trying to integrate reports with my .NET 1.1 application (using
>> VS2003).
>> I've installed SQL Server Reporting Services 05 Standard Edition, yet I
>> do not see the ReportViewer control in the normal installation folder -
>> in fact, the only folder installed under Samples is Databases, containing
>> the sample tutorial databases.
>> Trying to patch the installation didnt obviously reveal where the file
>> would be installed from.
>> Any thoughts?
>> Thanks
>>
>|||Thanks Bruce. Do you have any resources you can recommend for using the
Webservice option? I've found a lot on basic stuff but thats about it.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:ubDgtn$YGHA.4760@.TK2MSFTNGP03.phx.gbl...
> You have two options. One is to use webservices. You get a stream back
> with the format in PDF. You pass it all the parameters. The other option
> is to use URL integration. You could embed the IE web control and give it
> the appropriate URL. The URL string can specify rendering format as well
> as the parameters.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Elliot Rodriguez" <elliotrodriguezatgeemaildotcom> wrote in message
> news:u2Nu8h$YGHA.3328@.TK2MSFTNGP02.phx.gbl...
>>I just found this:
>> http://www.microsoft.com/downloads/details.aspx?familyid=8a166cac-758d-45c8-b637-dd7726e61367&displaylang=en
>> Which I *assume* contains my controls, but its not compatible with .NET
>> 1.1.
>> So I'll rephrase my question :)
>> I have a .NET app with some forms that I'd like to provide direct links
>> to their Reporting Services counterparts in PDF format. I need to pass
>> values to the stored procedure parameters for each respective report,
>> however. This is the part I am unsure of.
>> I do not want the user to be prompted for values, because several of the
>> procedures contain values that the user will not know. Instead I was
>> hoping to pass these either within the report querystring, but I am not
>> sure how to do this. I thought the ReportViewer control would do the
>> trick but it appears it wont. I cannot convert the app to 2.0 because a
>> significant amount of time has already been invested in code and fixing
>> compatibility issues is not within our timeline.
>> Can anyone please provide me with a direction? Thank you.
>> "Elliot Rodriguez" <elliotrodriguezatgeemaildotcom> wrote in message
>> news:eZ5szc$YGHA.3936@.TK2MSFTNGP05.phx.gbl...
>> Hello:
>> I'm trying to integrate reports with my .NET 1.1 application (using
>> VS2003).
>> I've installed SQL Server Reporting Services 05 Standard Edition, yet I
>> do not see the ReportViewer control in the normal installation folder -
>> in fact, the only folder installed under Samples is Databases,
>> containing the sample tutorial databases.
>> Trying to patch the installation didnt obviously reveal where the file
>> would be installed from.
>> Any thoughts?
>> Thanks
>>
>>
>
I'm trying to integrate reports with my .NET 1.1 application (using VS2003).
I've installed SQL Server Reporting Services 05 Standard Edition, yet I do
not see the ReportViewer control in the normal installation folder - in
fact, the only folder installed under Samples is Databases, containing the
sample tutorial databases.
Trying to patch the installation didnt obviously reveal where the file would
be installed from.
Any thoughts?
ThanksI just found this:
http://www.microsoft.com/downloads/details.aspx?familyid=8a166cac-758d-45c8-b637-dd7726e61367&displaylang=en
Which I *assume* contains my controls, but its not compatible with .NET 1.1.
So I'll rephrase my question :)
I have a .NET app with some forms that I'd like to provide direct links to
their Reporting Services counterparts in PDF format. I need to pass values
to the stored procedure parameters for each respective report, however. This
is the part I am unsure of.
I do not want the user to be prompted for values, because several of the
procedures contain values that the user will not know. Instead I was hoping
to pass these either within the report querystring, but I am not sure how to
do this. I thought the ReportViewer control would do the trick but it
appears it wont. I cannot convert the app to 2.0 because a significant
amount of time has already been invested in code and fixing compatibility
issues is not within our timeline.
Can anyone please provide me with a direction? Thank you.
"Elliot Rodriguez" <elliotrodriguezatgeemaildotcom> wrote in message
news:eZ5szc$YGHA.3936@.TK2MSFTNGP05.phx.gbl...
> Hello:
> I'm trying to integrate reports with my .NET 1.1 application (using
> VS2003).
> I've installed SQL Server Reporting Services 05 Standard Edition, yet I do
> not see the ReportViewer control in the normal installation folder - in
> fact, the only folder installed under Samples is Databases, containing the
> sample tutorial databases.
> Trying to patch the installation didnt obviously reveal where the file
> would be installed from.
> Any thoughts?
> Thanks
>|||You have two options. One is to use webservices. You get a stream back with
the format in PDF. You pass it all the parameters. The other option is to
use URL integration. You could embed the IE web control and give it the
appropriate URL. The URL string can specify rendering format as well as the
parameters.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Elliot Rodriguez" <elliotrodriguezatgeemaildotcom> wrote in message
news:u2Nu8h$YGHA.3328@.TK2MSFTNGP02.phx.gbl...
>I just found this:
> http://www.microsoft.com/downloads/details.aspx?familyid=8a166cac-758d-45c8-b637-dd7726e61367&displaylang=en
> Which I *assume* contains my controls, but its not compatible with .NET
> 1.1.
> So I'll rephrase my question :)
> I have a .NET app with some forms that I'd like to provide direct links to
> their Reporting Services counterparts in PDF format. I need to pass values
> to the stored procedure parameters for each respective report, however.
> This is the part I am unsure of.
> I do not want the user to be prompted for values, because several of the
> procedures contain values that the user will not know. Instead I was
> hoping to pass these either within the report querystring, but I am not
> sure how to do this. I thought the ReportViewer control would do the trick
> but it appears it wont. I cannot convert the app to 2.0 because a
> significant amount of time has already been invested in code and fixing
> compatibility issues is not within our timeline.
> Can anyone please provide me with a direction? Thank you.
> "Elliot Rodriguez" <elliotrodriguezatgeemaildotcom> wrote in message
> news:eZ5szc$YGHA.3936@.TK2MSFTNGP05.phx.gbl...
>> Hello:
>> I'm trying to integrate reports with my .NET 1.1 application (using
>> VS2003).
>> I've installed SQL Server Reporting Services 05 Standard Edition, yet I
>> do not see the ReportViewer control in the normal installation folder -
>> in fact, the only folder installed under Samples is Databases, containing
>> the sample tutorial databases.
>> Trying to patch the installation didnt obviously reveal where the file
>> would be installed from.
>> Any thoughts?
>> Thanks
>>
>|||Thanks Bruce. Do you have any resources you can recommend for using the
Webservice option? I've found a lot on basic stuff but thats about it.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:ubDgtn$YGHA.4760@.TK2MSFTNGP03.phx.gbl...
> You have two options. One is to use webservices. You get a stream back
> with the format in PDF. You pass it all the parameters. The other option
> is to use URL integration. You could embed the IE web control and give it
> the appropriate URL. The URL string can specify rendering format as well
> as the parameters.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Elliot Rodriguez" <elliotrodriguezatgeemaildotcom> wrote in message
> news:u2Nu8h$YGHA.3328@.TK2MSFTNGP02.phx.gbl...
>>I just found this:
>> http://www.microsoft.com/downloads/details.aspx?familyid=8a166cac-758d-45c8-b637-dd7726e61367&displaylang=en
>> Which I *assume* contains my controls, but its not compatible with .NET
>> 1.1.
>> So I'll rephrase my question :)
>> I have a .NET app with some forms that I'd like to provide direct links
>> to their Reporting Services counterparts in PDF format. I need to pass
>> values to the stored procedure parameters for each respective report,
>> however. This is the part I am unsure of.
>> I do not want the user to be prompted for values, because several of the
>> procedures contain values that the user will not know. Instead I was
>> hoping to pass these either within the report querystring, but I am not
>> sure how to do this. I thought the ReportViewer control would do the
>> trick but it appears it wont. I cannot convert the app to 2.0 because a
>> significant amount of time has already been invested in code and fixing
>> compatibility issues is not within our timeline.
>> Can anyone please provide me with a direction? Thank you.
>> "Elliot Rodriguez" <elliotrodriguezatgeemaildotcom> wrote in message
>> news:eZ5szc$YGHA.3936@.TK2MSFTNGP05.phx.gbl...
>> Hello:
>> I'm trying to integrate reports with my .NET 1.1 application (using
>> VS2003).
>> I've installed SQL Server Reporting Services 05 Standard Edition, yet I
>> do not see the ReportViewer control in the normal installation folder -
>> in fact, the only folder installed under Samples is Databases,
>> containing the sample tutorial databases.
>> Trying to patch the installation didnt obviously reveal where the file
>> would be installed from.
>> Any thoughts?
>> Thanks
>>
>>
>
Missing Report Graphs
I am testing a new install of Reporting Services with Mom 2005. Every report
that I try to view that contains a graph simply displays an empty box with a
red X in the upper left. Is there some component that I am possibly missing
that contains the graph object?
Any help is appreciated!
--
Dale Foshe, mcseSee if cookies are allowed in the browser by looking at the status bar when
the report is requested.
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"Dale Foshe, mcse" <DaleFoshemcse@.discussions.microsoft.com> wrote in
message news:AE3335EA-A974-4D0E-A3AC-49FAAE34B759@.microsoft.com...
> I am testing a new install of Reporting Services with Mom 2005. Every
report
> that I try to view that contains a graph simply displays an empty box with
a
> red X in the upper left. Is there some component that I am possibly
missing
> that contains the graph object?
> Any help is appreciated!
> --
> Dale Foshe, mcse
that I try to view that contains a graph simply displays an empty box with a
red X in the upper left. Is there some component that I am possibly missing
that contains the graph object?
Any help is appreciated!
--
Dale Foshe, mcseSee if cookies are allowed in the browser by looking at the status bar when
the report is requested.
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"Dale Foshe, mcse" <DaleFoshemcse@.discussions.microsoft.com> wrote in
message news:AE3335EA-A974-4D0E-A3AC-49FAAE34B759@.microsoft.com...
> I am testing a new install of Reporting Services with Mom 2005. Every
report
> that I try to view that contains a graph simply displays an empty box with
a
> red X in the upper left. Is there some component that I am possibly
missing
> that contains the graph object?
> Any help is appreciated!
> --
> Dale Foshe, mcse
Wednesday, March 7, 2012
Missing projects/templates options?
I have a limited selection of projects.
I want to be able to create business intelligence project for reporting but the business intelligence project option is not there when I go to file/new/project.
When I first installed visual studio I chose visual basic/web development as the preference would this prevent other project types from being displayed?
After update from VSSP1 Vista Beta to VSSP1 (or was it update SQL 2005 SP2) I am missing in Visual Studio all Templates, except the Starter Kids and the Template for AJAX.
How can I reactivate the Templates again?
Thanks for help
Missing parameter, no chart displayed
I've got this problem: (with Reporting Services 2005)
The pop up appears but I would like this message to show in the report layout but BEFORE ckliking on "view report"...just a simple generical message saying to the user something like "please choose a value for the X parameter and THEN click on view report"
The message is a sort of "guide".
I thought I can do this by placing a textbox but it seems that the textbox is linked to the chart (no chart no textbox)...i know it seems a stupid problem but unfortunatly I was asked to do this work this way.|||
Unfortunatly I don't seem to be able to set "allow null value" for the parameter I'm interested in, cause the application says that the properties for that object are invalid.
That object is a multi-value string available values from query.
So your suggestion does not work. :(
I've got a report with a chart with some values that are needed to get the chart displayed.
If one of this parameters is missing (not selected) the program doesn't display the report (it shows a blank page)
Is it possible in this case to get instead a textbox with a message requiring to select the missing parameter (if I insert a textbox below the chart in the layout, this textbox isn't displayed if one parameter is missing)
ps sorry for my poor english
thanks in advance for your helpI believe what you want can be accomplished by making sure each parameter is set to NOT allow blank value. Just go to "Report" -> "Report Parameters" and make sure the "Allow blank value" checkbox is unchecked for each parameter. Then, the report will not be generated and a popup box will be displayed if the user doesn't enter a value.|||
Thank you for your answer.
But the problem is that I would like to display a warning to the user to suggest him to select the missing parameter (in my case choosing from a scrolling menu).
The parameter is multivalue so i would like to avoid to displaying a default value, but I would like the user to choose.
The application does not seem to allow this.
In fact if I add a textbox, it's not displayed unless also the chart is displayed.
So if the parameter is missing, no chart will be displayed and so the textbox too.
No object is being shown unless all the parameters are selected and only in this case the chart can be displayed... but as I said I would like to display this warning when a parameter is not selected.
How can I do this?
ps: sorry if I'm a little redundant
|||If what you want is a message to be displayed to the user to choose a value, then you should be able to accomplish this by unchecking the "Allow blank value" option as stated above.
For example, if there are two parameters say "Type" and "Subtype" but the user only selects "Type" and leaves "Subtype" blank, then once the user clicks "View Report" a popup message will be displayed to the user saying...
"Please enter a value for the parameter 'Subtype'. The parameter cannot be blank."
|||Thanks for helping me :)The pop up appears but I would like this message to show in the report layout but BEFORE ckliking on "view report"...just a simple generical message saying to the user something like "please choose a value for the X parameter and THEN click on view report"
The message is a sort of "guide".
I thought I can do this by placing a textbox but it seems that the textbox is linked to the chart (no chart no textbox)...i know it seems a stupid problem but unfortunatly I was asked to do this work this way.|||
Well, there is one way to generate a textbox in the report even without having a paremeter selected. Simply make sure all parameters are set to "Allow blank value" and "Allow null value". Then, create a textbox where the visibility is set to an expression, where it will only be displayed if any parameter is blank. Also, be sure to make the rest of the report items the opposite of that expression, i.e. they are only visible if all values are entered.
For example, Visibility -> Hidden = Iif(IsNothing(Parameters!ParameterName.Value) OrElse Parameters!ParameterName.Value.Equals(""), False, True)
This way the textbox will show up in the report whenever the user doesn't select a parameter value. However, the report will not autodetect the new values entered until the user clicks "View Report."
Good luck!!
|||Hi, thank you for your answer.Unfortunatly I don't seem to be able to set "allow null value" for the parameter I'm interested in, cause the application says that the properties for that object are invalid.
That object is a multi-value string available values from query.
So your suggestion does not work. :(
Saturday, February 25, 2012
Missing New Data Driven Subscriptions
Hello, I just migrated my reporting services to 2005 from 2000. My reports
have come across fine but I don't see the schedules that were set up for them.
Also, when I try to create a 'New Data-driven subscription' I don't see this
option; I used this feature in 2000. Is there some setting I need to change
somewhere?
ThanksOn Oct 4, 6:59 pm, Don <D...@.discussions.microsoft.com> wrote:
> Hello, I just migrated my reporting services to 2005 from 2000. My reports
> have come across fine but I don't see the schedules that were set up for them.
> Also, when I try to create a 'New Data-driven subscription' I don't see this
> option; I used this feature in 2000. Is there some setting I need to change
> somewhere?
> Thanks
If you do not have the SQL Server 2005 Enterprise Edition, this will
be the reason that they are not available (reference:
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
). Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||So it was a feature in the regular version of 2000 but limited to Enterprise
in 2005
"EMartinez" wrote:
> On Oct 4, 6:59 pm, Don <D...@.discussions.microsoft.com> wrote:
> > Hello, I just migrated my reporting services to 2005 from 2000. My reports
> > have come across fine but I don't see the schedules that were set up for them.
> >
> > Also, when I try to create a 'New Data-driven subscription' I don't see this
> > option; I used this feature in 2000. Is there some setting I need to change
> > somewhere?
> >
> > Thanks
>
> If you do not have the SQL Server 2005 Enterprise Edition, this will
> be the reason that they are not available (reference:
> http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
> ). Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>
have come across fine but I don't see the schedules that were set up for them.
Also, when I try to create a 'New Data-driven subscription' I don't see this
option; I used this feature in 2000. Is there some setting I need to change
somewhere?
ThanksOn Oct 4, 6:59 pm, Don <D...@.discussions.microsoft.com> wrote:
> Hello, I just migrated my reporting services to 2005 from 2000. My reports
> have come across fine but I don't see the schedules that were set up for them.
> Also, when I try to create a 'New Data-driven subscription' I don't see this
> option; I used this feature in 2000. Is there some setting I need to change
> somewhere?
> Thanks
If you do not have the SQL Server 2005 Enterprise Edition, this will
be the reason that they are not available (reference:
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
). Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||So it was a feature in the regular version of 2000 but limited to Enterprise
in 2005
"EMartinez" wrote:
> On Oct 4, 6:59 pm, Don <D...@.discussions.microsoft.com> wrote:
> > Hello, I just migrated my reporting services to 2005 from 2000. My reports
> > have come across fine but I don't see the schedules that were set up for them.
> >
> > Also, when I try to create a 'New Data-driven subscription' I don't see this
> > option; I used this feature in 2000. Is there some setting I need to change
> > somewhere?
> >
> > Thanks
>
> If you do not have the SQL Server 2005 Enterprise Edition, this will
> be the reason that they are not available (reference:
> http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
> ). Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>
Missing Information from Database
I have a serious problem with either SQL Server or SQL Reporting Services. I have 7 tables in a database that are relational. I have created serveral reports against this database. Last week when I pulled one of the reports, I was missing information on one of the cells. The reason why I know this is because my boss has us verify the report against the database. That took about an hour to complete. When we found that the report was not correct I repulled the report and the cell that was empty, was now populated. What gives? This is the same report I have pulled for the last month and had no problems until now. Is there a time issue involved between the last update to the database to the time I pull the report? Or maybe there is something wrong with the query?
SELECT Lease.[Lease #], MineralContacts.[Mineral Owner First Name], MineralContacts.[Mineral Owner Last Name], Tract.County, Tract.[Tract Number],
Tract.[Tract Description], Tract.Section, Tract.Block, Tract.Survey, Tract.Abstract, Lease.[Lease Date], Tract.[Title Check Though], Tract.[2ndTitleReview],
Tract.[2nd R/S Complete], Tract.[Title Agent], Tract.[Tract Gross Acres], SubTract.[Tract Net Acres], Draft.[Draft Status], Draft.[Draft Due Date],
Draft.[Draft Amount], Draft.[Draft #], Draft.[ANB Invoice #], Draft.[Lse File Sent to CP], Draft.[Money Wired from CP to EA],
Draft.[STA Approved Draft for pmt], Draft.[STA Recommend to Return Daft], Draft.[KE Advised ANB to Pay Draft], Draft.[KE Advised ANB to Return Draft],
Draft.[Paid Draft Recd], SubTract.Comments, SubTract.Hide
FROM Tract INNER JOIN
SubTract ON Tract.TractID = SubTract.TractID INNER JOIN
Mineral ON SubTract.SubTractID = Mineral.SubTractID INNER JOIN
Lease ON Mineral.MineralID = Lease.MineralID INNER JOIN
Draft ON Lease.LeaseID = Draft.LeaseID INNER JOIN
MineralContacts ON Mineral.MineralID = MineralContacts.MineralID
WHERE (Draft.[Draft Status] IS NOT NULL) AND (Draft.[Draft Due Date] IS NOT NULL)
Anyone have an answer?
Missing Information from Database
I have a serious problem with either SQL Server or SQL Reporting Services. I have 7 tables in a database that are relational. I have created serveral reports against this database. Last week when I pulled one of the reports, I was missing information on one of the cells. The reason why I know this is because my boss has us verify the report against the database. That took about an hour to complete. When we found that the report was not correct I repulled the report and the cell that was empty, was now populated. What gives? This is the same report I have pulled for the last month and had no problems until now. Is there a time issue involved between the last update to the database to the time I pull the report? Or maybe there is something wrong with the query?
SELECT Lease.[Lease #], MineralContacts.[Mineral Owner First Name], MineralContacts.[Mineral Owner Last Name], Tract.County, Tract.[Tract Number],
Tract.[Tract Description], Tract.Section, Tract.Block, Tract.Survey, Tract.Abstract, Lease.[Lease Date], Tract.[Title Check Though], Tract.[2ndTitleReview],
Tract.[2nd R/S Complete], Tract.[Title Agent], Tract.[Tract Gross Acres], SubTract.[Tract Net Acres], Draft.[Draft Status], Draft.[Draft Due Date],
Draft.[Draft Amount], Draft.[Draft #], Draft.[ANB Invoice #], Draft.[Lse File Sent to CP], Draft.[Money Wired from CP to EA],
Draft.[STA Approved Draft for pmt], Draft.[STA Recommend to Return Daft], Draft.[KE Advised ANB to Pay Draft], Draft.[KE Advised ANB to Return Draft],
Draft.[Paid Draft Recd], SubTract.Comments, SubTract.Hide
FROM Tract INNER JOIN
SubTract ON Tract.TractID = SubTract.TractID INNER JOIN
Mineral ON SubTract.SubTractID = Mineral.SubTractID INNER JOIN
Lease ON Mineral.MineralID = Lease.MineralID INNER JOIN
Draft ON Lease.LeaseID = Draft.LeaseID INNER JOIN
MineralContacts ON Mineral.MineralID = MineralContacts.MineralID
WHERE (Draft.[Draft Status] IS NOT NULL) AND (Draft.[Draft Due Date] IS NOT NULL)
Anyone have an answer?
Monday, February 20, 2012
Missing file: c:\stylesheet.css
I'm exporting a matrix report generated by Reporting Services to Excel. When
I open the report in Excel the first time, I get no messages. IF I open this
report in Excel and click the SAVE option (whether I made changes or not),
the next time I try to open the Excel file I get the message:
Missing file: c:\stylesheet.css
While you can click OK and ignore this message and the file will open, I
would like to find a way to prevent this when this report is put into
production.
FYI: I'm on Reporting Services SP2, SQL Server 2000, Excel 2003 SP1
Thanks.
--
DJansonI am experiencing this same error. Have you found a solution to it?
"DJanson" wrote:
> I'm exporting a matrix report generated by Reporting Services to Excel. When
> I open the report in Excel the first time, I get no messages. IF I open this
> report in Excel and click the SAVE option (whether I made changes or not),
> the next time I try to open the Excel file I get the message:
> Missing file: c:\stylesheet.css
> While you can click OK and ignore this message and the file will open, I
> would like to find a way to prevent this when this report is put into
> production.
> FYI: I'm on Reporting Services SP2, SQL Server 2000, Excel 2003 SP1
>
> Thanks.
> --
> DJanson|||No, but I did find out that not everyone who runs/opens this report has this
problem. I sent the exported file to another user and they did not get this
message.
--
DJanson
"DJanson" wrote:
> I'm exporting a matrix report generated by Reporting Services to Excel. When
> I open the report in Excel the first time, I get no messages. IF I open this
> report in Excel and click the SAVE option (whether I made changes or not),
> the next time I try to open the Excel file I get the message:
> Missing file: c:\stylesheet.css
> While you can click OK and ignore this message and the file will open, I
> would like to find a way to prevent this when this report is put into
> production.
> FYI: I'm on Reporting Services SP2, SQL Server 2000, Excel 2003 SP1
>
> Thanks.
> --
> DJanson
I open the report in Excel the first time, I get no messages. IF I open this
report in Excel and click the SAVE option (whether I made changes or not),
the next time I try to open the Excel file I get the message:
Missing file: c:\stylesheet.css
While you can click OK and ignore this message and the file will open, I
would like to find a way to prevent this when this report is put into
production.
FYI: I'm on Reporting Services SP2, SQL Server 2000, Excel 2003 SP1
Thanks.
--
DJansonI am experiencing this same error. Have you found a solution to it?
"DJanson" wrote:
> I'm exporting a matrix report generated by Reporting Services to Excel. When
> I open the report in Excel the first time, I get no messages. IF I open this
> report in Excel and click the SAVE option (whether I made changes or not),
> the next time I try to open the Excel file I get the message:
> Missing file: c:\stylesheet.css
> While you can click OK and ignore this message and the file will open, I
> would like to find a way to prevent this when this report is put into
> production.
> FYI: I'm on Reporting Services SP2, SQL Server 2000, Excel 2003 SP1
>
> Thanks.
> --
> DJanson|||No, but I did find out that not everyone who runs/opens this report has this
problem. I sent the exported file to another user and they did not get this
message.
--
DJanson
"DJanson" wrote:
> I'm exporting a matrix report generated by Reporting Services to Excel. When
> I open the report in Excel the first time, I get no messages. IF I open this
> report in Excel and click the SAVE option (whether I made changes or not),
> the next time I try to open the Excel file I get the message:
> Missing file: c:\stylesheet.css
> While you can click OK and ignore this message and the file will open, I
> would like to find a way to prevent this when this report is put into
> production.
> FYI: I'm on Reporting Services SP2, SQL Server 2000, Excel 2003 SP1
>
> Thanks.
> --
> DJanson
Missing File
I am trying hard to get my downloaded SQL server express working.
I need to have use of the reporting services.
This appears on my start menu, but clicking it gives a message that
devenv.exe is missing and can't be found anywhere.
Where does devenv.exe come from - how can I get hold of it?
Thanks for helping this newbie.The Business Intelligence Development Studio.
The readme has the information you need - you need the
Express Edition Toolkit. You can find the download link at:
http://msdn.microsoft.com/vstudio/express/sql/download/
-Sue
On Sun, 03 Sep 2006 20:49:58 GMT, "PeeJayEll"
<nospamthanks@.hotmail.com> wrote:
>I am trying hard to get my downloaded SQL server express working.
>I need to have use of the reporting services.
>This appears on my start menu, but clicking it gives a message that
>devenv.exe is missing and can't be found anywhere.
>Where does devenv.exe come from - how can I get hold of it?
>Thanks for helping this newbie.
>
>
I need to have use of the reporting services.
This appears on my start menu, but clicking it gives a message that
devenv.exe is missing and can't be found anywhere.
Where does devenv.exe come from - how can I get hold of it?
Thanks for helping this newbie.The Business Intelligence Development Studio.
The readme has the information you need - you need the
Express Edition Toolkit. You can find the download link at:
http://msdn.microsoft.com/vstudio/express/sql/download/
-Sue
On Sun, 03 Sep 2006 20:49:58 GMT, "PeeJayEll"
<nospamthanks@.hotmail.com> wrote:
>I am trying hard to get my downloaded SQL server express working.
>I need to have use of the reporting services.
>This appears on my start menu, but clicking it gives a message that
>devenv.exe is missing and can't be found anywhere.
>Where does devenv.exe come from - how can I get hold of it?
>Thanks for helping this newbie.
>
>
Missing Fields
I am calling a stored procedure from reporting services. The problem I'm
having is that it's only returning the first field in the result set in the
field list.
When I query under the data tab, data and field names are there and all data
is returned successfully.
I have tried refreshing the fieds, refreshing data, creating a new
report...you name it.
I have used both the sql server and ole db providers and both produce the
same behavoir.
The stored procedure has 5 parameters. I have tried both temp tables and
table variables in the stored procedure to no avail.
When I manually add the fields I get errors as well.
Can anyone provide any help or insight? I'm stumped on this one.
Thanks!OK...I think I have this figured out, although I'm not really happy about the
behavoir. Perhaps MS can put this on their list of issues.
It appears that if you use a stored procedure within another stored
procedure (say the one your calling to populate your report) , it throws off
the fields that are returned.
In my case, I have a stored procedure internal to the one I was calling that
figures out the current date. The return value was the only field being
returned within the reporting services .net interface.
Perhaps it's the way I'm calling the SP and assigning the return value to an
internal variable.
Nonetheless...I hope this helps. Hopefully someone from MS will comment on
this behavoir for us.
"Scott M" wrote:
> I am calling a stored procedure from reporting services. The problem I'm
> having is that it's only returning the first field in the result set in the
> field list.
> When I query under the data tab, data and field names are there and all data
> is returned successfully.
> I have tried refreshing the fieds, refreshing data, creating a new
> report...you name it.
> I have used both the sql server and ole db providers and both produce the
> same behavoir.
>
> The stored procedure has 5 parameters. I have tried both temp tables and
> table variables in the stored procedure to no avail.
>
> When I manually add the fields I get errors as well.
> Can anyone provide any help or insight? I'm stumped on this one.
> Thanks!|||Can you duplicate this behavior with either adventureworks2000 or northwind.
I would like to investigate this and see if there is a workaround.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Scott M" <ScottM@.discussions.microsoft.com> wrote in message
news:548E8585-626C-4A02-BD43-3B61B5E910E4@.microsoft.com...
> OK...I think I have this figured out, although I'm not really happy about
the
> behavoir. Perhaps MS can put this on their list of issues.
> It appears that if you use a stored procedure within another stored
> procedure (say the one your calling to populate your report) , it throws
off
> the fields that are returned.
> In my case, I have a stored procedure internal to the one I was calling
that
> figures out the current date. The return value was the only field being
> returned within the reporting services .net interface.
> Perhaps it's the way I'm calling the SP and assigning the return value to
an
> internal variable.
> Nonetheless...I hope this helps. Hopefully someone from MS will comment
on
> this behavoir for us.
> "Scott M" wrote:
> > I am calling a stored procedure from reporting services. The problem
I'm
> > having is that it's only returning the first field in the result set in
the
> > field list.
> >
> > When I query under the data tab, data and field names are there and all
data
> > is returned successfully.
> >
> > I have tried refreshing the fieds, refreshing data, creating a new
> > report...you name it.
> >
> > I have used both the sql server and ole db providers and both produce
the
> > same behavoir.
> >
> >
> > The stored procedure has 5 parameters. I have tried both temp tables
and
> > table variables in the stored procedure to no avail.
> >
> >
> > When I manually add the fields I get errors as well.
> >
> > Can anyone provide any help or insight? I'm stumped on this one.
> >
> > Thanks!|||Bruce,
I don't have those databases installed here at work...but I can give you the
essence of what happened.
There was a stored procedure called within a wrapper stored procedure. The
internal stored procedure was written to return the current period code
(200408, 200409 etc).
The wrapper stored procedure returned a recordset based on the period code
that was returned in the internal stored procedure.
When the report executed the wrapper stored procedure, it was only returning
the record from the internal stored procedure. So all I got was one field
with a value of the current period code.
I resolved the issue by creating a function to return the period code. That
seemed to fix it.
There might be a better way to call an internal stored procedure than the
way this was used. It was assigning an internally declared variable within
the wrapper stored procedure to the output parameter on the stored procedure
that returns the current period code.
Not sure if that helps. Seems like a bug to me, but perhaps it's by design
for some strange reason. Nonetheless, I'll have to re-write a lot of SP's in
order to utilize Reporting Services since the developer who originally
created a lot of the procedures in our environment didn't seem to utilize
functions.
Thanks for your response. Let me know if I can provide any further insight.
Scott
"Bruce L-C [MVP]" wrote:
> Can you duplicate this behavior with either adventureworks2000 or northwind.
> I would like to investigate this and see if there is a workaround.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Scott M" <ScottM@.discussions.microsoft.com> wrote in message
> news:548E8585-626C-4A02-BD43-3B61B5E910E4@.microsoft.com...
> > OK...I think I have this figured out, although I'm not really happy about
> the
> > behavoir. Perhaps MS can put this on their list of issues.
> >
> > It appears that if you use a stored procedure within another stored
> > procedure (say the one your calling to populate your report) , it throws
> off
> > the fields that are returned.
> >
> > In my case, I have a stored procedure internal to the one I was calling
> that
> > figures out the current date. The return value was the only field being
> > returned within the reporting services .net interface.
> >
> > Perhaps it's the way I'm calling the SP and assigning the return value to
> an
> > internal variable.
> >
> > Nonetheless...I hope this helps. Hopefully someone from MS will comment
> on
> > this behavoir for us.
> >
> > "Scott M" wrote:
> >
> > > I am calling a stored procedure from reporting services. The problem
> I'm
> > > having is that it's only returning the first field in the result set in
> the
> > > field list.
> > >
> > > When I query under the data tab, data and field names are there and all
> data
> > > is returned successfully.
> > >
> > > I have tried refreshing the fieds, refreshing data, creating a new
> > > report...you name it.
> > >
> > > I have used both the sql server and ole db providers and both produce
> the
> > > same behavoir.
> > >
> > >
> > > The stored procedure has 5 parameters. I have tried both temp tables
> and
> > > table variables in the stored procedure to no avail.
> > >
> > >
> > > When I manually add the fields I get errors as well.
> > >
> > > Can anyone provide any help or insight? I'm stumped on this one.
> > >
> > > Thanks!
>
>|||I've encountered the same problem. I've created about 50 reports based on
stored procedures and this is the first time this has occured.
The proc in question has 11 parameters. It returns the result set in the
Data Preview section, but only returns a single field in the field list. The
field returned is not even in the actual result set.
The proc I'm calling does call other procs. It was created bby a third party
and is used for other functions as well as the report I'm writing, so I can't
modify it.
Any ideas?
"Bruce L-C [MVP]" wrote:
> Can you duplicate this behavior with either adventureworks2000 or northwind.
> I would like to investigate this and see if there is a workaround.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Scott M" <ScottM@.discussions.microsoft.com> wrote in message
> news:548E8585-626C-4A02-BD43-3B61B5E910E4@.microsoft.com...
> > OK...I think I have this figured out, although I'm not really happy about
> the
> > behavoir. Perhaps MS can put this on their list of issues.
> >
> > It appears that if you use a stored procedure within another stored
> > procedure (say the one your calling to populate your report) , it throws
> off
> > the fields that are returned.
> >
> > In my case, I have a stored procedure internal to the one I was calling
> that
> > figures out the current date. The return value was the only field being
> > returned within the reporting services .net interface.
> >
> > Perhaps it's the way I'm calling the SP and assigning the return value to
> an
> > internal variable.
> >
> > Nonetheless...I hope this helps. Hopefully someone from MS will comment
> on
> > this behavoir for us.
> >
> > "Scott M" wrote:
> >
> > > I am calling a stored procedure from reporting services. The problem
> I'm
> > > having is that it's only returning the first field in the result set in
> the
> > > field list.
> > >
> > > When I query under the data tab, data and field names are there and all
> data
> > > is returned successfully.
> > >
> > > I have tried refreshing the fieds, refreshing data, creating a new
> > > report...you name it.
> > >
> > > I have used both the sql server and ole db providers and both produce
> the
> > > same behavoir.
> > >
> > >
> > > The stored procedure has 5 parameters. I have tried both temp tables
> and
> > > table variables in the stored procedure to no avail.
> > >
> > >
> > > When I manually add the fields I get errors as well.
> > >
> > > Can anyone provide any help or insight? I'm stumped on this one.
> > >
> > > Thanks!
>
>
having is that it's only returning the first field in the result set in the
field list.
When I query under the data tab, data and field names are there and all data
is returned successfully.
I have tried refreshing the fieds, refreshing data, creating a new
report...you name it.
I have used both the sql server and ole db providers and both produce the
same behavoir.
The stored procedure has 5 parameters. I have tried both temp tables and
table variables in the stored procedure to no avail.
When I manually add the fields I get errors as well.
Can anyone provide any help or insight? I'm stumped on this one.
Thanks!OK...I think I have this figured out, although I'm not really happy about the
behavoir. Perhaps MS can put this on their list of issues.
It appears that if you use a stored procedure within another stored
procedure (say the one your calling to populate your report) , it throws off
the fields that are returned.
In my case, I have a stored procedure internal to the one I was calling that
figures out the current date. The return value was the only field being
returned within the reporting services .net interface.
Perhaps it's the way I'm calling the SP and assigning the return value to an
internal variable.
Nonetheless...I hope this helps. Hopefully someone from MS will comment on
this behavoir for us.
"Scott M" wrote:
> I am calling a stored procedure from reporting services. The problem I'm
> having is that it's only returning the first field in the result set in the
> field list.
> When I query under the data tab, data and field names are there and all data
> is returned successfully.
> I have tried refreshing the fieds, refreshing data, creating a new
> report...you name it.
> I have used both the sql server and ole db providers and both produce the
> same behavoir.
>
> The stored procedure has 5 parameters. I have tried both temp tables and
> table variables in the stored procedure to no avail.
>
> When I manually add the fields I get errors as well.
> Can anyone provide any help or insight? I'm stumped on this one.
> Thanks!|||Can you duplicate this behavior with either adventureworks2000 or northwind.
I would like to investigate this and see if there is a workaround.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Scott M" <ScottM@.discussions.microsoft.com> wrote in message
news:548E8585-626C-4A02-BD43-3B61B5E910E4@.microsoft.com...
> OK...I think I have this figured out, although I'm not really happy about
the
> behavoir. Perhaps MS can put this on their list of issues.
> It appears that if you use a stored procedure within another stored
> procedure (say the one your calling to populate your report) , it throws
off
> the fields that are returned.
> In my case, I have a stored procedure internal to the one I was calling
that
> figures out the current date. The return value was the only field being
> returned within the reporting services .net interface.
> Perhaps it's the way I'm calling the SP and assigning the return value to
an
> internal variable.
> Nonetheless...I hope this helps. Hopefully someone from MS will comment
on
> this behavoir for us.
> "Scott M" wrote:
> > I am calling a stored procedure from reporting services. The problem
I'm
> > having is that it's only returning the first field in the result set in
the
> > field list.
> >
> > When I query under the data tab, data and field names are there and all
data
> > is returned successfully.
> >
> > I have tried refreshing the fieds, refreshing data, creating a new
> > report...you name it.
> >
> > I have used both the sql server and ole db providers and both produce
the
> > same behavoir.
> >
> >
> > The stored procedure has 5 parameters. I have tried both temp tables
and
> > table variables in the stored procedure to no avail.
> >
> >
> > When I manually add the fields I get errors as well.
> >
> > Can anyone provide any help or insight? I'm stumped on this one.
> >
> > Thanks!|||Bruce,
I don't have those databases installed here at work...but I can give you the
essence of what happened.
There was a stored procedure called within a wrapper stored procedure. The
internal stored procedure was written to return the current period code
(200408, 200409 etc).
The wrapper stored procedure returned a recordset based on the period code
that was returned in the internal stored procedure.
When the report executed the wrapper stored procedure, it was only returning
the record from the internal stored procedure. So all I got was one field
with a value of the current period code.
I resolved the issue by creating a function to return the period code. That
seemed to fix it.
There might be a better way to call an internal stored procedure than the
way this was used. It was assigning an internally declared variable within
the wrapper stored procedure to the output parameter on the stored procedure
that returns the current period code.
Not sure if that helps. Seems like a bug to me, but perhaps it's by design
for some strange reason. Nonetheless, I'll have to re-write a lot of SP's in
order to utilize Reporting Services since the developer who originally
created a lot of the procedures in our environment didn't seem to utilize
functions.
Thanks for your response. Let me know if I can provide any further insight.
Scott
"Bruce L-C [MVP]" wrote:
> Can you duplicate this behavior with either adventureworks2000 or northwind.
> I would like to investigate this and see if there is a workaround.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Scott M" <ScottM@.discussions.microsoft.com> wrote in message
> news:548E8585-626C-4A02-BD43-3B61B5E910E4@.microsoft.com...
> > OK...I think I have this figured out, although I'm not really happy about
> the
> > behavoir. Perhaps MS can put this on their list of issues.
> >
> > It appears that if you use a stored procedure within another stored
> > procedure (say the one your calling to populate your report) , it throws
> off
> > the fields that are returned.
> >
> > In my case, I have a stored procedure internal to the one I was calling
> that
> > figures out the current date. The return value was the only field being
> > returned within the reporting services .net interface.
> >
> > Perhaps it's the way I'm calling the SP and assigning the return value to
> an
> > internal variable.
> >
> > Nonetheless...I hope this helps. Hopefully someone from MS will comment
> on
> > this behavoir for us.
> >
> > "Scott M" wrote:
> >
> > > I am calling a stored procedure from reporting services. The problem
> I'm
> > > having is that it's only returning the first field in the result set in
> the
> > > field list.
> > >
> > > When I query under the data tab, data and field names are there and all
> data
> > > is returned successfully.
> > >
> > > I have tried refreshing the fieds, refreshing data, creating a new
> > > report...you name it.
> > >
> > > I have used both the sql server and ole db providers and both produce
> the
> > > same behavoir.
> > >
> > >
> > > The stored procedure has 5 parameters. I have tried both temp tables
> and
> > > table variables in the stored procedure to no avail.
> > >
> > >
> > > When I manually add the fields I get errors as well.
> > >
> > > Can anyone provide any help or insight? I'm stumped on this one.
> > >
> > > Thanks!
>
>|||I've encountered the same problem. I've created about 50 reports based on
stored procedures and this is the first time this has occured.
The proc in question has 11 parameters. It returns the result set in the
Data Preview section, but only returns a single field in the field list. The
field returned is not even in the actual result set.
The proc I'm calling does call other procs. It was created bby a third party
and is used for other functions as well as the report I'm writing, so I can't
modify it.
Any ideas?
"Bruce L-C [MVP]" wrote:
> Can you duplicate this behavior with either adventureworks2000 or northwind.
> I would like to investigate this and see if there is a workaround.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Scott M" <ScottM@.discussions.microsoft.com> wrote in message
> news:548E8585-626C-4A02-BD43-3B61B5E910E4@.microsoft.com...
> > OK...I think I have this figured out, although I'm not really happy about
> the
> > behavoir. Perhaps MS can put this on their list of issues.
> >
> > It appears that if you use a stored procedure within another stored
> > procedure (say the one your calling to populate your report) , it throws
> off
> > the fields that are returned.
> >
> > In my case, I have a stored procedure internal to the one I was calling
> that
> > figures out the current date. The return value was the only field being
> > returned within the reporting services .net interface.
> >
> > Perhaps it's the way I'm calling the SP and assigning the return value to
> an
> > internal variable.
> >
> > Nonetheless...I hope this helps. Hopefully someone from MS will comment
> on
> > this behavoir for us.
> >
> > "Scott M" wrote:
> >
> > > I am calling a stored procedure from reporting services. The problem
> I'm
> > > having is that it's only returning the first field in the result set in
> the
> > > field list.
> > >
> > > When I query under the data tab, data and field names are there and all
> data
> > > is returned successfully.
> > >
> > > I have tried refreshing the fieds, refreshing data, creating a new
> > > report...you name it.
> > >
> > > I have used both the sql server and ole db providers and both produce
> the
> > > same behavoir.
> > >
> > >
> > > The stored procedure has 5 parameters. I have tried both temp tables
> and
> > > table variables in the stored procedure to no avail.
> > >
> > >
> > > When I manually add the fields I get errors as well.
> > >
> > > Can anyone provide any help or insight? I'm stumped on this one.
> > >
> > > Thanks!
>
>
Missing embedded images in Reporting Services
We currently have reports for a client running on SQL 2000 RS. The strange thing (problem) is that we can see any embedded image in the Report when we Preview it, and view it on our testing server (SQL 2000), but at the client's site (also running SQL 2000) the images don't appear at all. The same goes for any graphs inside the report as well. This is very puzzling as we cannot find out what the problem is. The other strange thing is that we can see the images on the client's site when running them through Report Manager, but when we go through the application using the Reports, then the images do not appear at all. We have no idea of what's wrong. The app is running on 2003 Server x64, the database is being hosted on another server running 2003 Server, and the report server is running on another server running Windows 2000 Server.
Any help will be much appreciated.
Hi Eduard,
Any luck resolving this issue? We are having the same problem and have not been able to find a solution. Any help would be appreciated.
Thanks,
Joel
|||Do the images show up when exported to PDF?
You might want to try setting UseSessionCookies to false in the ConfigurationInfo table of the ReportServer db.
Subscribe to:
Posts (Atom)