Report parameter metadata not updated during deployment

In 2005, I've experienced a problem when re-deploying reports to the report server. The parameter references don't get updated properly and I would either need to re-deploy several times, or delete the reports and deploy a fresh copy. The latter re-creates the report GUIDs and messes up usage statistics. I've not been able to reproduce this consistently but have aexperienced it on several projects.

Is this issue being adressed in RS 2008?

I've run into this one as well.

I think this also occurred in SSRS 2000 as well.

|||The behavior around parameter metadata has not changed in Katmai. If you have a specific scenario where things get messed up, post a bug over on the connect site and we will take a look.|||

This is raised and explained in this post http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=100960&SiteID=1

I can't envisage parameter defaults and prompts being maintaned by an administrator. Does an override mechanism exist in RS 2005? If not, then will it be added in 2008?

Report parameter metadata not updated during deployment

In 2005, I've experienced a problem when re-deploying reports to the report server. The parameter references don't get updated properly and I would either need to re-deploy several times, or delete the reports and deploy a fresh copy. The latter re-creates the report GUIDs and messes up usage statistics. I've not been able to reproduce this consistently but have aexperienced it on several projects.

Is this issue being adressed in RS 2008?

I've run into this one as well.

I think this also occurred in SSRS 2000 as well.

|||The behavior around parameter metadata has not changed in Katmai. If you have a specific scenario where things get messed up, post a bug over on the connect site and we will take a look.|||

This is raised and explained in this post http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=100960&SiteID=1

I can't envisage parameter defaults and prompts being maintaned by an administrator. Does an override mechanism exist in RS 2005? If not, then will it be added in 2008?

Report Parameter Display Problem

Hi,
I am developing several reports, I want to pass one parameter from
Report1 to Report2 and also make the same parameter selectable on
Report2. However I figured out that if I pass the parameter from
Report1 to Report2 and Report2 has the same report parameter, then the
parameter bar on the top of Report2 is not displayed. Moreover if I
click the Report2 on the report folder then the Report2 parameter bar
is displayed. How can I force Reporting Services to display the
parameter bar on the Report2?
Configuration:
Win2003 Standard Edition (Latest SP)
SQLServer 2000 (SP2)
SQLReporting Services (SP2)
Visual Studio 2003 (SP1) .Net 1.1
Alp Eren YILMAZAddition Information:
In visual studio Preview page, I can see the parameter on the parameter
bar while navigating from Report1 to Report2 but when I deploy the
reports, I could not see the parameter bar on the second report.
Alp Eren YILMAZ|||I believe there is a toggle on the right side of where the parameter
bar normally is that will display it after you jump to a report.
If you do a jump to url the parameter bar is always displayed.|||Hi Jon,
Yes actually I tried to jumping via URL and the parameters are
displayed but it's a bit hard to maintain the flow of reports because
you have to key the full URL everytime with the report names. Is there
any work around on that issue?
MS People, I found that the issue is resolved in RS2005, is there any
patch for RS2000 for that problem?
Thanks and Regards,
Jon Fife wrote:
> I believe there is a toggle on the right side of where the parameter
> bar normally is that will display it after you jump to a report.
> If you do a jump to url the parameter bar is always displayed.sql

Report Parameter Defaults not being used in deployed reports

When I set the default properties under Report Parameters in some
reports, it works perfectly, in other reports, the parameters specified
in Visual Studio under Report Parameters seem to have no effect when
the report is deployed to the ReportServer. The toolbar for the
parameters displays, and that is OK, but the default values don't
appear in the toolbar like they do in the other reports, and the report
doesn't run until the parameters are selected with the dropdowns. What
is causing the parameters to behave differently from one report to the
other?I have found that although you may change 'defaults' in the Report Designer,
they sometimes do not seem to take when I 'deploy' the modified report. I
don't understand why, bu my solution thus far has been to delete the report
off the report server and then redeploy it. The new/modified default values
appear.
"Kelly Gross" wrote:
> When I set the default properties under Report Parameters in some
> reports, it works perfectly, in other reports, the parameters specified
> in Visual Studio under Report Parameters seem to have no effect when
> the report is deployed to the ReportServer. The toolbar for the
> parameters displays, and that is OK, but the default values don't
> appear in the toolbar like they do in the other reports, and the report
> doesn't run until the parameters are selected with the dropdowns. What
> is causing the parameters to behave differently from one report to the
> other?
>|||Make sure your default value is your available value, otherwise it is
not working.
Kelly Gross wrote:
> When I set the default properties under Report Parameters in some
> reports, it works perfectly, in other reports, the parameters
specified
> in Visual Studio under Report Parameters seem to have no effect when
> the report is deployed to the ReportServer. The toolbar for the
> parameters displays, and that is OK, but the default values don't
> appear in the toolbar like they do in the other reports, and the
report
> doesn't run until the parameters are selected with the dropdowns.
What
> is causing the parameters to behave differently from one report to
the
> other?

