Manage a data source for a report found in a SharePoint Document Library

I was working for 2 days on integrating reporting services with MOSS 2007.

The problem i faces was to create a data source for the

uploaded report (Not created using a wizard ) that will connect

me to the SQL server.

As i clicked on the arrow near the uploaded report to manage the data source, i found no

data source for this item.

I would be pleased to know the howto create this data source and where.

Best Regards,

Lana

Here are two recommended approaches to create a shared data source in MOSS 2007:
- Create one in the Report Designer and deploy it to the apprpriate SharePoint Document Library OR
- Add the "Report Data Source" content type from the Document Library Settings. Next, select the "Report Data Source" content type from the Document Library's "New" menu. Next, you should see a web page to create a shared data source.

Hope this helps.

thanx,
Prash

|||

Dear Prash,

I created the doc library that reads a data source

I uploaded a dataSource.rds but it was uploaded as hidden coz i

viewed the content of the doc in the Actions --> open with

explorer view.

Nevertheless, i created a new Report Data Source having the Data

Source Type as Microsoft SQL server but i didn't know what to insert in

theConnection string (Enter a connection string for accessing the report data source).

Although my connection string was empty, i clicked on my uploaded report to manage the data source but i found no data source for this item.

Thanks,

Lana

|||

Please note, that the .rds file is not the shared data source file in SharePoint. For details on creating Shared Data source Refer to SQL BOL topic "How to: Create and Manage Shared Data Sources (Reporting Services in SharePoint Integrated Mode) "

Have you tried deploying the shared data source and Report directly from the designer instead of manually uploading the file into SharePoint? If you manually upload a .rdl file with reference to a shared data source you will have to edit the reference once you have uploaded it to SharePoint via "Manage Data Sources". Generally, deploying the report and shared data source from the designer should preserve the reference from the report to the shared data source.

For details on connection string information refer to SQL BOL topic on "Connecting to a Data Source".

Hope this helps.

thanx,
Prash

sql

making virtual directories for sql server 2005 reporting services

I have sql server reporting services installed .

I have reinstalled the iis .

But now when i ever i reinstalled the reporting services i can't see any virtual directory in IIS.

SSRS installed successfully but no virtual directory

Now please let me help in making the virtual directories of sql server 2005 reporting services.

When I reinstall then if i try to connect with management studio I can't.

If i try to check surface area configuration i get following message

"Reporting services is not configured properly sqlsac"

See if the Service came up properly. if not there should be entried in the event log, showing what went wrong during the startup.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

Making use of RGDI output

According to the Reporting Services feature matrix, the image output that Report Server Express has is something called RGDI. From what I've gathered, RGDI stands for Remote GDI.

What is the RGDI file format useful for? I don't know the proper file extension to give the file, nor do I know what viewer can view it.

Is there some way to convert the RGDI format to a more universally accepted file format such as .tif, .gif, .jpg, etc...? I'm hoping that I can just capture the binary stream, and convert the stream to a different image format before saving the file.

Thanks!

RGDI is not useful in itself, it's only usable and used by the Winforms report controls in VS 2005.

Thanks
Tudor|||

So you are saying that RGDI isn't available via a call to the Render() web service method to Report Server Express?

In that case, is Report Server Express going to support calling Render with a format of "IMAGE" and return a .tif file? If not, does RS Express support rendering to any sort of image type? The .tif functionality seems pretty useful.

Thanks.

|||

RGDI is available, but it only works with the WinForms Report Control. It consists of serialized GDI calls, which are not generally useful. The Express Server supports EMF format for printing.

|||

Brian, I would like to save the results of a Render() in the RGDI format to later be opened using a winforms application that may not have access to our servers.

Is it possible to save the RGDI results and open them later with the ReportViewer in a disconnected environment?

Making use of RGDI output

According to the Reporting Services feature matrix, the image output that Report Server Express has is something called RGDI. From what I've gathered, RGDI stands for Remote GDI.

What is the RGDI file format useful for? I don't know the proper file extension to give the file, nor do I know what viewer can view it.

Is there some way to convert the RGDI format to a more universally accepted file format such as .tif, .gif, .jpg, etc...? I'm hoping that I can just capture the binary stream, and convert the stream to a different image format before saving the file.

Thanks!

RGDI is not useful in itself, it's only usable and used by the Winforms report controls in VS 2005.

Thanks
Tudor|||

