How to treat Database Snapshots as if they were one database?

Hi,
I am considering various methods of creating a reporting database from
our production ERP system, in SQL Server 2005, and one of the solutions
suggested by the technical documentation is to create a database mirror
and a sequence of database snapshots. These snapshots, of course, have
different names.
This would be fine for client applications that we manage, in that we
could intercept client requests and connect them to the most recent
snapshots, and clear out the old snapshots as older connections finish.
However, we use applications such as Business Objects which point to a
named database. Does anyone have any suggestions about how we can get
such an application to always connect to the most up-to-date snapshot?
Thanks for any help in advance,
Rich"Rich B" <rjback@.hotmail.com> wrote in message
news:1138093573.261952.197210@.o13g2000cwo.googlegroups.com...
> Hi,
> I am considering various methods of creating a reporting database from
> our production ERP system, in SQL Server 2005, and one of the solutions
> suggested by the technical documentation is to create a database mirror
> and a sequence of database snapshots. These snapshots, of course, have
> different names.
> This would be fine for client applications that we manage, in that we
> could intercept client requests and connect them to the most recent
> snapshots, and clear out the old snapshots as older connections finish.
> However, we use applications such as Business Objects which point to a
> named database. Does anyone have any suggestions about how we can get
> such an application to always connect to the most up-to-date snapshot?
>
You can have a single database full of synonyms or views which point to the
most current snapshot. When you have a new snapshot you need to drop and
recreate all the synonyms or views. So you would need to ensure that client
applications don't hold schema locks (Sch-S) on the target objects for long
periods of time, preventing the switch. And you should recreate the objects
in a transaction so the client always gets a consitent view of the data.
David|||Thankyou, that seems like a reasonable approach.sql

How to toggle visibility of a group of columns in RS

Hi,

I need to toggle visibility of group of columns in reporting services report, just like we can do for rows. I know that individual fields can be hidden, but i need to hide/show complete column.

Thanks in anticipation.

Saeed

Hi,

This is not possible in Reporting Services. When do you need to hide/unhide the column? Maybe I can help with finding an alternative solution. For example, you can set the Visibility property to the value of a boolean parameter.

Greetz,

Geert

Geert Verhoeven
Consultant @. Ausy Belgium

My Personal Blog

|||

Hi

Thanks for your response.

I have came up with a work around. I have a summary coulmn based on few deatiled columns. Initialy when report is rendered, only summary column is visible, but has a + link associated with it to show detailed columns. Here is way to achieve it.

Get control name of heading of summary column. Then select all detail columns individualy and in visivility toggle item, type name of that heading summary column, and put visibility off. ( One caution here: Drop down list in visibility toggle item is empty. We will have to type summary heading control name here). Now, view report to test it.

Thanks

Saeed

|||

asalamo alaykom saeed ahmad

you can do that by using models in reporting services

it means that when you using a model you can let the user select within the report builder to use columns dynamicly

and you can do this in a defferent way by using sophesticated tsql using if and then that execute query with a specific columns by passing some parameter for the stored proc

http://www.123writers.com

How to toggle visibility of a group of columns in RS

Hi,

I need to toggle visibility of group of columns in reporting services report, just like we can do for rows. I know that individual fields can be hidden, but i need to hide/show complete column.

Thanks in anticipation.

Saeed

Hi,

This is not possible in Reporting Services. When do you need to hide/unhide the column? Maybe I can help with finding an alternative solution. For example, you can set the Visibility property to the value of a boolean parameter.

Greetz,

Geert

Geert Verhoeven
Consultant @. Ausy Belgium

My Personal Blog

|||

Hi

Thanks for your response.

I have came up with a work around. I have a summary coulmn based on few deatiled columns. Initialy when report is rendered, only summary column is visible, but has a + link associated with it to show detailed columns. Here is way to achieve it.

Get control name of heading of summary column. Then select all detail columns individualy and in visivility toggle item, type name of that heading summary column, and put visibility off. ( One caution here: Drop down list in visibility toggle item is empty. We will have to type summary heading control name here). Now, view report to test it.

Thanks

Saeed

|||

asalamo alaykom saeed ahmad

you can do that by using models in reporting services

it means that when you using a model you can let the user select within the report builder to use columns dynamicly

