quality of service

I have been having what I believe to be quality of service issues with the c
ompany that hosts my company's web site and connected SQL Server database.
The same stored procedure is called from a number of different web pages wit
h identical parameter specs
, etc. (they were all created from the same template web page). Over the pa
st three weeks, this stored procedure has been called more than 20,000 times
by more than 1,000 different end users, and has failed to drop a table it c
reates 70 of these times (a
99.7% successful execution rate), which causes significant problems for the
end user, since the next time this procedure is called, the table already ex
ists. There is seemingly no pattern to these failed executions with regard
to particular end users, o
r to which pages from which they were called. However, there is a pattern i
n the timing. All but 4 of the failed executions occurred clustered around
about 10 very specific time stamps (i.e., 5 of the tables that were not drop
ped were created within a m
inute of 2:27 pm, 15 of the tables that were not dropped were created within
1 minute of 2:27 pm, etc.). The company that hosts my web site and connect
ed SQL Server database insists that the problem is in my scripting and refus
e to look into the issue un
less I pay them $120 per hour to do so. It seems to me that, if this were s
cripting error, it probably would not be succeeding 99.7% of the time, and a
ny failures that did occur would be randomly distributed, not clustered arou
nd specific time stamps. I
t seems to me that this clustering is indicative of slowed or failed SQL Ser
ver responses due to server performance issues. I work in statistics and ha
ve calculated the odds of this time clustering being random, and, even with
the most conservative estim
ates, it works out to be on in a number I don't even know the name for (with
more than 40 zeros). I have included a little information about the stored
procedure below, if you think it is relevant. my question to you is: Does t
his seem likely to be a scr
ipting issue or a server performance issue?
Part of the stored procedure uses the sp_executesql command with a text stri
ng to create a table with the unique name of the end user ID (a unique, rand
omly generated 12 character alphanumeric ID), inserts data into this new tab
le through a loop, then pul
ls a record set from the table, and drops the table (there is a good reason
I need to generate the recordset this way).
Thank you for your help!
SQL SearcherWhy can't you use a temp table? That's what they're there for...
"SQL Searcher" <anonymous@.discussions.microsoft.com> wrote in message
news:FB3A473E-7ED7-4E01-A8F9-95F7ABA12313@.microsoft.com...
> I have been having what I believe to be quality of service issues with the
company that hosts my company's web site and connected SQL Server database.
The same stored procedure is called from a number of different web pages
with identical parameter specs, etc. (they were all created from the same
template web page). Over the past three weeks, this stored procedure has
been called more than 20,000 times by more than 1,000 different end users,
and has failed to drop a table it creates 70 of these times (a 99.7%
successful execution rate), which causes significant problems for the end
user, since the next time this procedure is called, the table already
exists. There is seemingly no pattern to these failed executions with
regard to particular end users, or to which pages from which they were
called. However, there is a pattern in the timing. All but 4 of the failed
executions occurred clustered around about 10 very specific time stamps
(i.e., 5 of the tables that were not dropped were created within a minute of
2:27 pm, 15 of the tables that were not dropped were created within 1 minute
of 2:27 pm, etc.). The company that hosts my web site and connected SQL
Server database insists that the problem is in my scripting and refuse to
look into the issue unless I pay them $120 per hour to do so. It seems to
me that, if this were scripting error, it probably would not be succeeding
99.7% of the time, and any failures that did occur would be randomly
distributed, not clustered around specific time stamps. It seems to me that
this clustering is indicative of slowed or failed SQL Server responses due
to server performance issues. I work in statistics and have calculated the
odds of this time clustering being random, and, even with the most
conservative estimates, it works out to be on in a number I don't even know
the name for (with more than 40 zeros). I have included a little information
about the stored procedure below, if you think it is relevant. my question
to you is: Does this seem likely to be a scripting issue or a server
performance issue?
> Part of the stored procedure uses the sp_executesql command with a text
string to create a table with the unique name of the end user ID (a unique,
randomly generated 12 character alphanumeric ID), inserts data into this new
table through a loop, then pulls a record set from the table, and drops the
table (there is a good reason I need to generate the recordset this way).
> Thank you for your help!
> SQL Searcher|||I tried, and it didn't work for some reason.

quality of service