So you are saying that RGDI isn't available via a call to the Render() web service method to Report Server Express?

In that case, is Report Server Express going to support calling Render with a format of "IMAGE" and return a .tif file? If not, does RS Express support rendering to any sort of image type? The .tif functionality seems pretty useful.

Thanks.

|||

RGDI is available, but it only works with the WinForms Report Control. It consists of serialized GDI calls, which are not generally useful. The Express Server supports EMF format for printing.

|||

Brian, I would like to save the results of a Render() in the RGDI format to later be opened using a winforms application that may not have access to our servers.

Is it possible to save the RGDI results and open them later with the ReportViewer in a disconnected environment?

Making report add in work

Good day

I have been trying to install some type of reporting service . I have found a add in for web developer 2005 express . I drag the nessesay onto my form from the tool box and data table , but when I test the application all I get is xml , like below. Have I left something out. sorry I forgot to add that I also get this error on the default page-

An error has occurred during report processing.

ObjectDataSource 'ObjectDataSource1' could not find a non-generic method 'GetDatabyShipsID' that has no parameters.

<?xml version="1.0" encoding="utf-8"?>

-<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">

-<DataSources>

-<DataSource Name="ConnectionString">

+<ConnectionProperties>

<ConnectString/>

<DataProvider>SQL</DataProvider>

</ConnectionProperties>

<rd:DataSourceID>baa3d63e-0dc9-43cf-9477-0040139b2ea1</rd:DataSourceID>

</DataSource>

</DataSources>

<BottomMargin>2.5cm</BottomMargin>

<RightMargin>2.5cm</RightMargin>

Hi;

Ok from the error message you are getting ie. "An error has occurred during report processing.

ObjectDataSource 'ObjectDataSource1' could not find a non-generic method 'GetDatabyShipsID' that has no parameters." the error seems to indicate that the datasource you are using (ObjectDataSOurce1) is supposed to call a method called "GetDatebyShipsID" that has no parameters. Check if you have that method and add select parameters to your datasource.

Making groups visible using Parameters

Hi everyone,

I am new to reporting services and really need some help..
Im trying to simply my requirement using this scenario: Lets say

I want to display Sales for the current year (i.e from the start of the year january to the month we are currently at). The next requirement is to group these sales, by Area , Region , Zone...

Top leve l = Zone , then Region then Area.

I need the user to be able to control this using a parameter (i.e User can select "View Area Level" or "View Region Level" or "View Zone level")

How can this best be achieved ?

My idea was using row groupings and controling visibility using the parameter.. The problem is.. If i want to view ONLY the area level and not see anything above, can I turn visibility off of the Zone and Region and still see the inner group (area)

Area Level (default view)

Jan Feb
Area 1 100 100
Area 2 200 200

Region Level Selected

Reagion 1
Area 1 100 100
Region 2
Area 2 200 200

Zone Level Select

Zone 1
Region 1
Area 1 100 100
Region 2
Area 2 200 200
Any help would REALLY be appreciated ..

Kind Regards,
Neil
http://blogs.msdn.com/chrishays/archive/2004/07/15/DynamicGrouping.aspx|||

Hello Neil,

I can think of a couple ways to do this, one way is having 2 boolean parameters. From the way you show in your example, it looks like the Area level will always show.

First, you'll need to create the 2 parameters as boolean type and set your defaults. For example: ShowRegion - False, ShowZone - False.

Click on the row handle for your Zone level and go to the Hidden setting in the Properties window.

Change the Hidden setting to an expression and enter this into it:

=Iif(Parameters!ShowZone.Value = True, False, True)

Click on the row handle for your Region level and change the Hidden setting to this expression:

=Iif(Parameters!ShowRegion.Value = True OR Parameters!ShowZone.Value = True, False, True)

Hope this helps.

Jarret

|||Hey Jarret

Thanks so much for the reply, I have found away to do this, well In theory the idea works..
With regards to your idea.. I was thinking that If the parent group is made invisible so are the children groups (invisible).. well.. I dont know if that is the case.. If you know the answer please let me know..

Thanks for taking the time to help out.. really appreciate it

Kind Regards,
Neil
|||

Hello,

If you hide a higher group (parent), the lower groups (children) will continue to show until explicitly hidden. They are independent of each other.

Jarret

|||Great !!

Thanks!!

Making groups available