and you can do this in a defferent way by using sophesticated tsql using if and then that execute query with a specific columns by passing some parameter for the stored proc

http://www.123writers.com

How to tell if SP1 is installed?

Hi,
I was just wondering if somebody could tell me how to check and see if SP1
for SQL Reporting Services is installed on a particular machine?
Thanks>From the SP1 ReadMe:
"To identify which version of Reporting Services you have installed,
type the URL of the report server (for example,
http://<exampleWebServer>/reportserver). Version information is located
at the bottom of the page. The final product release is build
8.00.0743.00."
My SP1 installation is 8.00.878.00.
HTH
Erik|||Enter http://YourReportServerName/ReportServer in your browser. If the
version displayed is 8.00.878.00, then you have SP1.
Bob
"Spencer23" wrote:
> Hi,
> I was just wondering if somebody could tell me how to check and see if SP1
> for SQL Reporting Services is installed on a particular machine?
> Thanks|||Hi,
You can check the version number from http://machine/reportserver url.
Microsoft SQL Server Reporting Services Version 8.00.743.00 is version 1
without SP
Version 8.00.0878 is the onewith SP1
Microsoft SQL Server Reporting Services Version 9.00.852.00 is the latest
version coming with SQL Server 2005 Beta 2
Eralper
http://www.kodyaz.com
"Spencer23" wrote:
> Hi,
> I was just wondering if somebody could tell me how to check and see if SP1
> for SQL Reporting Services is installed on a particular machine?
> Thanks

How to suppress a group in reporting services and still show the detail for the group

Hi, Guys...
I have a problem in suppressing the group in reporting services. When i
set the visibility of the group with expression to false then the group
include the detail will be suppressed. How can i suppress the group
without suppress the detail of the group?
Thank you
Regards,
SumardiDid you set up 2 groups or just one?
What is the structure of your data?
regards,
Stas K.

How to Sum certain fields in a column

Hi all,
I am new to reporting services. What I am trying to do is display some of
our accounting data in a debit and credit fields. I am using this expression
to display the correct data in the fields:
=Iif(Fields!credit.value,0,Fields!Amount.Value), however at the bottom I want
to sum only the information that was displayed. Does anyone know how to best
achieve this?Hi there Cynthias,
good old days of access ;-)
AFAIK, -- > No there is no way to aggregate the report fields, you should do
this for best practice in your query, to minimize the rendering time, though
the Database Server (if you are using one) is in most cases the smartest
solution.
HTH, Jens Süßmeyer.
"cynthia" <cynthia@.discussions.microsoft.com> schrieb im Newsbeitrag
news:BEA9F4E0-4BCC-40DA-AD06-13F7ECB2537A@.microsoft.com...
> Hi all,
> I am new to reporting services. What I am trying to do is display some of
> our accounting data in a debit and credit fields. I am using this
> expression
> to display the correct data in the fields:
> =Iif(Fields!credit.value,0,Fields!Amount.Value), however at the bottom I
> want
> to sum only the information that was displayed. Does anyone know how to
> best
> achieve this?|||There is more than one way to do it.
One way that I think is particularly clean is to do the following. In your
field list (where you drag a field onto your form) do a right mouse click,
add field. The field can be a field that is not coming from the database but
is an expression. Put in the expression you have below and call it whatever
you want. This field is now indistinguishable from a field that came from
the database. You can sum, group, whatever you want on it.
The second way is to put in this:
=sum(iif(Fields!credit.value,0,Fields!Amount.Value)
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Jens Süßmeyer" <Jens@.sqlserver2005.de> wrote in message
news:%23ThjqK6PFHA.1528@.TK2MSFTNGP09.phx.gbl...
> Hi there Cynthias,
> good old days of access ;-)
> AFAIK, -- > No there is no way to aggregate the report fields, you should
do
> this for best practice in your query, to minimize the rendering time,
though
> the Database Server (if you are using one) is in most cases the smartest
> solution.
> HTH, Jens Süßmeyer.
>
> "cynthia" <cynthia@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:BEA9F4E0-4BCC-40DA-AD06-13F7ECB2537A@.microsoft.com...
> > Hi all,
> > I am new to reporting services. What I am trying to do is display some
of
> > our accounting data in a debit and credit fields. I am using this
> > expression
> > to display the correct data in the fields:
> > =Iif(Fields!credit.value,0,Fields!Amount.Value), however at the bottom I
> > want
> > to sum only the information that was displayed. Does anyone know how to
> > best
> > achieve this?
>