I have been having what I believe to be quality of service issues with the company that hosts my company's web site and connected SQL Server database. The same stored procedure is called from a number of different web pages with identical parameter specs, etc. (they were all created from the same template web page). Over the past three weeks, this stored procedure has been called more than 20,000 times by more than 1,000 different end users, and has failed to drop a table it creates 70 of these times (a 99.7% successful execution rate), which causes significant problems for the end user, since the next time this procedure is called, the table already exists. There is seemingly no pattern to these failed executions with regard to particular end users, or to which pages from which they were called. However, there is a pattern in the timing. All but 4 of the failed executions occurred clustered around about 10 very specific time stamps (i.e., 5 of the tables that were not dropped were created within a minute of 2:27 pm, 15 of the tables that were not dropped were created within 1 minute of 2:27 pm, etc.). The company that hosts my web site and connected SQL Server database insists that the problem is in my scripting and refuse to look into the issue unless I pay them $120 per hour to do so. It seems to me that, if this were scripting error, it probably would not be succeeding 99.7% of the time, and any failures that did occur would be randomly distributed, not clustered around specific time stamps. It seems to me that this clustering is indicative of slowed or failed SQL Server responses due to server performance issues. I work in statistics and have calculated the odds of this time clustering being random, and, even with the most conservative estimates, it works out to be on in a number I don't even know the name for (with more than 40 zeros). I have included a little information about the stored procedure below, if you think it is relevant. my question to you is: Does this seem likely to be a scripting issue or a server performance issue?
Part of the stored procedure uses the sp_executesql command with a text string to create a table with the unique name of the end user ID (a unique, randomly generated 12 character alphanumeric ID), inserts data into this new table through a loop, then pulls a record set from the table, and drops the table (there is a good reason I need to generate the recordset this way).
Thank you for your help
SQL SearcherWhy can't you use a temp table? That's what they're there for...
"SQL Searcher" <anonymous@.discussions.microsoft.com> wrote in message
news:FB3A473E-7ED7-4E01-A8F9-95F7ABA12313@.microsoft.com...
> I have been having what I believe to be quality of service issues with the
company that hosts my company's web site and connected SQL Server database.
The same stored procedure is called from a number of different web pages
with identical parameter specs, etc. (they were all created from the same
template web page). Over the past three weeks, this stored procedure has
been called more than 20,000 times by more than 1,000 different end users,
and has failed to drop a table it creates 70 of these times (a 99.7%
successful execution rate), which causes significant problems for the end
user, since the next time this procedure is called, the table already
exists. There is seemingly no pattern to these failed executions with
regard to particular end users, or to which pages from which they were
called. However, there is a pattern in the timing. All but 4 of the failed
executions occurred clustered around about 10 very specific time stamps
(i.e., 5 of the tables that were not dropped were created within a minute of
2:27 pm, 15 of the tables that were not dropped were created within 1 minute
of 2:27 pm, etc.). The company that hosts my web site and connected SQL
Server database insists that the problem is in my scripting and refuse to
look into the issue unless I pay them $120 per hour to do so. It seems to
me that, if this were scripting error, it probably would not be succeeding
99.7% of the time, and any failures that did occur would be randomly
distributed, not clustered around specific time stamps. It seems to me that
this clustering is indicative of slowed or failed SQL Server responses due
to server performance issues. I work in statistics and have calculated the
odds of this time clustering being random, and, even with the most
conservative estimates, it works out to be on in a number I don't even know
the name for (with more than 40 zeros). I have included a little information
about the stored procedure below, if you think it is relevant. my question
to you is: Does this seem likely to be a scripting issue or a server
performance issue?
> Part of the stored procedure uses the sp_executesql command with a text
string to create a table with the unique name of the end user ID (a unique,
randomly generated 12 character alphanumeric ID), inserts data into this new
table through a loop, then pulls a record set from the table, and drops the
table (there is a good reason I need to generate the recordset this way).
> Thank you for your help!
> SQL Searcher|||I tried, and it didn't work for some reason.

Quality of Displayed charts is poor

I create some charts in VS and they look crisp.
Then deploy, but when I view in the bouser(IE7) they look jaggered.
What am I doing wrong.
Thanks for any adviceOn Nov 7, 8:37 pm, gavin <ga...@.discussions.microsoft.com> wrote:
> I create some charts in VS and they look crisp.
> Then deploy, but when I view in the bouser(IE7) they look jaggered.
> What am I doing wrong.
> Thanks for any advice
This is just a thought, but you might want to shrink the chart control
in the report and see if maybe that improves the resolution, etc. Hope
this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