Report parameter - date format

I have developed few reports using reporting services (service pack 2), but
still facing some problem in the date parameter and would look for help /
share here. Thanks advance!
1) How RS treat the date format?
YYYY-MM-DD (the data is correct when i use this format)
DD/MM/YYYY
MM/DD/YYYY
What is the purpose to define the date parameter as "MM/DD/YYYY" from the
"Expression" windows?
Any way to limit the input date format or any method to convert the format
to YYYY-MM-DD if user really input the format as DD/MM/YYYY or MM/DD/YYYY?
2) Anyone know how to use date time picker in RS, or possible to use it? I
believe if RS could use the date time picker, I don't need to worry the
parameter formatHi,
have a look at this article:
http://www.databasejournal.com/features/mssql/article.php/2197931
You'll find the way to solve your problem (I had the same problem and by
converting the date with the CONVERT function in my SQL query I managed to
solve it).
If you have some time could you take a look at my post (just after yours),
maybe you have the solution.
Thanks,
--
JB
"Franklin" wrote:
> I have developed few reports using reporting services (service pack 2), but
> still facing some problem in the date parameter and would look for help /
> share here. Thanks advance!
> 1) How RS treat the date format?
> YYYY-MM-DD (the data is correct when i use this format)
> DD/MM/YYYY
> MM/DD/YYYY
> What is the purpose to define the date parameter as "MM/DD/YYYY" from the
> "Expression" windows?
> Any way to limit the input date format or any method to convert the format
> to YYYY-MM-DD if user really input the format as DD/MM/YYYY or MM/DD/YYYY?
> 2) Anyone know how to use date time picker in RS, or possible to use it? I
> believe if RS could use the date time picker, I don't need to worry the
> parameter format
>sql

Report Paging

We are converting from Crystal Reports to Reporting Services. We are
encountering what appears to be an issue with the Report Viewer. If Table
rows in the body of the report are conditionally made Hidden (depending on
parameter input), the number of pages differs between the viewer and the
printed (either printer or pdf). In fact, some reports show a single page in
the viewer, but many pages when printed or exported to pdf. If the Table rows
are always visible, the pagination is consistent between viewer and printing.
Is there any way to work around this?Hello HK,
I would like to know the following things:
1. What's the SQL server version did you use? 2000 or 2005?
2. Since this issue only occured for the conditional Hidden, it is a known
issue in SQL 2005. And the product team is researching this issue. If I get
any update, I will let you know.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Thank you for your response.
We are using sql server 2005 sp2, visual studio 2005.
It appears to be occuring only with the conditional Hidden. If I remove the
conditional Hidden, we appear to get correct pagination. I (and our many
report users) would greatly appreciate any solution to this.
"Wei Lu [MSFT]" wrote:
> Hello HK,
> I would like to know the following things:
> 1. What's the SQL server version did you use? 2000 or 2005?
> 2. Since this issue only occured for the conditional Hidden, it is a known
> issue in SQL 2005. And the product team is researching this issue. If I get
> any update, I will let you know.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hello HK,
Product Team confirmed this is a known issue and will be addressed in the
next version of Reporting Services.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||I'm glad to hear that - thanks for your response.
"Wei Lu [MSFT]" wrote:
> Hello HK,
> Product Team confirmed this is a known issue and will be addressed in the
> next version of Reporting Services.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>

Report pagination for charts

Hi,

We have developed few reports displaying data using chart layout. In the Data tab, we have specified MDX query that will return top 10 records.

But now, instead of restricting to just top 10 records, we would like to display all records and go in for pagination.

Is there some setting in the chart properties, where in I can display the first n records in first page, and the next n records( if available) in the next page and so on?

Can I specify the value of n somewhere in the propeties?

I read through many posts regarding pagination but those couldn't help me much.

Please help me in solving this problem.

Any help would be appreciated.

Thanks in advance!