How to submit a report parameter?

Microsoft® SQL Server� Reporting Services provides a single entry point to the full functionality of the report server: the Reporting Services Web service. The Web service uses Simple Object Access Protocol (SOAP) over HTTP and acts as a communications interface between client programs and the report server. The Web service and its methods expose the functionality of the report server and allow you to create custom tools for any part of the report life cycle, from management to execution.
The application that we have build is using the Web Service and the .NET Framework. We have successfully created the proxy class for the Web service.
We are trying to:
Create a ReportServices control
Create a ReportViewer control
Render a specific Report
To render the Report, we need to pass it a string paramter.
Our status is the following:
We have successfully created the ReportServices control with the following:
ReportingService rs = new ReportingService();
If we don't pass a parameter, we have everthing working fine.
If we pass a parameter, the report does not render. A summary of the error message follows:
"The report parameter 'sDealerId' is read-only and cannot be modified."
The full error message follows:
<detail>
<ErrorCode xmlns="http://www.microsoft.com/sql/reportingservices">rsReadOnlyReportParameter</ErrorCode>
<HttpStatus xmlns="http://www.microsoft.com/sql/reportingservices">400</HttpStatus>
<Message xmlns="http://www.microsoft.com/sql/reportingservices">The report parameter 'sDealerId' is read-only and cannot be modified.</Message>
<HelpLink xmlns="http://www.microsoft.com/sql/reportingservices">http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsReadOnlyReportParameter&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00</HelpLink>
<ProductName xmlns="http://www.microsoft.com/sql/reportingservices">Microsoft SQL Server Reporting Services</ProductName>
<ProductVersion xmlns="http://www.microsoft.com/sql/reportingservices">8.00.878.00</ProductVersion>
<ProductLocaleId xmlns="http://www.microsoft.com/sql/reportingservices">127</ProductLocaleId>
<OperatingSystem xmlns="http://www.microsoft.com/sql/reportingservices">OsIndependent</OperatingSystem>
<CountryLocaleId xmlns="http://www.microsoft.com/sql/reportingservices">1033</CountryLocaleId>
<MoreInformation xmlns="http://www.microsoft.com/sql/reportingservices">
<Source>Microsoft.ReportingServices.Processing</Source>
<Message msrs:ErrorCode="rsReadOnlyReportParameter" msrs:HelpLink="http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsReadOnlyReportParameter&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00" xmlns:msrs="http://www.microsoft.com/sql/reportingservices">The report parameter 'sDealerId' is read-only and cannot be modified.</Message>
</MoreInformation>
<Warnings xmlns="http://www.microsoft.com/sql/reportingservices" />
</detail>
Has anyone ever successful passed parameters to a ReportServices and/or ReportViewer control? If so, have you ever seen this type of error message and do you know which specific security issue is causing this?
Thanks,
Robert Baker
ZxytekNot sure, Robert, but this sounds like the error that version 1 gives when
you try to update a parameter that has been rendered "read only". SP1
removed this limitation allowing you to keep a parameter hidden and yet
change it's value via the URL.
"zxytek" <zxytek@.hotmail.com> wrote in message
news:252C34F9-652F-494C-BBE7-807B07073216@.microsoft.com...
> Microsoft® SQL ServerT Reporting Services provides a single entry point to
the full functionality of the report server: the Reporting Services Web
service. The Web service uses Simple Object Access Protocol (SOAP) over HTTP
and acts as a communications interface between client programs and the
report server. The Web service and its methods expose the functionality of
the report server and allow you to create custom tools for any part of the
report life cycle, from management to execution.
> The application that we have build is using the Web Service and the .NET
Framework. We have successfully created the proxy class for the Web
service.
> We are trying to:
> Create a ReportServices control
> Create a ReportViewer control
> Render a specific Report
> To render the Report, we need to pass it a string paramter.
> Our status is the following:
> We have successfully created the ReportServices control with the
following:
> ReportingService rs = new ReportingService();
> If we don't pass a parameter, we have everthing working fine.
> If we pass a parameter, the report does not render. A summary of the
error message follows:
> "The report parameter 'sDealerId' is read-only and cannot be
modified."
> The full error message follows:
> <detail>
> <ErrorCode
xmlns="rsReadOnlyReportParam">http://www.microsoft.com/sql/reportingservices">rsReadOnlyReportParam
eter</ErrorCode>
> <HttpStatus
xmlns="400</HttpStatus>">http://www.microsoft.com/sql/reportingservices">400</HttpStatus>
> <Message
xmlns="The">http://www.microsoft.com/sql/reportingservices">The report parameter
'sDealerId' is read-only and cannot be modified.</Message>
> <HelpLink
xmlns="http://go.microsoft.c">http://www.microsoft.com/sql/reportingservices">http://go.microsoft.c
om/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utili
ties.ErrorStrings.resources.Strings&EvtID=rsReadOnlyReportParameter&ProdName
=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00</HelpLink>
> <ProductName
xmlns="Microsoft">http://www.microsoft.com/sql/reportingservices">Microsoft SQL Server
Reporting Services</ProductName>
> <ProductVersion
xmlns="8.00.878.00</ProductV">http://www.microsoft.com/sql/reportingservices">8.00.878.00</ProductV
ersion>
> <ProductLocaleId
xmlns="127</ProductLocaleId>">http://www.microsoft.com/sql/reportingservices">127</ProductLocaleId>
> <OperatingSystem
xmlns="OsIndependent</Operat">http://www.microsoft.com/sql/reportingservices">OsIndependent</Operat
ingSystem>
> <CountryLocaleId
xmlns="1033</CountryLocaleId">http://www.microsoft.com/sql/reportingservices">1033</CountryLocaleId
> <MoreInformation
xmlns="">http://www.microsoft.com/sql/reportingservices">
> <Source>Microsoft.ReportingServices.Processing</Source>
> <Message msrs:ErrorCode="rsReadOnlyReportParameter"
msrs:HelpLink="http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft
.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtI
D=rsReadOnlyReportParameter&ProdName=Microsoft%20SQL%20Server%20Reporting%20
Services&ProdVer=8.00"
xmlns:msrs="The">http://www.microsoft.com/sql/reportingservices">The report
parameter 'sDealerId' is read-only and cannot be modified.</Message>
> </MoreInformation>
> <Warnings xmlns="http://www.microsoft.com/sql/reportingservices"
/>
> </detail>
> Has anyone ever successful passed parameters to a ReportServices and/or
ReportViewer control? If so, have you ever seen this type of error message
and do you know which specific security issue is causing this?
> Thanks,
> Robert Baker
> Zxytek

