Friday, March 30, 2012
Recent SSRS books?
someone recommend 2 or 3 books on the subject? I am interested in a
book beyond the basics. (I believe I don't need the hand holding, or
"step by step," as that most of that can be found online.)
We will be applying report security and integrating with SharePoint in
the near future as well.
I found these so far.
1) Mastering SQL Server 2005 Reporting Services Infrastructure Design
(Joseph L. Jorden - Sybex, Published 2007)
2) Microsoft SQL Server 2005 Reporting Services (Brian Larson - McGraw-
Hill, Published 2005)
The first book listed above has a section discussing role based
security and SharePoint deployment. Are these mostly a slam dunk and
I don't need this in a book?
Has much changed since 2005? There are many books from 2005/2006 and
a few published more recently.
Thanks in advance!
DanI can recomend :-
http://www.amazon.co.uk/Hitchhikers-Guide-Visual-Studio-Server/dp/0321243625/ref=sr_1_1?ie=UTF8&s=books&qid=1196846573&sr=8-1
It covers most topics and starts at a level where you are expected to have
had a play with reporting services and mastered some of the basics of
creating reports.
Cheers
Dale
"ZCSI" <danzemmels@.gmail.com> wrote in message
news:f07e2e87-d3f8-4cd4-a9db-db259766e31d@.y43g2000hsy.googlegroups.com...
>I will be starting a new project using SS2005 Reporting Services. Can
> someone recommend 2 or 3 books on the subject? I am interested in a
> book beyond the basics. (I believe I don't need the hand holding, or
> "step by step," as that most of that can be found online.)
> We will be applying report security and integrating with SharePoint in
> the near future as well.
> I found these so far.
> 1) Mastering SQL Server 2005 Reporting Services Infrastructure Design
> (Joseph L. Jorden - Sybex, Published 2007)
> 2) Microsoft SQL Server 2005 Reporting Services (Brian Larson - McGraw-
> Hill, Published 2005)
> The first book listed above has a section discussing role based
> security and SharePoint deployment. Are these mostly a slam dunk and
> I don't need this in a book?
> Has much changed since 2005? There are many books from 2005/2006 and
> a few published more recently.
> Thanks in advance!
> Dan|||I have the Brian Larson book on my desk, and it's really helpful, but I'm not
a developper but a DBA. So I'm more interested in the technical en security
side of RS.
But it's a good book, and it does the trick for me.
"Dale" wrote:
> I can recomend :-
> http://www.amazon.co.uk/Hitchhikers-Guide-Visual-Studio-Server/dp/0321243625/ref=sr_1_1?ie=UTF8&s=books&qid=1196846573&sr=8-1
> It covers most topics and starts at a level where you are expected to have
> had a play with reporting services and mastered some of the basics of
> creating reports.
> Cheers
> Dale
>
> "ZCSI" <danzemmels@.gmail.com> wrote in message
> news:f07e2e87-d3f8-4cd4-a9db-db259766e31d@.y43g2000hsy.googlegroups.com...
> >I will be starting a new project using SS2005 Reporting Services. Can
> > someone recommend 2 or 3 books on the subject? I am interested in a
> > book beyond the basics. (I believe I don't need the hand holding, or
> > "step by step," as that most of that can be found online.)
> >
> > We will be applying report security and integrating with SharePoint in
> > the near future as well.
> >
> > I found these so far.
> > 1) Mastering SQL Server 2005 Reporting Services Infrastructure Design
> > (Joseph L. Jorden - Sybex, Published 2007)
> > 2) Microsoft SQL Server 2005 Reporting Services (Brian Larson - McGraw-
> > Hill, Published 2005)
> >
> > The first book listed above has a section discussing role based
> > security and SharePoint deployment. Are these mostly a slam dunk and
> > I don't need this in a book?
> >
> > Has much changed since 2005? There are many books from 2005/2006 and
> > a few published more recently.
> >
> > Thanks in advance!
> > Dan
>
>
Wednesday, March 28, 2012
Receive "Must declare the variable" When Upgrading to Reporting Services 2005
We are in the process of migrating our databases to SQL Server 2005 and our Reporting Services Reports to 2005. We have been doing this in a phased approach with excellent success.
However, I have a set of Reporting Services 2000 reports that are reading from a SQL Server 7.0 database. If possible, I would like to migrate the reports before we migrate the database (we're not ready to migrate the database yet).
When I converted the reports to Reporting Services 2005, I first received an error message regarding my data source. Basically the message says anything developed in Visual Studio 2005 using the Microsoft SQL Server connection type cannot connect to a database prior to Microsoft SQL Server 2000. So I switched the connection string to be a OLE DB type.
Well ... the reports contain parameters (i.e. @.plant, @.employee, etc). So when I attempt to run the query, I get a message saying "Must declare the variable '@.plant'". I have searched for a work around until we migrate the database but I am coming up empty.
Is there a way for me to run a report with parameters from Reporting Services 2005 to a SQL Server database that is prior to SQL Server 2000?
Thanks in advance.
OLE DB Parameters are not named. Instead of @.foo for parameters in the SELECT statement, you use ? I thought the managed provider should work, though. What is the exact error?|||Thank you for replying. The exact error that is displayed is as follows:
An error occurred during the local report processing
An error has occurred during report processing
Query execution failed for data set 'Journal'
Must declare the variable '@.plant'.
So if OLE DB does not support named parameters, can I use multiple parameters in this report? The report contains seven different parameters.
|||According to documentation...
The OLE DB provider for SQL Server does not support named variables. Use the question mark (?) character to specify a variable. Parameters passed to the OLE DB provider must be passed in the order they occur in the WHERE clause. For example, PM.Name LIKE ('%' + ? + '%').
http://msdn2.microsoft.com/en-us/library/aa337223.aspx
Other providers may support.
However, you should be able to use query expression & a Reporting Services parameter.
eg. ="Select value from table where value = " + Parameters!MyParam.Value
cheers,
Andrew
|||Hi,
Did you get the solution to this error ?
I'm getting the same error when I try to pass a multi-list of values from SRS2005 to a storeprocedure.
Please let me know if your report in the dataset has a query or SP.
Thanks
Pepe
Receive "Must declare the variable" When Upgrading to Reporting Services 2005
We are in the process of migrating our databases to SQL Server 2005 and our Reporting Services Reports to 2005. We have been doing this in a phased approach with excellent success.
However, I have a set of Reporting Services 2000 reports that are reading from a SQL Server 7.0 database. If possible, I would like to migrate the reports before we migrate the database (we're not ready to migrate the database yet).
When I converted the reports to Reporting Services 2005, I first received an error message regarding my data source. Basically the message says anything developed in Visual Studio 2005 using the Microsoft SQL Server connection type cannot connect to a database prior to Microsoft SQL Server 2000. So I switched the connection string to be a OLE DB type.
Well ... the reports contain parameters (i.e. @.plant, @.employee, etc). So when I attempt to run the query, I get a message saying "Must declare the variable '@.plant'". I have searched for a work around until we migrate the database but I am coming up empty.
Is there a way for me to run a report with parameters from Reporting Services 2005 to a SQL Server database that is prior to SQL Server 2000?
Thanks in advance.
OLE DB Parameters are not named. Instead of @.foo for parameters in the SELECT statement, you use ? I thought the managed provider should work, though. What is the exact error?|||Thank you for replying. The exact error that is displayed is as follows:
An error occurred during the local report processing
An error has occurred during report processing
Query execution failed for data set 'Journal'
Must declare the variable '@.plant'.
So if OLE DB does not support named parameters, can I use multiple parameters in this report? The report contains seven different parameters.
|||According to documentation...
The OLE DB provider for SQL Server does not support named variables. Use the question mark (?) character to specify a variable. Parameters passed to the OLE DB provider must be passed in the order they occur in the WHERE clause. For example, PM.Name LIKE ('%' + ? + '%').
http://msdn2.microsoft.com/en-us/library/aa337223.aspx
Other providers may support.
However, you should be able to use query expression & a Reporting Services parameter.
eg. ="Select value from table where value = " + Parameters!MyParam.Value
cheers,
Andrew
|||Hi,
Did you get the solution to this error ?
I'm getting the same error when I try to pass a multi-list of values from SRS2005 to a storeprocedure.
Please let me know if your report in the dataset has a query or SP.
Thanks
Pepe
sqlWednesday, March 7, 2012
Realtime/streaming data
the user click the refresh button? I am wanting to show realtime stock
quotes in a reporting services report and update stock quotes as they come in
without having to call the refrsh method in the report viewer or having the
user have to click the refrsh button. I am using the report viewer component
in a C# winforms app.
Thanks in advance!!!Use the timer object in the C# winform and refresh the control. You could
have it refresh every minute or 30 sec - but anything more 'real time' than
that - Reporting Services is probably not a real good solution.
"David" <David@.discussions.microsoft.com> wrote in message
news:A05DA637-32B3-48CE-8972-14135DE7888B@.microsoft.com...
> Is there a way to update data on a reporting services report without
> having
> the user click the refresh button? I am wanting to show realtime stock
> quotes in a reporting services report and update stock quotes as they come
> in
> without having to call the refrsh method in the report viewer or having
> the
> user have to click the refrsh button. I am using the report viewer
> component
> in a C# winforms app.
> Thanks in advance!!!|||If you're using RS 2005 you can set the "Autorefresh" for the report
property to the desired refresh interval. It worked in VS preview and
in the the web browser. So I wouild think if you are using the report
viewer control the autorefresh would work there to.
On Sat, 13 May 2006 15:50:01 -0700, David
<David@.discussions.microsoft.com> wrote:
>Is there a way to update data on a reporting services report without having
>the user click the refresh button? I am wanting to show realtime stock
>quotes in a reporting services report and update stock quotes as they come in
>without having to call the refrsh method in the report viewer or having the
>user have to click the refrsh button. I am using the report viewer component
>in a C# winforms app.
>Thanks in advance!!!|||Thanks for trying guys. As I said in my initial email I want to update
values on the report without the report refreshing as a refresh is annoying
to the user and takes you back to the beginning of a report given you are in
backend pages of the report...
"Mark" wrote:
> If you're using RS 2005 you can set the "Autorefresh" for the report
> property to the desired refresh interval. It worked in VS preview and
> in the the web browser. So I wouild think if you are using the report
> viewer control the autorefresh would work there to.
> On Sat, 13 May 2006 15:50:01 -0700, David
> <David@.discussions.microsoft.com> wrote:
> >Is there a way to update data on a reporting services report without having
> >the user click the refresh button? I am wanting to show realtime stock
> >quotes in a reporting services report and update stock quotes as they come in
> >without having to call the refrsh method in the report viewer or having the
> >user have to click the refrsh button. I am using the report viewer component
> >in a C# winforms app.
> >Thanks in advance!!!
>
Saturday, February 25, 2012
real time reporting + OLTP dbs
systems. Right now we run nightly extracts and load into OLAP DBs to
minimise locking,etc while the extracts are being run. However our customers
now want to see real time data as soon as possible and we cannot give them
access to the live OLTP systems. Are there any ways to implement this
efficiently ?Have you tried replication? It should give you more frequent updates.
You might want to consider using read uncommitted query because replication
also needs to make changes to your OLAP database to keep data up to date.
--
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://weblogs.asp.net/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:upTfU1d0EHA.3584@.TK2MSFTNGP11.phx.gbl...
> How does one implement real time reporting off of data from the OLTP
> systems. Right now we run nightly extracts and load into OLAP DBs to
> minimise locking,etc while the extracts are being run. However our
> customers
> now want to see real time data as soon as possible and we cannot give them
> access to the live OLTP systems. Are there any ways to implement this
> efficiently ?
>|||we thought about replication but cant really justify replicating each of our
OLTP dbs to serve the reporting needs besides the administration needed to
support it ,etc..
"wei xiao [MSFT]" <weix@.online.microsoft.com> wrote in message
news:Oc0vFSf0EHA.2568@.TK2MSFTNGP11.phx.gbl...
> Have you tried replication? It should give you more frequent updates.
> You might want to consider using read uncommitted query because
replication
> also needs to make changes to your OLAP database to keep data up to date.
> --
> Wei Xiao [MSFT]
> SQL Server Storage Engine Development
> http://weblogs.asp.net/weix
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Hassan" <fatima_ja@.hotmail.com> wrote in message
> news:upTfU1d0EHA.3584@.TK2MSFTNGP11.phx.gbl...
> > How does one implement real time reporting off of data from the OLTP
> > systems. Right now we run nightly extracts and load into OLAP DBs to
> > minimise locking,etc while the extracts are being run. However our
> > customers
> > now want to see real time data as soon as possible and we cannot give
them
> > access to the live OLTP systems. Are there any ways to implement this
> > efficiently ?
> >
> >
>
real time reporting + OLTP dbs
systems. Right now we run nightly extracts and load into OLAP DBs to
minimise locking,etc while the extracts are being run. However our customers
now want to see real time data as soon as possible and we cannot give them
access to the live OLTP systems. Are there any ways to implement this
efficiently ?
Have you tried replication? It should give you more frequent updates.
You might want to consider using read uncommitted query because replication
also needs to make changes to your OLAP database to keep data up to date.
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://weblogs.asp.net/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:upTfU1d0EHA.3584@.TK2MSFTNGP11.phx.gbl...
> How does one implement real time reporting off of data from the OLTP
> systems. Right now we run nightly extracts and load into OLAP DBs to
> minimise locking,etc while the extracts are being run. However our
> customers
> now want to see real time data as soon as possible and we cannot give them
> access to the live OLTP systems. Are there any ways to implement this
> efficiently ?
>
|||we thought about replication but cant really justify replicating each of our
OLTP dbs to serve the reporting needs besides the administration needed to
support it ,etc..
"wei xiao [MSFT]" <weix@.online.microsoft.com> wrote in message
news:Oc0vFSf0EHA.2568@.TK2MSFTNGP11.phx.gbl...
> Have you tried replication? It should give you more frequent updates.
> You might want to consider using read uncommitted query because
replication
> also needs to make changes to your OLAP database to keep data up to date.
> --
> Wei Xiao [MSFT]
> SQL Server Storage Engine Development
> http://weblogs.asp.net/weix
> This posting is provided "AS IS" with no warranties, and confers no
rights.[vbcol=seagreen]
> "Hassan" <fatima_ja@.hotmail.com> wrote in message
> news:upTfU1d0EHA.3584@.TK2MSFTNGP11.phx.gbl...
them
>
real time reporting + OLTP dbs
systems. Right now we run nightly extracts and load into OLAP DBs to
minimise locking,etc while the extracts are being run. However our customers
now want to see real time data as soon as possible and we cannot give them
access to the live OLTP systems. Are there any ways to implement this
efficiently ?Have you tried replication? It should give you more frequent updates.
You might want to consider using read uncommitted query because replication
also needs to make changes to your OLAP database to keep data up to date.
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://weblogs.asp.net/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:upTfU1d0EHA.3584@.TK2MSFTNGP11.phx.gbl...
> How does one implement real time reporting off of data from the OLTP
> systems. Right now we run nightly extracts and load into OLAP DBs to
> minimise locking,etc while the extracts are being run. However our
> customers
> now want to see real time data as soon as possible and we cannot give them
> access to the live OLTP systems. Are there any ways to implement this
> efficiently ?
>|||we thought about replication but cant really justify replicating each of our
OLTP dbs to serve the reporting needs besides the administration needed to
support it ,etc..
"wei xiao [MSFT]" <weix@.online.microsoft.com> wrote in message
news:Oc0vFSf0EHA.2568@.TK2MSFTNGP11.phx.gbl...
> Have you tried replication? It should give you more frequent updates.
> You might want to consider using read uncommitted query because
replication
> also needs to make changes to your OLAP database to keep data up to date.
> --
> Wei Xiao [MSFT]
> SQL Server Storage Engine Development
> http://weblogs.asp.net/weix
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Hassan" <fatima_ja@.hotmail.com> wrote in message
> news:upTfU1d0EHA.3584@.TK2MSFTNGP11.phx.gbl...
them[vbcol=seagreen]
>