I'd like to get the sum of a row in a reporting services table. Unlike
summing columns which are easy, I'm told I need to create a group.
I create the group with the fields I want to sum. Then I right click on the
table cell I want to hold the sum value, and select expression. My table
column names are there, but not my group (which I need to sum my row).
When I create the group, I give it a name and add the fields I want to sum.
What else do I have to do to make the group available when I edit expressions?
Of course, if there's some aggregate functions that let's me sum a row
without a group, all the better.
Thanks
--
RandyHi Randy,
Welcome to the MSDN newsgroup.
Regarding on the "sum of a row in a reporting services table", do you mean
perform sum on all the columns in a single data row or still sum a certain
column , but restricted in a certain group?
If you're wantting to perform the sum on all the columns in a single row,
I'm afraid, the group or other filter can not help on this. You may need to
manually write the sum code in the expression of the textbox or certain
table cell. Also, since you'll perform sum on the columns, we need to make
sure all the columns are of number type.
Regards,
Steven Cheng
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.
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Many thanks for the reply.
Yes, I would like to sum all the columns in the row, and they are all type
int.
I have found the code window, and written a VB function to sum all the
columns. When I say Code.MySum(...) in the Edit Expression dialog box, MySum
is underlined in red and "not defined".
I've tried to just sum the columns in the edit expression dialog box. The
sum function provided only takes one parameter. I'd need an example or BOM
reference to see how to do this. At one point, someone suggested the Subtotal
function, but I couldn't find that in the available aggregate functions list.
If you could point me toward an article on writing functions for reporting
services under the Code tab or in the Edit Expression dialog box, that would
help a lot.
Thanks again,
--
Randy
"Steven Cheng[MSFT]" wrote:
> Hi Randy,
> Welcome to the MSDN newsgroup.
> Regarding on the "sum of a row in a reporting services table", do you mean
> perform sum on all the columns in a single data row or still sum a certain
> column , but restricted in a certain group?
> If you're wantting to perform the sum on all the columns in a single row,
> I'm afraid, the group or other filter can not help on this. You may need to
> manually write the sum code in the expression of the textbox or certain
> table cell. Also, since you'll perform sum on the columns, we need to make
> sure all the columns are of number type.
> Regards,
> Steven Cheng
> 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.
>
> Get Secure! www.microsoft.com/security
> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>
>
>
>
>|||Thanks for your followup Randy,
IMO, if you just want to do sum on all the columns in a single row, you can
just put the sum code in the expression of the textbox( use + operator).
For example:
=Fields("col1").Value + Fields("col2").Value + Fields("col3").Value
For custom code in SSRS, you can have a look at the following web reference:
#Using Custom Code References in Expressions [Reporting Services]
http://msdn2.microsoft.com/en-US/library/ms155798(SQL.90).aspx
#Chapter 5: Using Custom .Net Code with Reports
http://www.yukonxml.com/chapters/apress/reportingservices/dotnet/
Hope this helps.
Regards,
Steven Cheng
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.
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

Make a SELECT DISTINCT in Reporting Services

Hi,
I have a stored procedure, that can't be modified.
It return data like these (the real one is more, and more complex of
course)
A ...
A ...
A ...
B ...
B ...
B ...
C ...
C ...
I want to make a table with only theses entries :
A
B
C
How can i do it in reporting services ? I have tested
=Distinct(Fields!Qu_HA_LIB.Value, "GESCCNS")
But Distrinct seems to be not recognized by RS 2000
Thank you in advance
MassanuCan somebody help me, please ...

Make a Report from two different data source..