Quality Control

Does RS2005 have any quality control mechanisms. Can a report be edited once
its rendered and posted to the report server? For example, my report could
have a paragraph describing some aspect of the report. Could this paragraph
be manually edited?
Thank You - mcOnce the report is published it will continue to be rendered with regards to
the published RDL. However, you can always update the rdl and republish it
on top of the old RDL changing what users see.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"mc" <mc@.discussions.microsoft.com> wrote in message
news:51B0E325-43ED-4BAE-9B77-5A4DA9D311A3@.microsoft.com...
> Does RS2005 have any quality control mechanisms. Can a report be edited
> once
> its rendered and posted to the report server? For example, my report
> could
> have a paragraph describing some aspect of the report. Could this
> paragraph
> be manually edited?
> Thank You - mc|||Hi Daniel, thank you for the response. Could you also answer the following?
What if the user was responsible for editing the report? For example, a
user logs in to review the report and wants to make a change? Can the rdl
be updated while viewing the report or would this require a custom
application to make changes?
This leads to another question. Does "re-publishing" track versions or
would it simply be like running another report?
Thanks - mc
"Daniel Reib [MSFT]" wrote:
> Once the report is published it will continue to be rendered with regards to
> the published RDL. However, you can always update the rdl and republish it
> on top of the old RDL changing what users see.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "mc" <mc@.discussions.microsoft.com> wrote in message
> news:51B0E325-43ED-4BAE-9B77-5A4DA9D311A3@.microsoft.com...
> > Does RS2005 have any quality control mechanisms. Can a report be edited
> > once
> > its rendered and posted to the report server? For example, my report
> > could
> > have a paragraph describing some aspect of the report. Could this
> > paragraph
> > be manually edited?
> >
> > Thank You - mc
>
>|||No the user would not be able to edit the reports while viewing them. If
the user has the correct permission they could download the rdl from Report
Manager and edit the report in Report Designer, but I don't imagine this is
what you want.
Republishing does not track versions. You can create history snapshots of
the report which can be saved and viewed later. You can't trigger them on
publish but can on some other events.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"mc" <mc@.discussions.microsoft.com> wrote in message
news:238696BA-1FFD-4E62-AF5C-91ACF1E9EA6A@.microsoft.com...
> Hi Daniel, thank you for the response. Could you also answer the
> following?
> What if the user was responsible for editing the report? For example, a
> user logs in to review the report and wants to make a change? Can the
> rdl
> be updated while viewing the report or would this require a custom
> application to make changes?
> This leads to another question. Does "re-publishing" track versions or
> would it simply be like running another report?
> Thanks - mc
>
>
> "Daniel Reib [MSFT]" wrote:
>> Once the report is published it will continue to be rendered with regards
>> to
>> the published RDL. However, you can always update the rdl and republish
>> it
>> on top of the old RDL changing what users see.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "mc" <mc@.discussions.microsoft.com> wrote in message
>> news:51B0E325-43ED-4BAE-9B77-5A4DA9D311A3@.microsoft.com...
>> > Does RS2005 have any quality control mechanisms. Can a report be
>> > edited
>> > once
>> > its rendered and posted to the report server? For example, my report
>> > could
>> > have a paragraph describing some aspect of the report. Could this
>> > paragraph
>> > be manually edited?
>> >
>> > Thank You - mc
>>|||No, it would not be feasible for the user to edit the rdl. I would have to
come up with a way to allow the users to make changes or flag the report for
a custom system to allow changes. Any suggestions?
"Daniel Reib [MSFT]" wrote:
> No the user would not be able to edit the reports while viewing them. If
> the user has the correct permission they could download the rdl from Report
> Manager and edit the report in Report Designer, but I don't imagine this is
> what you want.
> Republishing does not track versions. You can create history snapshots of
> the report which can be saved and viewed later. You can't trigger them on
> publish but can on some other events.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "mc" <mc@.discussions.microsoft.com> wrote in message
> news:238696BA-1FFD-4E62-AF5C-91ACF1E9EA6A@.microsoft.com...
> > Hi Daniel, thank you for the response. Could you also answer the
> > following?
> >
> > What if the user was responsible for editing the report? For example, a
> > user logs in to review the report and wants to make a change? Can the
> > rdl
> > be updated while viewing the report or would this require a custom
> > application to make changes?
> >
> > This leads to another question. Does "re-publishing" track versions or
> > would it simply be like running another report?
> >
> > Thanks - mc
> >
> >
> >
> >
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> >> Once the report is published it will continue to be rendered with regards
> >> to
> >> the published RDL. However, you can always update the rdl and republish
> >> it
> >> on top of the old RDL changing what users see.
> >>
> >> --
> >> -Daniel
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "mc" <mc@.discussions.microsoft.com> wrote in message
> >> news:51B0E325-43ED-4BAE-9B77-5A4DA9D311A3@.microsoft.com...
> >> > Does RS2005 have any quality control mechanisms. Can a report be
> >> > edited
> >> > once
> >> > its rendered and posted to the report server? For example, my report
> >> > could
> >> > have a paragraph describing some aspect of the report. Could this
> >> > paragraph
> >> > be manually edited?
> >> >
> >> > Thank You - mc
> >>
> >>
> >>
>
>|||It really depends on how complex the changes are that users can make. If
they are trivial text changes you could write an app using the ReportViewer
control to display the report. You could then have an edit button and build
a simple designer that allows them to change only elements you wish.
If you just want to flag the report then all RS catalog items have a generic
property bag associated with them. You could have the users set some
property to flag that the report needs updating.
I hope that helps.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"mc" <mc@.discussions.microsoft.com> wrote in message
news:4084F46B-8D7A-474F-A68E-08A5CFC7AC1D@.microsoft.com...
> No, it would not be feasible for the user to edit the rdl. I would have
> to
> come up with a way to allow the users to make changes or flag the report
> for
> a custom system to allow changes. Any suggestions?
>
> "Daniel Reib [MSFT]" wrote:
>> No the user would not be able to edit the reports while viewing them. If
>> the user has the correct permission they could download the rdl from
>> Report
>> Manager and edit the report in Report Designer, but I don't imagine this
>> is
>> what you want.
>> Republishing does not track versions. You can create history snapshots
>> of
>> the report which can be saved and viewed later. You can't trigger them
>> on
>> publish but can on some other events.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "mc" <mc@.discussions.microsoft.com> wrote in message
>> news:238696BA-1FFD-4E62-AF5C-91ACF1E9EA6A@.microsoft.com...
>> > Hi Daniel, thank you for the response. Could you also answer the
>> > following?
>> >
>> > What if the user was responsible for editing the report? For example,
>> > a
>> > user logs in to review the report and wants to make a change? Can the
>> > rdl
>> > be updated while viewing the report or would this require a custom
>> > application to make changes?
>> >
>> > This leads to another question. Does "re-publishing" track versions or
>> > would it simply be like running another report?
>> >
>> > Thanks - mc
>> >
>> >
>> >
>> >
>> >
>> > "Daniel Reib [MSFT]" wrote:
>> >
>> >> Once the report is published it will continue to be rendered with
>> >> regards
>> >> to
>> >> the published RDL. However, you can always update the rdl and
>> >> republish
>> >> it
>> >> on top of the old RDL changing what users see.
>> >>
>> >> --
>> >> -Daniel
>> >> This posting is provided "AS IS" with no warranties, and confers no
>> >> rights.
>> >>
>> >>
>> >> "mc" <mc@.discussions.microsoft.com> wrote in message
>> >> news:51B0E325-43ED-4BAE-9B77-5A4DA9D311A3@.microsoft.com...
>> >> > Does RS2005 have any quality control mechanisms. Can a report be
>> >> > edited
>> >> > once
>> >> > its rendered and posted to the report server? For example, my
>> >> > report
>> >> > could
>> >> > have a paragraph describing some aspect of the report. Could this
>> >> > paragraph
>> >> > be manually edited?
>> >> >
>> >> > Thank You - mc
>> >>
>> >>
>> >>
>>|||Yes your explanation helped, Thank You!
On a side note, would you have any input into the following
1) Is it possible to create a report template containing text that would
be evaluated at runtime by a sql query? For example, the text in my
reports need to cater to various languages. Can I configure a textbox to
look up a value when the report is run?
2) How flexible are the graphing capabilities? Can you a third party
package be used to create graphs as long as the rdl file is constructed
properly?
3) Does RS provide a good audit mechanism for logging and tracking reports?
Thanks again - mc
"Daniel Reib [MSFT]" wrote:
> It really depends on how complex the changes are that users can make. If
> they are trivial text changes you could write an app using the ReportViewer
> control to display the report. You could then have an edit button and build
> a simple designer that allows them to change only elements you wish.
> If you just want to flag the report then all RS catalog items have a generic
> property bag associated with them. You could have the users set some
> property to flag that the report needs updating.
> I hope that helps.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "mc" <mc@.discussions.microsoft.com> wrote in message
> news:4084F46B-8D7A-474F-A68E-08A5CFC7AC1D@.microsoft.com...
> > No, it would not be feasible for the user to edit the rdl. I would have
> > to
> > come up with a way to allow the users to make changes or flag the report
> > for
> > a custom system to allow changes. Any suggestions?
> >
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> >> No the user would not be able to edit the reports while viewing them. If
> >> the user has the correct permission they could download the rdl from
> >> Report
> >> Manager and edit the report in Report Designer, but I don't imagine this
> >> is
> >> what you want.
> >>
> >> Republishing does not track versions. You can create history snapshots
> >> of
> >> the report which can be saved and viewed later. You can't trigger them
> >> on
> >> publish but can on some other events.
> >>
> >> --
> >> -Daniel
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "mc" <mc@.discussions.microsoft.com> wrote in message
> >> news:238696BA-1FFD-4E62-AF5C-91ACF1E9EA6A@.microsoft.com...
> >> > Hi Daniel, thank you for the response. Could you also answer the
> >> > following?
> >> >
> >> > What if the user was responsible for editing the report? For example,
> >> > a
> >> > user logs in to review the report and wants to make a change? Can the
> >> > rdl
> >> > be updated while viewing the report or would this require a custom
> >> > application to make changes?
> >> >
> >> > This leads to another question. Does "re-publishing" track versions or
> >> > would it simply be like running another report?
> >> >
> >> > Thanks - mc
> >> >
> >> >
> >> >
> >> >
> >> >
> >> > "Daniel Reib [MSFT]" wrote:
> >> >
> >> >> Once the report is published it will continue to be rendered with
> >> >> regards
> >> >> to
> >> >> the published RDL. However, you can always update the rdl and
> >> >> republish
> >> >> it
> >> >> on top of the old RDL changing what users see.
> >> >>
> >> >> --
> >> >> -Daniel
> >> >> This posting is provided "AS IS" with no warranties, and confers no
> >> >> rights.
> >> >>
> >> >>
> >> >> "mc" <mc@.discussions.microsoft.com> wrote in message
> >> >> news:51B0E325-43ED-4BAE-9B77-5A4DA9D311A3@.microsoft.com...
> >> >> > Does RS2005 have any quality control mechanisms. Can a report be
> >> >> > edited
> >> >> > once
> >> >> > its rendered and posted to the report server? For example, my
> >> >> > report
> >> >> > could
> >> >> > have a paragraph describing some aspect of the report. Could this
> >> >> > paragraph
> >> >> > be manually edited?
> >> >> >
> >> >> > Thank You - mc
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||I can answer the question 3 for you. RS writes every report execution in
the ExecutionLog Table. This table is purged every 30 days. We have
provided some DTS packages for extracting the data to another DB for long
term storage that you would want to take advantage of.
Here is a link describing the process:
http://msdn2.microsoft.com/library/ms159110.aspx
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"mc" <mc@.discussions.microsoft.com> wrote in message
news:C1756736-E8F2-469C-B524-4C934AF8F9CE@.microsoft.com...
> Yes your explanation helped, Thank You!
> On a side note, would you have any input into the following
> 1) Is it possible to create a report template containing text that would
> be evaluated at runtime by a sql query? For example, the text in my
> reports need to cater to various languages. Can I configure a textbox to
> look up a value when the report is run?
> 2) How flexible are the graphing capabilities? Can you a third party
> package be used to create graphs as long as the rdl file is constructed
> properly?
>
> 3) Does RS provide a good audit mechanism for logging and tracking
> reports?
>
> Thanks again - mc
> "Daniel Reib [MSFT]" wrote:
>> It really depends on how complex the changes are that users can make. If
>> they are trivial text changes you could write an app using the
>> ReportViewer
>> control to display the report. You could then have an edit button and
>> build
>> a simple designer that allows them to change only elements you wish.
>> If you just want to flag the report then all RS catalog items have a
>> generic
>> property bag associated with them. You could have the users set some
>> property to flag that the report needs updating.
>> I hope that helps.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "mc" <mc@.discussions.microsoft.com> wrote in message
>> news:4084F46B-8D7A-474F-A68E-08A5CFC7AC1D@.microsoft.com...
>> > No, it would not be feasible for the user to edit the rdl. I would
>> > have
>> > to
>> > come up with a way to allow the users to make changes or flag the
>> > report
>> > for
>> > a custom system to allow changes. Any suggestions?
>> >
>> >
>> > "Daniel Reib [MSFT]" wrote:
>> >
>> >> No the user would not be able to edit the reports while viewing them.
>> >> If
>> >> the user has the correct permission they could download the rdl from
>> >> Report
>> >> Manager and edit the report in Report Designer, but I don't imagine
>> >> this
>> >> is
>> >> what you want.
>> >>
>> >> Republishing does not track versions. You can create history
>> >> snapshots
>> >> of
>> >> the report which can be saved and viewed later. You can't trigger
>> >> them
>> >> on
>> >> publish but can on some other events.
>> >>
>> >> --
>> >> -Daniel
>> >> This posting is provided "AS IS" with no warranties, and confers no
>> >> rights.
>> >>
>> >>
>> >> "mc" <mc@.discussions.microsoft.com> wrote in message
>> >> news:238696BA-1FFD-4E62-AF5C-91ACF1E9EA6A@.microsoft.com...
>> >> > Hi Daniel, thank you for the response. Could you also answer the
>> >> > following?
>> >> >
>> >> > What if the user was responsible for editing the report? For
>> >> > example,
>> >> > a
>> >> > user logs in to review the report and wants to make a change? Can
>> >> > the
>> >> > rdl
>> >> > be updated while viewing the report or would this require a custom
>> >> > application to make changes?
>> >> >
>> >> > This leads to another question. Does "re-publishing" track versions
>> >> > or
>> >> > would it simply be like running another report?
>> >> >
>> >> > Thanks - mc
>> >> >
>> >> >
>> >> >
>> >> >
>> >> >
>> >> > "Daniel Reib [MSFT]" wrote:
>> >> >
>> >> >> Once the report is published it will continue to be rendered with
>> >> >> regards
>> >> >> to
>> >> >> the published RDL. However, you can always update the rdl and
>> >> >> republish
>> >> >> it
>> >> >> on top of the old RDL changing what users see.
>> >> >>
>> >> >> --
>> >> >> -Daniel
>> >> >> This posting is provided "AS IS" with no warranties, and confers no
>> >> >> rights.
>> >> >>
>> >> >>
>> >> >> "mc" <mc@.discussions.microsoft.com> wrote in message
>> >> >> news:51B0E325-43ED-4BAE-9B77-5A4DA9D311A3@.microsoft.com...
>> >> >> > Does RS2005 have any quality control mechanisms. Can a report be
>> >> >> > edited
>> >> >> > once
>> >> >> > its rendered and posted to the report server? For example, my
>> >> >> > report
>> >> >> > could
>> >> >> > have a paragraph describing some aspect of the report. Could
>> >> >> > this
>> >> >> > paragraph
>> >> >> > be manually edited?
>> >> >> >
>> >> >> > Thank You - mc
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>|||Thanks again for your help!!
"Daniel Reib [MSFT]" wrote:
> I can answer the question 3 for you. RS writes every report execution in
> the ExecutionLog Table. This table is purged every 30 days. We have
> provided some DTS packages for extracting the data to another DB for long
> term storage that you would want to take advantage of.
> Here is a link describing the process:
> http://msdn2.microsoft.com/library/ms159110.aspx
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "mc" <mc@.discussions.microsoft.com> wrote in message
> news:C1756736-E8F2-469C-B524-4C934AF8F9CE@.microsoft.com...
> > Yes your explanation helped, Thank You!
> >
> > On a side note, would you have any input into the following
> >
> > 1) Is it possible to create a report template containing text that would
> > be evaluated at runtime by a sql query? For example, the text in my
> > reports need to cater to various languages. Can I configure a textbox to
> > look up a value when the report is run?
> >
> > 2) How flexible are the graphing capabilities? Can you a third party
> > package be used to create graphs as long as the rdl file is constructed
> > properly?
> >
> >
> > 3) Does RS provide a good audit mechanism for logging and tracking
> > reports?
> >
> >
> > Thanks again - mc
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> >> It really depends on how complex the changes are that users can make. If
> >> they are trivial text changes you could write an app using the
> >> ReportViewer
> >> control to display the report. You could then have an edit button and
> >> build
> >> a simple designer that allows them to change only elements you wish.
> >>
> >> If you just want to flag the report then all RS catalog items have a
> >> generic
> >> property bag associated with them. You could have the users set some
> >> property to flag that the report needs updating.
> >>
> >> I hope that helps.
> >>
> >> --
> >> -Daniel
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "mc" <mc@.discussions.microsoft.com> wrote in message
> >> news:4084F46B-8D7A-474F-A68E-08A5CFC7AC1D@.microsoft.com...
> >> > No, it would not be feasible for the user to edit the rdl. I would
> >> > have
> >> > to
> >> > come up with a way to allow the users to make changes or flag the
> >> > report
> >> > for
> >> > a custom system to allow changes. Any suggestions?
> >> >
> >> >
> >> > "Daniel Reib [MSFT]" wrote:
> >> >
> >> >> No the user would not be able to edit the reports while viewing them.
> >> >> If
> >> >> the user has the correct permission they could download the rdl from
> >> >> Report
> >> >> Manager and edit the report in Report Designer, but I don't imagine
> >> >> this
> >> >> is
> >> >> what you want.
> >> >>
> >> >> Republishing does not track versions. You can create history
> >> >> snapshots
> >> >> of
> >> >> the report which can be saved and viewed later. You can't trigger
> >> >> them
> >> >> on
> >> >> publish but can on some other events.
> >> >>
> >> >> --
> >> >> -Daniel
> >> >> This posting is provided "AS IS" with no warranties, and confers no
> >> >> rights.
> >> >>
> >> >>
> >> >> "mc" <mc@.discussions.microsoft.com> wrote in message
> >> >> news:238696BA-1FFD-4E62-AF5C-91ACF1E9EA6A@.microsoft.com...
> >> >> > Hi Daniel, thank you for the response. Could you also answer the
> >> >> > following?
> >> >> >
> >> >> > What if the user was responsible for editing the report? For
> >> >> > example,
> >> >> > a
> >> >> > user logs in to review the report and wants to make a change? Can
> >> >> > the
> >> >> > rdl
> >> >> > be updated while viewing the report or would this require a custom
> >> >> > application to make changes?
> >> >> >
> >> >> > This leads to another question. Does "re-publishing" track versions
> >> >> > or
> >> >> > would it simply be like running another report?
> >> >> >
> >> >> > Thanks - mc
> >> >> >
> >> >> >
> >> >> >
> >> >> >
> >> >> >
> >> >> > "Daniel Reib [MSFT]" wrote:
> >> >> >
> >> >> >> Once the report is published it will continue to be rendered with
> >> >> >> regards
> >> >> >> to
> >> >> >> the published RDL. However, you can always update the rdl and
> >> >> >> republish
> >> >> >> it
> >> >> >> on top of the old RDL changing what users see.
> >> >> >>
> >> >> >> --
> >> >> >> -Daniel
> >> >> >> This posting is provided "AS IS" with no warranties, and confers no
> >> >> >> rights.
> >> >> >>
> >> >> >>
> >> >> >> "mc" <mc@.discussions.microsoft.com> wrote in message
> >> >> >> news:51B0E325-43ED-4BAE-9B77-5A4DA9D311A3@.microsoft.com...
> >> >> >> > Does RS2005 have any quality control mechanisms. Can a report be
> >> >> >> > edited
> >> >> >> > once
> >> >> >> > its rendered and posted to the report server? For example, my
> >> >> >> > report
> >> >> >> > could
> >> >> >> > have a paragraph describing some aspect of the report. Could
> >> >> >> > this
> >> >> >> > paragraph
> >> >> >> > be manually edited?
> >> >> >> >
> >> >> >> > Thank You - mc
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>