Reporting Services 2005

What is the best option to monitor user accesses to published reports? IT department wants to have an idea about the need (value and time) of produced reports.

Regards,

Vitor Mota

I will not comment on what the "best option" is, but this is an option I use frequently for debugging.

If you use stored procedures to generate the data for your reports, you can have them update a stats table to indicate that a given report has been run. You would have to have stored procedures unique to a given report for this to work, but I suppose if you wanted to be fancy, you could write stored procedures just for this purpose.

Otherwise, there are lots of IIS log analyzers out there.

|||

Thanks for your answer.

I'm reading data to reports using MDX queries without using sps and analyzing the IIS logs are hard to do.

I was looking for an "almost" ready solution to use. Any other idea?

Best regards,

Vitor Mota

Reporting Services

Hi there

Have been using the "vanilla" SQL Express for some time now and feel that I kind of know what I'm doing.

However, I have no idea what can be acheived with the Reporting Services that come with the "advanced" SQL Express.

Can someone please explain what I can do with Reporting Services?

Reporting Services is a web server that allows you to provide a reporting exerience for your database that can be accessed on a web site rather than requring people to open up a specific application. Think about things like summary or rollup reports; there is no need to have everyone install a specialized application, you just create reports and Deploy them to RS and then folks can look at them.

Like any access to SQL, you can use either Windows or SQL Auth, depending on how your SQL Server is configured, and then use that to control access to the data.

RS Express provides some limited Export capability (PDF & XLS) and can only access local, relational data. There is more information in BOL and a whole series of webcasts you can view to learn more at http://msdn.microsoft.com/sql/bi/reporting/default.aspx.

Regards,

Mike Wachal
SQL Express team

-
Please mark your thread as Answered when you get your solution.

Reporting on MS SOX(Sarbanes-Oxley) Accelerator Data

Hi,
I am in need of building reports on the MS SOX Accelerator Databases,
does anyone have any idea how I can go about doing this or any idea
how to export/transform the XML data?
Thank you...I believe that the team will be releasing a set of Reporting Services
reports that work against the SOX databases. You might try asking in their
message board at
http://www.gotdotnet.com/community/workspaces/Workspace.aspx?id=095aa2b8-6eda-4316-8c30-7b7929bcd8da.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Rohit" <mrrohit99@.hotmail.com> wrote in message
news:3ea14ae8.0408091922.32acc4e1@.posting.google.com...
> Hi,
> I am in need of building reports on the MS SOX Accelerator Databases,
> does anyone have any idea how I can go about doing this or any idea
> how to export/transform the XML data?
> Thank you...