How to stop reporting services deploy

I am using visual studio 2003 with sql reporting services for sql
server 2000.
I have a solution with a web application project and a reporting
services project.
When I start the web application project in the IDE, the reports are
automatically deployed to the report server.
I would like to stop this for two reasons: it takes too long, and my
reports are actually not ready to deploy.
Does anyone know how I can stop my reporting services project from
deploying when I run another project in the same solution?On May 15, 3:03 pm, wozza <Woz...@.gmail.com> wrote:
> I am using visual studio 2003 with sql reporting services for sql
> server 2000.
> I have a solution with a web application project and a reporting
> services project.
> When I start the web application project in the IDE, the reports are
> automatically deployed to the report server.
> I would like to stop this for two reasons: it takes too long, and my
> reports are actually not ready to deploy.
> Does anyone know how I can stop my reporting services project from
> deploying when I run another project in the same solution?
Does anyone have an answer?|||On May 15, 3:03 pm, wozza <Woz...@.gmail.com> wrote:
> I am using visual studio 2003 with sql reporting services for sql
> server 2000.
> I have a solution with a web application project and a reporting
> services project.
> When I start the web application project in the IDE, the reports are
> automatically deployed to the report server.
> I would like to stop this for two reasons: it takes too long, and my
> reports are actually not ready to deploy.
> Does anyone know how I can stop my reporting services project from
> deploying when I run another project in the same solution?
I can't believe I'm the only person who has ever encountered this.
Does anyone know how to work around this?|||On May 15, 3:03 pm, wozza <Woz...@.gmail.com> wrote:
> I am using visual studio 2003 with sql reporting services for sql
> server 2000.
> I have a solution with a web application project and a reporting
> services project.
> When I start the web application project in the IDE, the reports are
> automatically deployed to the report server.
> I would like to stop this for two reasons: it takes too long, and my
> reports are actually not ready todeploy.
> Does anyone know how I can stop my reporting services project from
> deploying when I run another project in the same solution?
OK, I've found the answer, which I'll document here for prosperity.
Right click the solution and go properties.
go configuration properties/configuration
reporting services projects have a "deploy" check box. Uncheck to stop
deployment.