Hi,
I am trying to make a Report on SQL Server Reporting Services 2005.
Here I am facing a problem that is follows-
I have a two seprate database server Server1 and Server2 and from both
server have table1 on server1 and table2 on server2.
I just want to make a report to accessing a data from both server
tables. I dont know how can I make a Report through SSRS-2005.
Please help any one have idea..
This would be helpful for me.
Thanks,
Rahul.Any chance you could link the two SQL servers together? You cannot
run a single query against two individual servers unless they are
"aware" of each other, and linking is one way to do that.
You could set up individual datasets and perhaps link them together
using parameters, also.
On Mar 31, 5:57 am, mukul <mukuljainshas...@.gmail.com> wrote:
> Hi,
> I am trying to make a Report on SQL Server Reporting Services 2005.
> Here I am facing a problem that is follows-
> I have a two seprate database server Server1 and Server2 and from both
> server have table1 on server1 and table2 on server2.
> I just want to make a report to accessing a data from both server
> tables. I dont know how can I make a Report through SSRS-2005.
> Please help any one have idea..
> This would be helpful for me.
> Thanks,
> Rahul.|||Although you cannot join data together in RS. You can use subreports.
Subreports work great for this sort of thing.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"mukul" <mukuljainshastri@.gmail.com> wrote in message
news:9717ddc3-8972-41a4-8862-6b4b75f2ed71@.s13g2000prd.googlegroups.com...
> Hi,
> I am trying to make a Report on SQL Server Reporting Services 2005.
> Here I am facing a problem that is follows-
> I have a two seprate database server Server1 and Server2 and from both
> server have table1 on server1 and table2 on server2.
> I just want to make a report to accessing a data from both server
> tables. I dont know how can I make a Report through SSRS-2005.
> Please help any one have idea..
> This would be helpful for me.
> Thanks,
> Rahul.|||On Mar 31, 4:38=A0pm, "Jerry H." <boilersr...@.gmail.com> wrote:
> Any chance you could link the two SQL servers together? =A0You cannot
> run a single query against two individual servers unless they are
> "aware" of each other, and linking is one way to do that.
> You could set up individual datasets and perhaps link them together
> using parameters, also.
> On Mar 31, 5:57 am, mukul <mukuljainshas...@.gmail.com> wrote:
>
> > Hi,
> > I am trying to make a Report on SQL Server Reporting Services 2005.
> > Here I am facing a problem that is follows-
> > I have a two seprate database server Server1 and Server2 and from both
> > server have table1 on server1 and table2 on server2.
> > I just want to make a report to accessing a data from both server
> > tables. I dont know how can I make a Report through SSRS-2005.
> > Please help any one have idea..
> > This would be helpful for me.
> > Thanks,
> > Rahul.- Hide quoted text -
> - Show quoted text -
Hi Jerry,
Thanks a lot for reply.
Yes, If this is possible by linking the server then its Ok, but I dont
know the procedure to link the two server and after linking how I can
access the data from different database server through the query?
Please can you help me out to solve this report.
Thanks you for your support,
Rahul.|||On Mar 31, 7:48=A0pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> Although you cannot join data together in RS. You can use subreports.
> Subreports work great for this sort of thing.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "mukul" <mukuljainshas...@.gmail.com> wrote in message
> news:9717ddc3-8972-41a4-8862-6b4b75f2ed71@.s13g2000prd.googlegroups.com...
>
> > Hi,
> > I am trying to make a Report on SQL Server Reporting Services 2005.
> > Here I am facing a problem that is follows-
> > I have a two seprate database server Server1 and Server2 and from both
> > server have table1 on server1 and table2 on server2.
> > I just want to make a report to accessing a data from both server
> > tables. I dont know how can I make a Report through SSRS-2005.
> > Please help any one have idea..
> > This would be helpful for me.
> > Thanks,
> > Rahul.- Hide quoted text -
> - Show quoted text -
Hi Bruce,
Thank you very much for your response,
Please could you give me the idea how can I achieve the target report
through subreports.
I dont know how can I made a subreports in RS when the data are coming
from different database server.
Thank you,
Rahul.|||You can have multiple data sources. Each dataset comes from a single data
source. So, if you have a master-detail type report you have the main report
with a dataset going to one server and then a subreport (which is just a
regular report with a parameter) to the other. You drag and drop the
subreport onto the main report, right mouse click, parameters and map the
parameter of the subreport to a field of the main report.
For master - detail reports, regardless of where the data is coming from)
that is how you design a report.
Note about linked servers. This is a SQL Server thing and advanced in my
book. The reason I feel that way is that if you try to do a join using lined
servers you can end up downloading the complete remote table. Fine if the
table is small but not so fine if there is any size whatsoever.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"mukul" <mukuljainshastri@.gmail.com> wrote in message
news:9668f8bc-a8cc-4e79-9bf5-fa83767e3b06@.q27g2000prf.googlegroups.com...
On Mar 31, 7:48 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> Although you cannot join data together in RS. You can use subreports.
> Subreports work great for this sort of thing.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "mukul" <mukuljainshas...@.gmail.com> wrote in message
> news:9717ddc3-8972-41a4-8862-6b4b75f2ed71@.s13g2000prd.googlegroups.com...
>
> > Hi,
> > I am trying to make a Report on SQL Server Reporting Services 2005.
> > Here I am facing a problem that is follows-
> > I have a two seprate database server Server1 and Server2 and from both
> > server have table1 on server1 and table2 on server2.
> > I just want to make a report to accessing a data from both server
> > tables. I dont know how can I make a Report through SSRS-2005.
> > Please help any one have idea..
> > This would be helpful for me.
> > Thanks,
> > Rahul.- Hide quoted text -
> - Show quoted text -
Hi Bruce,
Thank you very much for your response,
Please could you give me the idea how can I achieve the target report
through subreports.
I dont know how can I made a subreports in RS when the data are coming
from different database server.
Thank you,
Rahul.

