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
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>