SSRS Books and Education
Thu, 2 Oct 2008 08:07:03 -0700
Can someone suggest any good books out there or any good educational
resources that they have utilized in order to learn and use SQL Server
Reporting Services???
Any good web sites for learning SSRS???
Thanks in advance for your help.
PSULionRP ...
|
SharePoint 2007 and SSRS reports question
Thu, 2 Oct 2008 06:57:01 -0700
I have created SSRS reports and uploaded them into the Reports Library in our
SharePoint site. Reports contain parameters and once they are filled out,
the reports run OK.
My need is to hack/customize RSViewerPage.aspx page so that I can edit the
ReportViewerWebPart part of the page(the center part of th ...
|
Missing data from XML data provider
Thu, 2 Oct 2008 06:45:00 -0700
Hello
I have an ASP.net application that renders a report from a XML-file. The
file looks like this.
<?xml version="1.0" standalone="yes"?>
<dsInstrumentList xmlns="http://localhost/XML/dsInstrumentList.xsd">
<InstrumentList>
<artnr>12317</artnr>
<MIO-nummer>M306215</MIO-nummer>
<Benämning>Te ...
|
Reporting Services 2008 Rendering pages in backgound does not work when showing page Number?
Thu, 2 Oct 2008 11:49:48 +0200
Hello,
I am using some reports which have hundeds of pages (depending on filtering
by the user).
Now with Reporting Services 2008 I understood, that the user gets to see the
first page almost immediately, while the rest is being rendered behind the
scenes. So I played a little with this feature.
I notic ...
|
problem with report item in page header
Thu, 2 Oct 2008 00:11:52 -0700 (PDT)
Hello.
I'm trying to use the same reportItem (textbox) twice in a report
header.
Like:
=switch(reportItem!txt1.value="a","a", reportItem!txt1.value="b","b")
and I'm geting the error:
[rsMultiReportItemsInPageSectionExpression] The Value expression for
the
textbox 'txt1' refers to more than one repo ...
|
Report Group By
Wed, 01 Oct 2008 16:09:28 GMT
Hello!
I have a stored procedure that outputs the below, and creates the dataset
that my report references.
FieldName FieldAddress FieldOrderID
John 10 Lane 15
John 10 Lane 17
In my report which has a table I have dropped the "FieldName" and
"FieldAddress" v ...
|
Format Year
Wed, 1 Oct 2008 08:27:01 -0700
SSRS 2005
What is the correct syntax to format a year from DatePart.
I have the following expression:
=Switch(Fields!SortOrder.Value = 1, DatePart("yyyy", Fields!EndDate.Value),
Fields!SortOrder.Value = 2, "YTD", Fields!SortOrder.Value = 3, "Actual")
The DatePart returns 2,007.00 instead of 2007.
Th ...
|
|
|
KB954609
Wed, 1 Oct 2008 06:41:11 -0700 (PDT)
I've installed KB954609 patch on Windows 2003 server. Now when i try
to export in pdf some report i have this error:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException
was thrown. (rrRenderingError) Visualizza la Guida in linea
Exception of type
Microsoft.ReportingService ...
|
Reporting Services Web Service
Wed, 1 Oct 2008 01:11:01 -0700
I have two identical report servers one of which is for development
(localhost) and the other is production.
From an ASP.NET project I try to add a Web Service Reference. When I do this
to http://localhost/ReportingServices all works fine.
If I try to do the same thing to the production server say:-
http: ...
|
Convert To PDF
Tue, 30 Sep 2008 22:33:00 -0700
Hi Kevin,
Report looks great in Visual studio and in My Browser, but when I convert it
to pdf for printing, Some long data not fit into that page. Its wrapped next
page.
i set to true for Keep together option also and i tried to Layout height
set.But no use.
I still have those annoying empty pages in the pr ...
|