Major Problems with Calculated Fields

Is anyone else having problems with Calculated Members? Everything was working fine with viewing the cubes in the browser, in Reporting Services, and via Pivot tables...but once I put in some simple calculated members (simple parallel period functions), query times are extremely slow, everything locks up,unexpected Visual Studio crashes occur...SSAS pretty much becomes unusable.

Anyone with similar experiences?

You should see some performance improvements in SP1.

In limited number of cases you can use NON_EMPTY_BEHAVIOR when defining you calculated member. You got to be careful with it for parallel period such that you might not have a value for certain measure in parallel period. But if you can guarantee that, you should see way better performance.

Hope that helps.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Do you know if this is a problem with SSAS, Reporting Services, or the OLAP 9.0 Provider? I seem to be having the same problem when using Reporting Services 2000 and the 9.0 Provider. If I can't report on SSAS 2005 easily, I simply can't upgrade until the issues are resolved.

Major Problem!...Multiple user connection problem in reporting service 2000 with SOAP

Hi Everyone,

I am having a big problem here.

I am using Reporting Service 2000 and Visual Studio 2005. I have developed a custom web control which communicates with reporting web service and displays report. I pass username, password and domain information as network credential for communicating with report server (report server is remote). This is a web application in which users can see reports on the web page which uses my custom web control.

Everything works fine when there is single user. But when another user logs onto website and tries to access same or different report it seems like connection of the first user gets lost. And everything crashes for first user and for second user it works fine.

In fact if second user is accessing the same report then first user can see second user's report information which is no at all acceptable. I am sure that there should be some way so that multiple users can communicate with reporting server programmatically at the same time. Microsoft wouldn't make reporting web service so that only one user can access report at a time, would they?

Can anyone help me with this problem? Any help will be greatly appreciated.

Sounds like your users are being identified as the same person which would suggest annonymous access is being used or your web control is passing the same credentials for both users. I'm not sure how you've coded it or whether you are doing any caching or storing session state somewhere.

You have to narrow down what is at fault here. I would suggest the following:

Set your report server and report manager virtual directories to integrated or basic authentication and have 2 separate users access report manager at the same time|||

Thanks Adam for quick reply.

I don't have anonymous access enabled. I am using integrated windows authentication. Earlier i was trying to authenticate all users with one administartor credentials to communicate with Reporting web service. But then i changed my code so that it takes individual user's credentials. But this didn't make any difference.

I read in one reporting service book that Report server overwrites SessionID member after each call to the Render method. Therefore, two subsequent report requests will share same sessions only if they ask for the same report (assuming that the parameter set is same)

For example, let's say you run report A, then report B, and then report A again. When report B is rendered, its session identifier will overwrite the previous session identifier, which means that you will lose report A's session identifier. When report A is run again, even if the parameter set is the same, its execution will create a new report session and IsNewExecution will return true.

So i think this overwriting of SessionID by report server is causing the problem. But i don't know yet how to program so that it maintains proper SessionID for each user and hence doesn't crash for any user.

If anyone has any idea for solving this problem then please let me know. Thanks in advance.

|||Figured out. It was bug in my code. Accidentlly i had declared Parameter property as static in my code and because of that one user's report was using other user's property and which was making program crash. Thanks for reply though.

Major Multiple connection problem RS2000 with SOAP

Hi Everyone,

I am having a big problem here.

I am using Reporting Service 2000 and Visual Studio 2005. I have developed a custom web control which communicates with reporting web service and displays report. I pass username, password and domain information as network credential for communicating with report server (report server is remote). This is a web application in which users can see reports on the web page which uses my custom web control.