How to stick a chart into the middle of an external page

Hello
I am using Reporting Services within Visual Studio .Net 2003, connecting to
a SQL Server 2000 database.
I've been using RS for a while, but only for basic reports. Now I want to
do something a bit more advanced. I'm not sure exactly how to put the
question, so am going for the 'plain English' approach, hoping someone will
follow...
I've been asked by a user about embedding a RS chart into the middle of an
external (possibly web or .Net) page. He wants to be able to pass
parameters to RS, have it create a chart, then embed the chart in his page.
He only wants the chart, however, not the whole web page as you would view
it through a browser. So he would have text, followed by a chart, followed
by more text, like a standard report.
I'm assuming this would need to be coded, but don't really know where to
start. I'd appreciate some pointers, just to head me in the right
direction.
Thanks
DeniseYou might want to create a report that contains only the chart. Render the
report via the ReportServer web service as HTML, which will allow you to get
the images via the RenderStream method.
Save the image data to a temp file, and display it on your page.
If you take a look at the ReportViewer sample provided by MS with Reporting
Services 2000, it pretty much has all the code you will need.
"Denise" <me@.me.com> wrote in message
news:1vbyx9jxpcpa7$.1jcgop5kq2aji$.dlg@.40tude.net...
> Hello
> I am using Reporting Services within Visual Studio .Net 2003, connecting
> to
> a SQL Server 2000 database.
> I've been using RS for a while, but only for basic reports. Now I want to
> do something a bit more advanced. I'm not sure exactly how to put the
> question, so am going for the 'plain English' approach, hoping someone
> will
> follow...
> I've been asked by a user about embedding a RS chart into the middle of an
> external (possibly web or .Net) page. He wants to be able to pass
> parameters to RS, have it create a chart, then embed the chart in his
> page.
> He only wants the chart, however, not the whole web page as you would view
> it through a browser. So he would have text, followed by a chart,
> followed
> by more text, like a standard report.
> I'm assuming this would need to be coded, but don't really know where to
> start. I'd appreciate some pointers, just to head me in the right
> direction.
> Thanks
> Denise|||Hi Pedro
Thanks very much for this. I've gone through the sample and produced a
report, passing parameters via the code. My user is very happy!
Thanks again
Denise
On Sat, 19 Nov 2005 20:25:26 -0600, Pedro wrote:
> You might want to create a report that contains only the chart. Render the
> report via the ReportServer web service as HTML, which will allow you to get
> the images via the RenderStream method.
> Save the image data to a temp file, and display it on your page.
> If you take a look at the ReportViewer sample provided by MS with Reporting
> Services 2000, it pretty much has all the code you will need.
>
> "Denise" <me@.me.com> wrote in message
> news:1vbyx9jxpcpa7$.1jcgop5kq2aji$.dlg@.40tude.net...
>> Hello
>> I am using Reporting Services within Visual Studio .Net 2003, connecting
>> to
>> a SQL Server 2000 database.
>> I've been using RS for a while, but only for basic reports. Now I want to
>> do something a bit more advanced. I'm not sure exactly how to put the
>> question, so am going for the 'plain English' approach, hoping someone
>> will
>> follow...
>> I've been asked by a user about embedding a RS chart into the middle of an
>> external (possibly web or .Net) page. He wants to be able to pass
>> parameters to RS, have it create a chart, then embed the chart in his
>> page.
>> He only wants the chart, however, not the whole web page as you would view
>> it through a browser. So he would have text, followed by a chart,
>> followed
>> by more text, like a standard report.
>> I'm assuming this would need to be coded, but don't really know where to
>> start. I'd appreciate some pointers, just to head me in the right
>> direction.
>> Thanks
>> Denise