No response yet!:(|||

One approach is the following:

Step 1: Add a table to the report
Step 2: Group by a number of rows
Right-click on the table and select Properties. Add a table group (with a group header, but no group footer)
Enter this for the group expression: =Ceiling(RowNumber(Nothing)/10)
This will cause the table to group on every ten rows. So you'll get a separate table group for every ten rows.
Step 3: Add a chart in the table group header
Design your chart.

Note: this approach is similar to the table inline charts approach discussed in the following whitepaper: http://msdn2.microsoft.com/en-us/library/aa964128.aspx

-- Robert

|||

Thanks a lot Robert!

I got the idea from the solution provided by you and did the following:

Step 1: Add a list to the report

Step 2: Added group expression for the list to group the data

Grouping =Ceiling(RowNumber(Nothing)/10)

Set the following properties for list:

KeepTogether: False

PageBreakAtEnd: True

Step 3: Added chart to the list

Set the property, PageBreakAtEnd: True for the chart.

The above steps solved my problem of report pagination for charts.

Thanks once again!

sql

Report pagination for charts

Hi,

We have developed few reports displaying data using chart layout. In the Data tab, we have specified MDX query that will return top 10 records.

But now, instead of restricting to just top 10 records, we would like to display all records and go in for pagination.

Is there some setting in the chart properties, where in I can display the first n records in first page, and the next n records( if available) in the next page and so on?

Can I specify the value of n somewhere in the propeties?

I read through many posts regarding pagination but those couldn't help me much.

Please help me in solving this problem.

Any help would be appreciated.

Thanks in advance!

No response yet!:(|||

One approach is the following:

Step 1: Add a table to the report
Step 2: Group by a number of rows
Right-click on the table and select Properties. Add a table group (with a group header, but no group footer)
Enter this for the group expression: =Ceiling(RowNumber(Nothing)/10)
This will cause the table to group on every ten rows. So you'll get a separate table group for every ten rows.
Step 3: Add a chart in the table group header
Design your chart.

Note: this approach is similar to the table inline charts approach discussed in the following whitepaper: http://msdn2.microsoft.com/en-us/library/aa964128.aspx

-- Robert

|||

Thanks a lot Robert!

I got the idea from the solution provided by you and did the following:

Step 1: Add a list to the report

Step 2: Added group expression for the list to group the data

Grouping =Ceiling(RowNumber(Nothing)/10)

Set the following properties for list:

KeepTogether: False

PageBreakAtEnd: True

Step 3: Added chart to the list

Set the property, PageBreakAtEnd: True for the chart.

The above steps solved my problem of report pagination for charts.

Thanks once again!

Report package

Hi all,
I simply wish to a number of report 'packages'. These packages contain a
number of reports as sub reports. This all works great but I wish to place
the source reports in a sub folder of the main package folder to make things
a little easier for the user. I get an error as the source report cannot be
found.
Can anyone help with this? Are linked reports suitable for this purpose?
TIA
Peter Hailsstarboss wrote:
> Hi all,
> I simply wish to a number of report 'packages'. These packages
> contain a number of reports as sub reports. This all works great but
> I wish to place the source reports in a sub folder of the main
> package folder to make things a little easier for the user. I get an
> error as the source report cannot be found.
> Can anyone help with this? Are linked reports suitable for this
> purpose?
> TIA
> Peter Hails
Yes Linked reports are good for this. Think of Linked reports as
Shortcuts to the original. Two benefits of linked reports rather than
copies are; 1) If you update the original report, the links reflect
this and 2) you can save a different set of parameters and properties
against the linked report.
As an example: We have offices in the UK, USA and Germany. I deploy a
report to a master folder which has an "office" parameter. I create
linked reports in a UK folder, USA folder etc. and on each link I set
the "office" parameter to default to the relevant office. This is a
nice way of personalising reports. Also if I change the master report,
I don't need to worry about the linked reports because they will always
run the new version, but their personalised settings will remain the
same.
Regards
Chris|||Chris McGuigan wrote:
> starboss wrote:
> > Hi all,
> >
> > I simply wish to a number of report 'packages'. These packages
> > contain a number of reports as sub reports. This all works great
> > but I wish to place the source reports in a sub folder of the main
> > package folder to make things a little easier for the user. I get
> > an error as the source report cannot be found.
> >
> > Can anyone help with this? Are linked reports suitable for this
> > purpose?
> >
> > TIA
> >
> > Peter Hails
> Yes Linked reports are good for this. Think of Linked reports as
> Shortcuts to the original. Two benefits of linked reports rather than
> copies are; 1) If you update the original report, the links reflect
> this and 2) you can save a different set of parameters and properties
> against the linked report.
> As an example: We have offices in the UK, USA and Germany. I deploy a
> report to a master folder which has an "office" parameter. I create
> linked reports in a UK folder, USA folder etc. and on each link I set
> the "office" parameter to default to the relevant office. This is a
> nice way of personalising reports. Also if I change the master report,
> I don't need to worry about the linked reports because they will
> always run the new version, but their personalised settings will
> remain the same.
> Regards
> Chris
Further to this; you should still keep the sub-reports in the same
folder as the main report to make the links in the main report work -
but hide them if you want to portray a hierarchical organisational view
in Report Manager. It's a bit "smoke and mirrors" but it works!
Chris