Everything works fine when there is single user. But when another user logs onto website and tries to access same or different report it seems like connection of the first user gets lost. And everything crashes for first user and for second user it works fine.

In fact if second user is accessing the same report then first user can see second user's report information which is no at all acceptable. I am sure that should be some way so that multiple users can communicate with reporting server programmatically at the same time. Microsoft wouldn't make reporting web service so that only one user can access report at a time, would they?

Can anyone help me with this problem? ANyhelp will be greatly appreciated.

I don't have anonymous access enabled. I am using integrated windows authentication. Earlier i was trying to authenticate all users with one administartor credentials to communicate with Reporting web service. But then i changed my code so that it takes individual user's credentials. But this didn't make any difference.

I read in one reporting service book that Report server overwrites SessionID member after each call to the Render method. Therefore, two subsequent report requests will share same sessions only if they ask for the same report (assuming that the parameter set is same)

For example, let's say you run report A, then report B, and then report A again. When report B is rendered, its session identifier will overwrite the previous session identifier, which means that you will lose report A's session identifier. When report A is run again, even if the parameter set is the same, its execution will create a new report session and IsNewExecution will return true.

So i think this overwriting of SessionID by report server is causing the problem. But i don't know yet how to program so that it maintains proper SessionID for each user and hence doesn't crash for any user.

If anyone has any idea for solving this problem then please let me know. Thanks in advance.

Major flaw with Reporting Services!

There seems to be a major flaw with Reporting Services that will give huge problems. RS can't support subreports when it is generated in Excel. As you know all reporting, almost all of them are dumped in Excel format. I really hope someone fix this huge flaw to this software. I wouldn't recommend RS to anyone if I have known about this problem earlier. This problem is huge, for me at least 75% of the problem.

Do you know when patch or fix or whatever will be available so people can generate subreports in excel? I would really hope Microsoft put out just a patch, instead of a release so that it will be available soon to everyone. This is crazy!

Enkh.

Sub reports have a limititation in Excel of not working in a Table or Matrix. However, they will work in a list or a non data region.|||

I would really hope that you guys fix this problem, because this problem is huge since a lot of people usually generate reports in excel and fix the problem and send it when they don't have a lot of time. You can't do that with PDF reports.

Just to give you a little suggestion and information and I think you can bring this up in the needed RFE to RS next version when you guys go over RS in your usual meetings..

1. Make sub-reports function flawlesly in Excel whether it is in table or matrix or whatever.

2. I think event management is really needed in Reporting Services. Active Reports has events like "on report start", "on report end", "on fetch data" etc that users can write codes and those get executed depending on the function and event that is in. This is really useful when manipulating data greatly. This is very very very needed.

3. There seems to be a huge problem with how layout of the report is handled. For example when a table is not getting rendered on a certain page, it's header is not getting displayed on that page. I think there should be absolute setting of headers on all pages that doesn't depend on a whether table or anything is on the page.

Let me know if you have questions, I would be glad to help you guys about this RS feature enhancement. I create fairly complicated reports in RS.

Let me know if you have any questions,

Enkh.

|||I fail to see the significance of exporting reports to Excel. Report consumers frequently ask for the ability to export to excel - as excel is the tool that allows them to feel they are still in charge. However after years I have yet to see anyone do anything intelligent with the report output once they get it to excel.

Do your users do something intelligent with Excel Output?|||I have created several reports that have many subreports in them. Everything exports to Excel fine for me.|||

Yes it will export fine for reports with subreports not in a table or matrix. Once you put a subreport in a Table or Matrix, the export to Excel doesn't work saying it is ignoring the cell in the subreports. I don't think it knows how to create cells in Excel when subreport is in a Table. My main use of subreports this way is that one information in the main report needs to have multiple information handled in a subreport. I can't really do that all the time through just one query, so I have to create a second query to get a bunch of info. for the main record, and the advantage of Table or Matrix is that it can loop through the dataset, so the subreport has to be in the detail section so that it can loop with the main database record.

I hope I made it clear. Let me know if you have questions and we probably we can exchange ideas.

Enkh.

|||

Yes definitely, they need an instant edit access to the report so that when there is no time to correct the information in the database on the data (find the bug), they will have to change the values in the report themselves once.

Enkh.

|||

Enkht,

Can you give me an example of when you would want to have a report that does not reflect the actual state of the data? While I understand pen and ink changes, I think that this capability could become a real Pandora's box of trouble.

R