Groups | Blog | Home
all groups > sql server reporting services > june 2006 >

sql server reporting services : SQL Code



Frederik Vanderhaeghe
6/13/2006 12:00:00 AM
Hi,

Is there a way that the sql code of the standard reports for IIS (MS SQL
Server Report Pack for IIS logs) can be viewed?

Fré

Frederik Vanderhaeghe
6/13/2006 12:00:00 AM
Hi,

This is the only bit of sql code that is in it for the country statistics:
SELECT DISTINCT sComputername
FROM GlobalIISLog
UNION
SELECT 'ALL' AS sComputername

This can't be right.

Fré

[quoted text, click to view]

Amarnath
6/13/2006 4:37:02 AM
Yes why not go open the solution file from the sample or just using notepad
open .RDL file you can see the select statement.

Amarnath

[quoted text, click to view]
Amarnath
6/13/2006 10:47:01 PM
I think you have missed out the stored procedure "summary by country"
it has some more queries.

Amarnath

[quoted text, click to view]
AddThis Social Bookmark Button