Report ownership

I have 2 reports that run against a Oracle database. They run fine on my
development PC. Had huge problems getting them to run on the Reports Manager
scheduled. We finally got one working, after days of beating on it, it was
uploaded by the senior DBA (so owned by his userid also), the connection file
was also uploaded by the senior DBA, this report runs fine. The other,
report gets an error saying:
An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
Cannot create a connection to data source 'cdbprod'.
(rsErrorOpeningConnection) Get Online Help
Error while trying to retrieve text for error ORA-12154
--
www.duanelawrence.comThe ReportServer Windows service is responsible for executing scheduled
reports. It will be doing this under the specified service user account
(which is typically a low-privileged user account). You may run into file
permission issues related to tnsnames.ora or other Oracle client dlls.
Please verify based on KB 870668 that the service account has sufficient
permissions:
http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B870668
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"duanelawrence.com" <duanelawrencecom@.discussions.microsoft.com> wrote in
message news:9DA7837D-D8D8-4300-A32E-8AEA0127ACA7@.microsoft.com...
> I have 2 reports that run against a Oracle database. They run fine on my
> development PC. Had huge problems getting them to run on the Reports
Manager
> scheduled. We finally got one working, after days of beating on it, it
was
> uploaded by the senior DBA (so owned by his userid also), the connection
file
> was also uploaded by the senior DBA, this report runs fine. The other,
> report gets an error saying:
> An error has occurred during report processing. (rsProcessingAborted) Get
> Online Help
> Cannot create a connection to data source 'cdbprod'.
> (rsErrorOpeningConnection) Get Online Help
> Error while trying to retrieve text for error ORA-12154
> --
> www.duanelawrence.com
>|||Thanks Robert
I wish to add some information that I did not say in the first post. We are
using a
"shared data source" with "Credentials stored securely in the report server
" set to on. You see, we are scheduling the reports to run in the Reports
Manager (you can not create a schedule until you use "Credentials stored
securely in the report server " option). When you look at the Reports
Manager in a web browser and click on "Show Details", you will see a
"Modified By" column. The user id in the modified by column has to have read
and execute privileges to the 2 named directories in the article.
I have read many articles saying exactly what you say below, but I have
proof that it is not true. I added my user id to the 2 directories named in
the article you listed and the reports work fine. The user id in the "shared
data source" under "Credentials stored securely in the report server " only
has the privileges created by the Oracle DBA, no network privaleges at all.
Duane
"Robert Bruckner [MSFT]" wrote:
> The ReportServer Windows service is responsible for executing scheduled
> reports. It will be doing this under the specified service user account
> (which is typically a low-privileged user account). You may run into file
> permission issues related to tnsnames.ora or other Oracle client dlls.
> Please verify based on KB 870668 that the service account has sufficient
> permissions:
> http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B870668
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "duanelawrence.com" <duanelawrencecom@.discussions.microsoft.com> wrote in
> message news:9DA7837D-D8D8-4300-A32E-8AEA0127ACA7@.microsoft.com...
> > I have 2 reports that run against a Oracle database. They run fine on my
> > development PC. Had huge problems getting them to run on the Reports
> Manager
> > scheduled. We finally got one working, after days of beating on it, it
> was
> > uploaded by the senior DBA (so owned by his userid also), the connection
> file
> > was also uploaded by the senior DBA, this report runs fine. The other,
> > report gets an error saying:
> >
> > An error has occurred during report processing. (rsProcessingAborted) Get
> > Online Help
> > Cannot create a connection to data source 'cdbprod'.
> > (rsErrorOpeningConnection) Get Online Help
> > Error while trying to retrieve text for error ORA-12154
> >
> > --
> >
> > www.duanelawrence.com
> >
> >
>
>|||More supporting evidence
http://www.sqlmonster.com/Uwe/ForumPost.aspx?article=sql-server-reporting:6675:77E633A0-1B40-4766-936D-73B640F3DBF8%40microsoft.com
I consider this closed.
Duane
"duanelawrence.com" wrote:
> Thanks Robert
> I wish to add some information that I did not say in the first post. We are
> using a
> "shared data source" with "Credentials stored securely in the report server
> " set to on. You see, we are scheduling the reports to run in the Reports
> Manager (you can not create a schedule until you use "Credentials stored
> securely in the report server " option). When you look at the Reports
> Manager in a web browser and click on "Show Details", you will see a
> "Modified By" column. The user id in the modified by column has to have read
> and execute privileges to the 2 named directories in the article.
> I have read many articles saying exactly what you say below, but I have
> proof that it is not true. I added my user id to the 2 directories named in
> the article you listed and the reports work fine. The user id in the "shared
> data source" under "Credentials stored securely in the report server " only
> has the privileges created by the Oracle DBA, no network privaleges at all.
> Duane
>
>
> "Robert Bruckner [MSFT]" wrote:
> > The ReportServer Windows service is responsible for executing scheduled
> > reports. It will be doing this under the specified service user account
> > (which is typically a low-privileged user account). You may run into file
> > permission issues related to tnsnames.ora or other Oracle client dlls.
> > Please verify based on KB 870668 that the service account has sufficient
> > permissions:
> > http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B870668
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> >
> > "duanelawrence.com" <duanelawrencecom@.discussions.microsoft.com> wrote in
> > message news:9DA7837D-D8D8-4300-A32E-8AEA0127ACA7@.microsoft.com...
> > > I have 2 reports that run against a Oracle database. They run fine on my
> > > development PC. Had huge problems getting them to run on the Reports
> > Manager
> > > scheduled. We finally got one working, after days of beating on it, it
> > was
> > > uploaded by the senior DBA (so owned by his userid also), the connection
> > file
> > > was also uploaded by the senior DBA, this report runs fine. The other,
> > > report gets an error saying:
> > >
> > > An error has occurred during report processing. (rsProcessingAborted) Get
> > > Online Help
> > > Cannot create a connection to data source 'cdbprod'.
> > > (rsErrorOpeningConnection) Get Online Help
> > > Error while trying to retrieve text for error ORA-12154
> > >
> > > --
> > >
> > > www.duanelawrence.com
> > >
> > >
> >
> >
> >|||I'm not sure I understand your last posting. Does it work now for the shared
data source in your case?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"duanelawrence.com" <duanelawrencecom@.discussions.microsoft.com> wrote in
message news:5AEAE806-5968-4D04-A55C-8F5C55C432E5@.microsoft.com...
> More supporting evidence
>
http://www.sqlmonster.com/Uwe/ForumPost.aspx?article=sql-server-reporting:6675:77E633A0-1B40-4766-936D-73B640F3DBF8%40microsoft.com
> I consider this closed.
> Duane
>
>
> "duanelawrence.com" wrote:
> > Thanks Robert
> >
> > I wish to add some information that I did not say in the first post. We
are
> > using a
> > "shared data source" with "Credentials stored securely in the report
server
> > " set to on. You see, we are scheduling the reports to run in the
Reports
> > Manager (you can not create a schedule until you use "Credentials stored
> > securely in the report server " option). When you look at the Reports
> > Manager in a web browser and click on "Show Details", you will see a
> > "Modified By" column. The user id in the modified by column has to have
read
> > and execute privileges to the 2 named directories in the article.
> >
> > I have read many articles saying exactly what you say below, but I have
> > proof that it is not true. I added my user id to the 2 directories
named in
> > the article you listed and the reports work fine. The user id in the
"shared
> > data source" under "Credentials stored securely in the report server "
only
> > has the privileges created by the Oracle DBA, no network privaleges at
all.
> >
> > Duane
> >
> >
> >
> >
> > "Robert Bruckner [MSFT]" wrote:
> >
> > > The ReportServer Windows service is responsible for executing
scheduled
> > > reports. It will be doing this under the specified service user
account
> > > (which is typically a low-privileged user account). You may run into
file
> > > permission issues related to tnsnames.ora or other Oracle client dlls.
> > > Please verify based on KB 870668 that the service account has
sufficient
> > > permissions:
> > > http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B870668
> > >
> > > --
> > > This posting is provided "AS IS" with no warranties, and confers no
rights.
> > >
> > >
> > > "duanelawrence.com" <duanelawrencecom@.discussions.microsoft.com> wrote
in
> > > message news:9DA7837D-D8D8-4300-A32E-8AEA0127ACA7@.microsoft.com...
> > > > I have 2 reports that run against a Oracle database. They run fine
on my
> > > > development PC. Had huge problems getting them to run on the
Reports
> > > Manager
> > > > scheduled. We finally got one working, after days of beating on it,
it
> > > was
> > > > uploaded by the senior DBA (so owned by his userid also), the
connection
> > > file
> > > > was also uploaded by the senior DBA, this report runs fine. The
other,
> > > > report gets an error saying:
> > > >
> > > > An error has occurred during report processing.
(rsProcessingAborted) Get
> > > > Online Help
> > > > Cannot create a connection to data source 'cdbprod'.
> > > > (rsErrorOpeningConnection) Get Online Help
> > > > Error while trying to retrieve text for error ORA-12154
> > > >
> > > > --
> > > >
> > > > www.duanelawrence.com
> > > >
> > > >
> > >
> > >
> > >

Report on a Sharepoint table in SRS

I'm not sure this is possible, but... I was asked to write a SQL Reporting Services Report that reports on a SQL table that is joined to a Sharepoint Table. In trying to look up how to do this, I'm not finding any how-to posts. Is this possible and if so, could you point me in the direction of a step-by-step how -to white paper?

Thanks,

Jennifer

WSS exposes its feature set as a web service. I think the one that returns the data in a list is called Lists.asmx. From there, you can use the XML data provider in SSRS 2005 to connect to the service and consume the data in XML. This post should help you to get started with the SSRS XML data provider. If you need to create a report that joins data from two lists on the report, you could try a third-party provider such as Enesys or build your own custom data extension.

As a side note, a native provider that reports from WSS is on top of the wish list for a next release as discussed in Brian Welcker's blog.

Report on a Sharepoint table in SRS

I'm not sure this is possible, but... I was asked to write a SQL Reporting Services Report that reports on a SQL table that is joined to a Sharepoint Table. In trying to look up how to do this, I'm not finding any how-to posts. Is this possible and if so, could you point me in the direction of a step-by-step how -to white paper?

Thanks,

Jennifer

WSS exposes its feature set as a web service. I think the one that returns the data in a list is called Lists.asmx. From there, you can use the XML data provider in SSRS 2005 to connect to the service and consume the data in XML. This post should help you to get started with the SSRS XML data provider. If you need to create a report that joins data from two lists on the report, you could try a third-party provider such as Enesys or build your own custom data extension.

As a side note, a native provider that reports from WSS is on top of the wish list for a next release as discussed in Brian Welcker's blog.

sql

Report of Reports

Are there any example of SSRS reports using an rdl file as the source for the report. I.e. a Report of Reports?

Hi Freddie,

could you please elaborate a bit more?

thanks, 99

|||

One way of doing this in RS 2005 is to render a report with the xml data rendering extension as xml document. This is then used as input for the xml data extension. However, getting the query setup correctly and working is a bit tricky. A specific sample and explanation for this approach will be available in an upcoming MSDN article about the RS 2005 Xml data extension later this summer.

-- Robert

|||

Thanks Robert,

I did find an article "Integrate XML into Your Reporting Environment" by Bill Wolff at http://www.ftponline.com/special/sqlserver/bwolff/

I will be looking for the upcoming MSDN Article.

To elaborate more on my question...I would like to document my reporting service reports using reporting services. For example which property has custom code (e.g. IIF).

Report of Reports

Are there any example of SSRS reports using an rdl file as the source for the report. I.e. a Report of Reports?

Hi Freddie,

could you please elaborate a bit more?

thanks, 99

|||

One way of doing this in RS 2005 is to render a report with the xml data rendering extension as xml document. This is then used as input for the xml data extension. However, getting the query setup correctly and working is a bit tricky. A specific sample and explanation for this approach will be available in an upcoming MSDN article about the RS 2005 Xml data extension later this summer.

-- Robert

|||

Thanks Robert,

I did find an article "Integrate XML into Your Reporting Environment" by Bill Wolff at http://www.ftponline.com/special/sqlserver/bwolff/

I will be looking for the upcoming MSDN Article.

To elaborate more on my question...I would like to document my reporting service reports using reporting services. For example which property has custom code (e.g. IIF).

Report of Reports

I have a report listing all my available reports.
On that report I would like to click on a line and automatically
drillthrough/navigate to a particular report for that line.
Is that possible? It looks like the navigate tab can only take a static
reference to a single report.so build a standard report that queries against the SQL Database Named
'Catalog'
-Aaron
Jim Breffni wrote:
> I have a report listing all my available reports.
> On that report I would like to click on a line and automatically
> drillthrough/navigate to a particular report for that line.
> Is that possible? It looks like the navigate tab can only take a static
> reference to a single report.|||It is possible to drillthrough different reports. Your 2nd and the 3rd
sentence are contradictary. correct me if I have understood wrongly..
ie. you said
in 2nd
I would like to click on a line and automatically
drillthrough/navigate to a particular report for that line
in 3rd
Is that possible? It looks like the navigate tab can only take a
static
reference to a single report.
Amarnath
"Jim Breffni" wrote:
> I have a report listing all my available reports.
> On that report I would like to click on a line and automatically
> drillthrough/navigate to a particular report for that line.
> Is that possible? It looks like the navigate tab can only take a static
> reference to a single report.sql

Report of my reports

I would like to create a report in Reporting Services that lists the reports
in my SRS, including their descriptions, specified by the folders they reside
in, by pulling the data directly from the SRS? Is this possible? The data's
there. How can I get to it dynamically? Thanks.Its easy using the API:
http://odetocode.com/Articles/95.aspx
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"David" <David@.discussions.microsoft.com> schrieb im Newsbeitrag
news:C6C91A2C-A270-4C18-980C-607923E180D0@.microsoft.com...
>I would like to create a report in Reporting Services that lists the
>reports
> in my SRS, including their descriptions, specified by the folders they
> reside
> in, by pulling the data directly from the SRS? Is this possible? The
> data's
> there. How can I get to it dynamically? Thanks.|||I think you could also query the ReportServer tables directly in a strored
proc then use that as the datasource for the "report of reports"
"David" wrote:
> I would like to create a report in Reporting Services that lists the reports
> in my SRS, including their descriptions, specified by the folders they reside
> in, by pulling the data directly from the SRS? Is this possible? The data's
> there. How can I get to it dynamically? Thanks.

Report of Job Activities

I need a report of all job monitoring activities. How can you run a report
out of SQL 2005 which list the reports by day, date and time
--
WPJLYou may want to be more specific on exactly what you'd like to accomplish.
Perhaps, an example would help.
Linchi
"WPJL" wrote:
> I need a report of all job monitoring activities. How can you run a report
> out of SQL 2005 which list the reports by day, date and time
> --
> WPJL|||WPJL
As Linchi said , to help you we need an exmaple
http://dimantdatabasesolutions.blogspot.com/2008/03/sql-server-agent-jobs-duration-report.html
"WPJL" <WPJL@.discussions.microsoft.com> wrote in message
news:CFA4269C-267E-4CE4-A53A-085FC22621B6@.microsoft.com...
>I need a report of all job monitoring activities. How can you run a report
> out of SQL 2005 which list the reports by day, date and time
> --
> WPJL|||I asked to create an analysis report of all jobs which run via SQL Service
Job Activity. The data that is needed is the day, date and time intervals
which each job runs. The requestors want a side by side analysis to view
specific jobs that run on the same day and time. We currently have
approximately 72 jobs which run via SQL server. To get the information into
a spread sheet, I had to open the job history and properties and manually
enter this information in an excel spreadsheet. This is very time consuming.
Examples of jobs â' Job A run everyday M-F at 6:00 a.m., Job B run M-F at
6:00 a.m., Job C may run everyday starting 12:00 a.m, until 12:00 midnight.
However, the job runs M_F, at time intervals of every 10 minutes. It starts
at 12:00, 12:10, 12:20 and so on.
I wanted to know if there was a way to query the Job Activity data out of
SQL query where I could create an analysis report which would show a
comparison of the days, dates and interval times that each report runs.
Thanks.
--
WPJL
"Linchi Shea" wrote:
> You may want to be more specific on exactly what you'd like to accomplish.
> Perhaps, an example would help.
> Linchi
> "WPJL" wrote:
> > I need a report of all job monitoring activities. How can you run a report
> > out of SQL 2005 which list the reports by day, date and time
> > --
> > WPJL

report not showing information in rows

Hello,
I have several reports that work fine other then when the values for a
column is the same as the one below it the the value dose not show up? Is
this something I can turn off?
For example I have a column that might have several rows of 0 but only one 0
will there and then blank rows till the next value.Hi John,
It sounds like the rows have the property "Hide Duplicates" assigned to the
column or field that is repeating the value. You can toggle this attribute
in the property dialogue of the field in question.
Rodney Landrum
Author - Pro SQL Reporting Services (Apress)
"John" <John@.discussions.microsoft.com> wrote in message
news:9C51915F-4DA6-4C3F-8106-7ECB8E89C98D@.microsoft.com...
> Hello,
> I have several reports that work fine other then when the values for a
> column is the same as the one below it the the value dose not show up? Is
> this something I can turn off?
> For example I have a column that might have several rows of 0 but only one
> 0
> will there and then blank rows till the next value.
>|||I create the report in code but that sound like it is my problem thanks
"Rodney" wrote:
> Hi John,
> It sounds like the rows have the property "Hide Duplicates" assigned to the
> column or field that is repeating the value. You can toggle this attribute
> in the property dialogue of the field in question.
> Rodney Landrum
> Author - Pro SQL Reporting Services (Apress)
>
> "John" <John@.discussions.microsoft.com> wrote in message
> news:9C51915F-4DA6-4C3F-8106-7ECB8E89C98D@.microsoft.com...
> > Hello,
> > I have several reports that work fine other then when the values for a
> > column is the same as the one below it the the value dose not show up? Is
> > this something I can turn off?
> > For example I have a column that might have several rows of 0 but only one
> > 0
> > will there and then blank rows till the next value.
> >
>
>

Report not rending via web service

I'm somewhat new to reporting services and have used a web service call to
render my reports in my asp.net applications in the past. All the reports
thus far have been Excel, and I've used the same method for calling these
reports from some sample code I found online. This has worked great up till
now.
I have a report I want to render in PDF. I've plugged in the correct values
in my code and the browser will try and download the PDF but returns a "File
is damaged and could not be displayed". I tried rending in Excel and I get
"This file is not in a recognizable format". I've compared my code to past
projects and everything looks good. The only difference with this report is
I used a list control with textboxes instead of a table which I've used on
all past reports. If anyone has a suggestion on what causes these error
message, please reply. Thanks.I figured it out. There was a <httpModules> tag in my web.config that was
causing this problem. I built another project to call my report with a
"clean" web.config and it works fine.
"jweesies" wrote:
> I'm somewhat new to reporting services and have used a web service call to
> render my reports in my asp.net applications in the past. All the reports
> thus far have been Excel, and I've used the same method for calling these
> reports from some sample code I found online. This has worked great up till
> now.
> I have a report I want to render in PDF. I've plugged in the correct values
> in my code and the browser will try and download the PDF but returns a "File
> is damaged and could not be displayed". I tried rending in Excel and I get
> "This file is not in a recognizable format". I've compared my code to past
> projects and everything looks good. The only difference with this report is
> I used a list control with textboxes instead of a table which I've used on
> all past reports. If anyone has a suggestion on what causes these error
> message, please reply. Thanks.

Report Needs only PDF Export Format

Hi,

I have around 20 report in my testserver.In this 5 reports needs to export only in PDF format.
The Other 15 reports are needs to export in PDF,Excel,CSV and TIFF formats.

I am using Reporting Services2005 for developing reports and also using VS2005.
Any suggesstions appreciated.

Thanks,
Prabu

Those formats are all supported. Unfortunately you can't control for a particular report which export formats are supported. They are configured at the server level and apply to each report in the catalog.|||

You may be able to write some Javascript or report code to remove items from the list after the page is rendered.

|||Yes, but this won't prevent people from getting the reports via the SOAP API or putting the format directly on the URL.|||

Being able to render a report with the ability to restrict the export formats for a particular report through URL Parameterization and the WebService API would be a nice addition.

I want to be able to run the report in the report manager, see it display as HTML but only allow it to be exported as Pdf without having to code/provide my own interface on top of the report manager.

Of course, if the report formatted in the Web Browser and on the paper exactly the same that would also be nice. (If I have this wrong please let me know). The above addition would still be nice though.

|||

"Of course, if the report formatted in the Web Browser and on the paper exactly the same that would also be nice."

Meant to say this... Of course, if the report formatted in the Web Browser (HTML) and on the paper (Pdf) exactly the same that would also be nice.