I'm using a query to populate a drop down list for a report parameter. E.g. a
number of stores. I'm using this to get sales figures per store.
Now I need a way to show the sales figures for all stores. A user should for
example be able to skip the stores selection list to select them all...
I haven't figured out yet how to skip this, or some other solution to get
every store. When I do not select a store, RS complains there's no store
selected. Even when I select "allow null value" in the parameter options...
Can someone help me?Hi Andreas,
look here in the Newsgroup :
Report Parameters with a choice of "All"
mfg Georg
"Andreas" <Andreas@.discussions.microsoft.com> schrieb im Newsbeitrag
news:BC84B219-9A78-4E5F-8FC1-5CC1A4C175D1@.microsoft.com...
> I'm using a query to populate a drop down list for a report parameter.
E.g. a
> number of stores. I'm using this to get sales figures per store.
> Now I need a way to show the sales figures for all stores. A user should
for
> example be able to skip the stores selection list to select them all...
> I haven't figured out yet how to skip this, or some other solution to get
> every store. When I do not select a store, RS complains there's no store
> selected. Even when I select "allow null value" in the parameter
options...
> Can someone help me?
>|||thx georg
"Georg Schmelzer" wrote:
> Hi Andreas,
> look here in the Newsgroup :
> Report Parameters with a choice of "All"
>
> mfg Georg
>
>
> "Andreas" <Andreas@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:BC84B219-9A78-4E5F-8FC1-5CC1A4C175D1@.microsoft.com...
> > I'm using a query to populate a drop down list for a report parameter.
> E.g. a
> > number of stores. I'm using this to get sales figures per store.
> > Now I need a way to show the sales figures for all stores. A user should
> for
> > example be able to skip the stores selection list to select them all...
> > I haven't figured out yet how to skip this, or some other solution to get
> > every store. When I do not select a store, RS complains there's no store
> > selected. Even when I select "allow null value" in the parameter
> options...
> >
> > Can someone help me?
> >
>
>
Showing posts with label number. Show all posts
Showing posts with label number. Show all posts
Friday, March 30, 2012
Wednesday, March 28, 2012
Report pages - reduce render time
Is there a way to minimize the number of pages obtained from a report. My report has more than 9000 pages. I want to minimize the number of pages as it would fasten the rendering of the report in excel,pdf formats. how would one do this? is there any expression?. your help is very much appreciated. I am tearing my hair to minimize the time taken to render a report.! help pls!
Thanks,
You say the report is 9000 pages, so what did you have in mind when you say "minimize the number of pages" -- it seems like you already know how big the report is.
If you only need to see some of the 9000 pages at a time, or only certain people need to see certain pages, you should filter the data (preferably at the data source) with parameters and/or UserId.
Report Page Numbering ***Really Urgent****
I need to place on my report "Page # of #". How do I do this as Im unsure of
the number of pages my report will be.
Also have a problem with getting my header details for each report to show
on every page. Have a Name for report, then the start and end dates and a
logo. Haven't put them into actual Page Header Area as the start and end
date bit wont work that way. Any help is appreciated.Someone seemed to have a similar problem:
Find this group in google groups, search on "Data Header on every
page".
They are suggesting to use tables within lists.
HTH
Dom|||Thanks.
"Dom" wrote:
> Someone seemed to have a similar problem:
> Find this group in google groups, search on "Data Header on every
> page".
> They are suggesting to use tables within lists.
> HTH
> Dom
>|||Also, in VS.NET, you should see "page header" under the report menu,
try that to set a page header. You should be able to put in textboxes
for the name, dates, etc...
For your page number issue, add a textbox, edit its properties, and set
its value to ="Page " & Globals!PageNumber & " of " &
Globals!TotalPages
HTH
Dominique|||Super thanks
"Dom" wrote:
> Also, in VS.NET, you should see "page header" under the report menu,
> try that to set a page header. You should be able to put in textboxes
> for the name, dates, etc...
> For your page number issue, add a textbox, edit its properties, and set
> its value to ="Page " & Globals!PageNumber & " of " &
> Globals!TotalPages
> HTH
> Dominique
>|||Just to let you know what I have for a header. I have one txt box with Name
of Report, an Image Box with Company Logo and another txt box with the
following in it.
=First(Fields!DateFrom.Value, "DateRange") & "to " &
First(Fields!DateTo.Value, "DateRange")
Is this ok to have in a page header area of the report.
"Dom" wrote:
> Also, in VS.NET, you should see "page header" under the report menu,
> try that to set a page header. You should be able to put in textboxes
> for the name, dates, etc...
> For your page number issue, add a textbox, edit its properties, and set
> its value to ="Page " & Globals!PageNumber & " of " &
> Globals!TotalPages
> HTH
> Dominique
>|||Dear Nat:
Is this giving you an error?
If so, try putting it in the report header (at the top of the body)
Have a good night!
the number of pages my report will be.
Also have a problem with getting my header details for each report to show
on every page. Have a Name for report, then the start and end dates and a
logo. Haven't put them into actual Page Header Area as the start and end
date bit wont work that way. Any help is appreciated.Someone seemed to have a similar problem:
Find this group in google groups, search on "Data Header on every
page".
They are suggesting to use tables within lists.
HTH
Dom|||Thanks.
"Dom" wrote:
> Someone seemed to have a similar problem:
> Find this group in google groups, search on "Data Header on every
> page".
> They are suggesting to use tables within lists.
> HTH
> Dom
>|||Also, in VS.NET, you should see "page header" under the report menu,
try that to set a page header. You should be able to put in textboxes
for the name, dates, etc...
For your page number issue, add a textbox, edit its properties, and set
its value to ="Page " & Globals!PageNumber & " of " &
Globals!TotalPages
HTH
Dominique|||Super thanks
"Dom" wrote:
> Also, in VS.NET, you should see "page header" under the report menu,
> try that to set a page header. You should be able to put in textboxes
> for the name, dates, etc...
> For your page number issue, add a textbox, edit its properties, and set
> its value to ="Page " & Globals!PageNumber & " of " &
> Globals!TotalPages
> HTH
> Dominique
>|||Just to let you know what I have for a header. I have one txt box with Name
of Report, an Image Box with Company Logo and another txt box with the
following in it.
=First(Fields!DateFrom.Value, "DateRange") & "to " &
First(Fields!DateTo.Value, "DateRange")
Is this ok to have in a page header area of the report.
"Dom" wrote:
> Also, in VS.NET, you should see "page header" under the report menu,
> try that to set a page header. You should be able to put in textboxes
> for the name, dates, etc...
> For your page number issue, add a textbox, edit its properties, and set
> its value to ="Page " & Globals!PageNumber & " of " &
> Globals!TotalPages
> HTH
> Dominique
>|||Dear Nat:
Is this giving you an error?
If so, try putting it in the report header (at the top of the body)
Have a good night!
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
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
Monday, March 26, 2012
Report on SQL Server objects
Hi,
We have a large database for which we need to provide support. But there is
no documentation on number of tables, stored procedures etc.
Is there any easy way to find out number of objects in a SQL Server database
at all?
Can someone let me know please?
Many thanks,
Harish Mohanbabu
Microsoft Dynamics Ax [MVP]
http://www.harishm.com/
I know about the existence of Summary where we can see the list of objects.
Ideally I am looking for a way to document all objects in something like
spread sheets ...
Harish Mohanbabu
Microsoft Dynamics Ax [MVP]
http://www.harishm.com/
|||On Feb 9, 7:58 pm, Harish Mohanbabu <Axa...@.online.nospam> wrote:
> I know about the existence of Summary where we can see the list of objects.
> Ideally I am looking for a way to document all objects in something like
> spread sheets ...
> Harish Mohanbabu
> --
> Microsoft Dynamics Ax [MVP]http://www.harishm.com/
Use ''DB''
select * from sysobjects where xtype not in ('s') and name not like 'dt
%'
copy the result on excel spreadsheet.
NJ
We have a large database for which we need to provide support. But there is
no documentation on number of tables, stored procedures etc.
Is there any easy way to find out number of objects in a SQL Server database
at all?
Can someone let me know please?
Many thanks,
Harish Mohanbabu
Microsoft Dynamics Ax [MVP]
http://www.harishm.com/
I know about the existence of Summary where we can see the list of objects.
Ideally I am looking for a way to document all objects in something like
spread sheets ...
Harish Mohanbabu
Microsoft Dynamics Ax [MVP]
http://www.harishm.com/
|||On Feb 9, 7:58 pm, Harish Mohanbabu <Axa...@.online.nospam> wrote:
> I know about the existence of Summary where we can see the list of objects.
> Ideally I am looking for a way to document all objects in something like
> spread sheets ...
> Harish Mohanbabu
> --
> Microsoft Dynamics Ax [MVP]http://www.harishm.com/
Use ''DB''
select * from sysobjects where xtype not in ('s') and name not like 'dt
%'
copy the result on excel spreadsheet.
NJ
Report on SQL Server objects
Hi,
We have a large database for which we need to provide support. But there is
no documentation on number of tables, stored procedures etc.
Is there any easy way to find out number of objects in a SQL Server database
at all?
Can someone let me know please?
Many thanks,
Harish Mohanbabu
--
Microsoft Dynamics Ax [MVP]
http://www.harishm.com/I know about the existence of Summary where we can see the list of objects.
Ideally I am looking for a way to document all objects in something like
spread sheets ...
Harish Mohanbabu
--
Microsoft Dynamics Ax [MVP]
http://www.harishm.com/|||On Feb 9, 7:58 pm, Harish Mohanbabu <Axa...@.online.nospam> wrote:
> I know about the existence of Summary where we can see the list of objects.
> Ideally I am looking for a way to document all objects in something like
> spread sheets ...
> Harish Mohanbabu
> --
> Microsoft Dynamics Ax [MVP]http://www.harishm.com/
Use ''DB''
select * from sysobjects where xtype not in ('s') and name not like 'dt
%'
copy the result on excel spreadsheet.
NJsql
We have a large database for which we need to provide support. But there is
no documentation on number of tables, stored procedures etc.
Is there any easy way to find out number of objects in a SQL Server database
at all?
Can someone let me know please?
Many thanks,
Harish Mohanbabu
--
Microsoft Dynamics Ax [MVP]
http://www.harishm.com/I know about the existence of Summary where we can see the list of objects.
Ideally I am looking for a way to document all objects in something like
spread sheets ...
Harish Mohanbabu
--
Microsoft Dynamics Ax [MVP]
http://www.harishm.com/|||On Feb 9, 7:58 pm, Harish Mohanbabu <Axa...@.online.nospam> wrote:
> I know about the existence of Summary where we can see the list of objects.
> Ideally I am looking for a way to document all objects in something like
> spread sheets ...
> Harish Mohanbabu
> --
> Microsoft Dynamics Ax [MVP]http://www.harishm.com/
Use ''DB''
select * from sysobjects where xtype not in ('s') and name not like 'dt
%'
copy the result on excel spreadsheet.
NJsql
Report on SQL Server objects
Hi,
We have a large database for which we need to provide support. But there is
no documentation on number of tables, stored procedures etc.
Is there any easy way to find out number of objects in a SQL Server database
at all?
Can someone let me know please?
Many thanks,
Harish Mohanbabu
--
Microsoft Dynamics Ax [MVP]
http://www.harishm.com/I know about the existence of Summary where we can see the list of objects.
Ideally I am looking for a way to document all objects in something like
spread sheets ...
Harish Mohanbabu
--
Microsoft Dynamics Ax [MVP]
http://www.harishm.com/|||On Feb 9, 7:58 pm, Harish Mohanbabu <Axa...@.online.nospam> wrote:
> I know about the existence of Summary where we can see the list of objects
.
> Ideally I am looking for a way to document all objects in something like
> spread sheets ...
> Harish Mohanbabu
> --
> Microsoft Dynamics Ax [MVP]http://www.harishm.com/
Use ''DB''
select * from sysobjects where xtype not in ('s') and name not like 'dt
%'
copy the result on excel spreadsheet.
NJ
We have a large database for which we need to provide support. But there is
no documentation on number of tables, stored procedures etc.
Is there any easy way to find out number of objects in a SQL Server database
at all?
Can someone let me know please?
Many thanks,
Harish Mohanbabu
--
Microsoft Dynamics Ax [MVP]
http://www.harishm.com/I know about the existence of Summary where we can see the list of objects.
Ideally I am looking for a way to document all objects in something like
spread sheets ...
Harish Mohanbabu
--
Microsoft Dynamics Ax [MVP]
http://www.harishm.com/|||On Feb 9, 7:58 pm, Harish Mohanbabu <Axa...@.online.nospam> wrote:
> I know about the existence of Summary where we can see the list of objects
.
> Ideally I am looking for a way to document all objects in something like
> spread sheets ...
> Harish Mohanbabu
> --
> Microsoft Dynamics Ax [MVP]http://www.harishm.com/
Use ''DB''
select * from sysobjects where xtype not in ('s') and name not like 'dt
%'
copy the result on excel spreadsheet.
NJ
Friday, March 23, 2012
Report Name in Subscription
Hi!
Is there a way to make the name of the report dynamic? instead of just
appending a number if a certain already exists, the name could append
the name of the current month or a selected parameter.
Thanks! :)Hi Sigh,
I think you need a data driven subscription which will require the
enterprise edition of reporting services..
Cheers
Matt
"Sigh" wrote:
> Hi!
> Is there a way to make the name of the report dynamic? instead of just
> appending a number if a certain already exists, the name could append
> the name of the current month or a selected parameter.
> Thanks! :)
>|||Hi Matt.
Unfortunately, we're running the standard edition. Thanks for the
idea. :)
Sigh.
Is there a way to make the name of the report dynamic? instead of just
appending a number if a certain already exists, the name could append
the name of the current month or a selected parameter.
Thanks! :)Hi Sigh,
I think you need a data driven subscription which will require the
enterprise edition of reporting services..
Cheers
Matt
"Sigh" wrote:
> Hi!
> Is there a way to make the name of the report dynamic? instead of just
> appending a number if a certain already exists, the name could append
> the name of the current month or a selected parameter.
> Thanks! :)
>|||Hi Matt.
Unfortunately, we're running the standard edition. Thanks for the
idea. :)
Sigh.
Tuesday, March 20, 2012
Report Manger Contents menu does not allow access
There are a number of post out here on this problem. When you bring Report
Manager up (http://localhost/reports) you might not see the tabs for Contents
and Properties and the menu bar or you do see them but you can not select any
of the items on menu bar.
One solution that seems to work for making the tabs and the menu bar visible
is to disable anonymous for the website (check in IIS). If the user is
anonymous you don't have any rights to do anything, even if you are an admin
because it does not know who your are, you are anonymous.
But this does not solve the problem of items on the menu bar are not
selectable. Does anyone know the answer? I believe it is a permissions issue
of some sort, but where? What is very frustrating is that there are no error
messages any where, nothing to go on.
Since this is a problem that a number of people have run into, I would like
to Microsoft step up and explain in detail what is going on here. I have
looked in Online Books and searched Microsoft knowledge base and have found
nothing that addresses this.I search Online Books again and in the Trouble Shooting section for Report
Services I found this:
Selected Pages in Report Manager do not open
If you are using Internet Information Services (IIS) 6.0 configured with
default settings on your report server, you must add the Web server name as a
Trusted Site (for example, http://mywebservername). Otherwise, you cannot
open the New Folder page, New Data Source page, and Upload File page from the
Contents tab. Also, the frameset used in Report Manager Help does not open
correctly.
"gvr" wrote:
> There are a number of post out here on this problem. When you bring Report
> Manager up (http://localhost/reports) you might not see the tabs for Contents
> and Properties and the menu bar or you do see them but you can not select any
> of the items on menu bar.
> One solution that seems to work for making the tabs and the menu bar visible
> is to disable anonymous for the website (check in IIS). If the user is
> anonymous you don't have any rights to do anything, even if you are an admin
> because it does not know who your are, you are anonymous.
> But this does not solve the problem of items on the menu bar are not
> selectable. Does anyone know the answer? I believe it is a permissions issue
> of some sort, but where? What is very frustrating is that there are no error
> messages any where, nothing to go on.
> Since this is a problem that a number of people have run into, I would like
> to Microsoft step up and explain in detail what is going on here. I have
> looked in Online Books and searched Microsoft knowledge base and have found
> nothing that addresses this.
>
Manager up (http://localhost/reports) you might not see the tabs for Contents
and Properties and the menu bar or you do see them but you can not select any
of the items on menu bar.
One solution that seems to work for making the tabs and the menu bar visible
is to disable anonymous for the website (check in IIS). If the user is
anonymous you don't have any rights to do anything, even if you are an admin
because it does not know who your are, you are anonymous.
But this does not solve the problem of items on the menu bar are not
selectable. Does anyone know the answer? I believe it is a permissions issue
of some sort, but where? What is very frustrating is that there are no error
messages any where, nothing to go on.
Since this is a problem that a number of people have run into, I would like
to Microsoft step up and explain in detail what is going on here. I have
looked in Online Books and searched Microsoft knowledge base and have found
nothing that addresses this.I search Online Books again and in the Trouble Shooting section for Report
Services I found this:
Selected Pages in Report Manager do not open
If you are using Internet Information Services (IIS) 6.0 configured with
default settings on your report server, you must add the Web server name as a
Trusted Site (for example, http://mywebservername). Otherwise, you cannot
open the New Folder page, New Data Source page, and Upload File page from the
Contents tab. Also, the frameset used in Report Manager Help does not open
correctly.
"gvr" wrote:
> There are a number of post out here on this problem. When you bring Report
> Manager up (http://localhost/reports) you might not see the tabs for Contents
> and Properties and the menu bar or you do see them but you can not select any
> of the items on menu bar.
> One solution that seems to work for making the tabs and the menu bar visible
> is to disable anonymous for the website (check in IIS). If the user is
> anonymous you don't have any rights to do anything, even if you are an admin
> because it does not know who your are, you are anonymous.
> But this does not solve the problem of items on the menu bar are not
> selectable. Does anyone know the answer? I believe it is a permissions issue
> of some sort, but where? What is very frustrating is that there are no error
> messages any where, nothing to go on.
> Since this is a problem that a number of people have run into, I would like
> to Microsoft step up and explain in detail what is going on here. I have
> looked in Online Books and searched Microsoft knowledge base and have found
> nothing that addresses this.
>
Saturday, February 25, 2012
Report Hit Counts
This is gonna be simple - but not for me!!
I need to record the number of hits each report gets from users. As a bonus,
also the parameter values passed would be usefull also.
What would be the simplist and most efficient way of achieving the above
please.
Thanks and Happy New Year
TonyThe report server automatically logs all Report Executions. Look at the
Execution Log table. More info can be found here:
http://msdn2.microsoft.com/en-us/library/ms155836.aspx
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tony Scott" <TonyScott@.discussions.microsoft.com> wrote in message
news:43FF9683-CA87-414F-890A-5D1F310F8E5B@.microsoft.com...
> This is gonna be simple - but not for me!!
> I need to record the number of hits each report gets from users. As a
> bonus,
> also the parameter values passed would be usefull also.
> What would be the simplist and most efficient way of achieving the above
> please.
> Thanks and Happy New Year
> Tony|||More than what Daniel has said, there is a sample package with reports, and
SSIS package which parses the logs, moves the data into a table, and provides
about 6 reports against them... It is exactly what you need.
Look for it in the samples for SQL..
(The reports are really nice!>)
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"Tony Scott" wrote:
> This is gonna be simple - but not for me!!
> I need to record the number of hits each report gets from users. As a bonus,
> also the parameter values passed would be usefull also.
> What would be the simplist and most efficient way of achieving the above
> please.
> Thanks and Happy New Year
> Tony
I need to record the number of hits each report gets from users. As a bonus,
also the parameter values passed would be usefull also.
What would be the simplist and most efficient way of achieving the above
please.
Thanks and Happy New Year
TonyThe report server automatically logs all Report Executions. Look at the
Execution Log table. More info can be found here:
http://msdn2.microsoft.com/en-us/library/ms155836.aspx
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tony Scott" <TonyScott@.discussions.microsoft.com> wrote in message
news:43FF9683-CA87-414F-890A-5D1F310F8E5B@.microsoft.com...
> This is gonna be simple - but not for me!!
> I need to record the number of hits each report gets from users. As a
> bonus,
> also the parameter values passed would be usefull also.
> What would be the simplist and most efficient way of achieving the above
> please.
> Thanks and Happy New Year
> Tony|||More than what Daniel has said, there is a sample package with reports, and
SSIS package which parses the logs, moves the data into a table, and provides
about 6 reports against them... It is exactly what you need.
Look for it in the samples for SQL..
(The reports are really nice!>)
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"Tony Scott" wrote:
> This is gonna be simple - but not for me!!
> I need to record the number of hits each report gets from users. As a bonus,
> also the parameter values passed would be usefull also.
> What would be the simplist and most efficient way of achieving the above
> please.
> Thanks and Happy New Year
> Tony
Tuesday, February 21, 2012
Report Hangs - Security Issue?
Iâ'm running SQL Server 2005 with Reporting Services. I have developed a
number of reports that use data from a fairly obscure financial package that
we use. The data sits on a Unix server and is pulled into SRSS using an ODBC
driver. When the connection to the data is made PowerTCP launches
(www.dart.com). I had deployed a number of these reports and they were
working but no longer work from the Report Manager either on a remote
computer or on the server logged on as the Administrator. The reports still
function in the preview window of the Visual Studio environment. I initially
thought that it could have something to do with the enhanced DCOM security
with Window Server 2003 SP1. I am hesitant to uninstall SP1, but I guess it
may be worth a try. I canâ't definitively pin down a time frame as to when
the reports stopped working (i.e. pre or post SP1). I have combed all the
log files I can think of, but havenâ't discovered anything. One interesting
note is that when I launch the report the server beeps once and then the
report never comes up, it just sits there. I am at my witâ's end so if
someone can shed some light on this I would appreciate it.
Thanks in advance.I don't quite understand but one thing you could try is to add the site to
the safe list in 2003 Server. SP1 locks down accessing other servers unless
they are part of the safe list.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rob" <Rob@.discussions.microsoft.com> wrote in message
news:8B537B1B-D382-44FD-928B-FD525BB0C920@.microsoft.com...
> I'm running SQL Server 2005 with Reporting Services. I have developed a
> number of reports that use data from a fairly obscure financial package
> that
> we use. The data sits on a Unix server and is pulled into SRSS using an
> ODBC
> driver. When the connection to the data is made PowerTCP launches
> (www.dart.com). I had deployed a number of these reports and they were
> working but no longer work from the Report Manager either on a remote
> computer or on the server logged on as the Administrator. The reports
> still
> function in the preview window of the Visual Studio environment. I
> initially
> thought that it could have something to do with the enhanced DCOM security
> with Window Server 2003 SP1. I am hesitant to uninstall SP1, but I guess
> it
> may be worth a try. I can't definitively pin down a time frame as to when
> the reports stopped working (i.e. pre or post SP1). I have combed all the
> log files I can think of, but haven't discovered anything. One
> interesting
> note is that when I launch the report the server beeps once and then the
> report never comes up, it just sits there. I am at my wit's end so if
> someone can shed some light on this I would appreciate it.
> Thanks in advance.
>|||To clarify, I think the way it works is that when the ODBC driver goes out to
grab data it lauches PowerTCP which establishes a connection to the Unix
server and allows for the data transfer.
Is the safe list you are talking about in Internet Explorer sites? Where do
I configure the safe list you are talking about?
"Bruce L-C [MVP]" wrote:
> I don't quite understand but one thing you could try is to add the site to
> the safe list in 2003 Server. SP1 locks down accessing other servers unless
> they are part of the safe list.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Rob" <Rob@.discussions.microsoft.com> wrote in message
> news:8B537B1B-D382-44FD-928B-FD525BB0C920@.microsoft.com...
> > I'm running SQL Server 2005 with Reporting Services. I have developed a
> > number of reports that use data from a fairly obscure financial package
> > that
> > we use. The data sits on a Unix server and is pulled into SRSS using an
> > ODBC
> > driver. When the connection to the data is made PowerTCP launches
> > (www.dart.com). I had deployed a number of these reports and they were
> > working but no longer work from the Report Manager either on a remote
> > computer or on the server logged on as the Administrator. The reports
> > still
> > function in the preview window of the Visual Studio environment. I
> > initially
> > thought that it could have something to do with the enhanced DCOM security
> > with Window Server 2003 SP1. I am hesitant to uninstall SP1, but I guess
> > it
> > may be worth a try. I can't definitively pin down a time frame as to when
> > the reports stopped working (i.e. pre or post SP1). I have combed all the
> > log files I can think of, but haven't discovered anything. One
> > interesting
> > note is that when I launch the report the server beeps once and then the
> > report never comes up, it just sits there. I am at my wit's end so if
> > someone can shed some light on this I would appreciate it.
> >
> > Thanks in advance.
> >
>
>|||Yes, it is in IE, Tools, Security tab, Safe Sites
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rob" <Rob@.discussions.microsoft.com> wrote in message
news:396E5C0F-470A-4A7C-A73A-894C4C57164E@.microsoft.com...
> To clarify, I think the way it works is that when the ODBC driver goes out
> to
> grab data it lauches PowerTCP which establishes a connection to the Unix
> server and allows for the data transfer.
> Is the safe list you are talking about in Internet Explorer sites? Where
> do
> I configure the safe list you are talking about?
> "Bruce L-C [MVP]" wrote:
>> I don't quite understand but one thing you could try is to add the site
>> to
>> the safe list in 2003 Server. SP1 locks down accessing other servers
>> unless
>> they are part of the safe list.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Rob" <Rob@.discussions.microsoft.com> wrote in message
>> news:8B537B1B-D382-44FD-928B-FD525BB0C920@.microsoft.com...
>> > I'm running SQL Server 2005 with Reporting Services. I have developed
>> > a
>> > number of reports that use data from a fairly obscure financial package
>> > that
>> > we use. The data sits on a Unix server and is pulled into SRSS using
>> > an
>> > ODBC
>> > driver. When the connection to the data is made PowerTCP launches
>> > (www.dart.com). I had deployed a number of these reports and they were
>> > working but no longer work from the Report Manager either on a remote
>> > computer or on the server logged on as the Administrator. The reports
>> > still
>> > function in the preview window of the Visual Studio environment. I
>> > initially
>> > thought that it could have something to do with the enhanced DCOM
>> > security
>> > with Window Server 2003 SP1. I am hesitant to uninstall SP1, but I
>> > guess
>> > it
>> > may be worth a try. I can't definitively pin down a time frame as to
>> > when
>> > the reports stopped working (i.e. pre or post SP1). I have combed all
>> > the
>> > log files I can think of, but haven't discovered anything. One
>> > interesting
>> > note is that when I launch the report the server beeps once and then
>> > the
>> > report never comes up, it just sits there. I am at my wit's end so if
>> > someone can shed some light on this I would appreciate it.
>> >
>> > Thanks in advance.
>> >
>>|||Thanks for your efforts, but I still can't get it working. I'll have to find
a work around.
"Bruce L-C [MVP]" wrote:
> Yes, it is in IE, Tools, Security tab, Safe Sites
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Rob" <Rob@.discussions.microsoft.com> wrote in message
> news:396E5C0F-470A-4A7C-A73A-894C4C57164E@.microsoft.com...
> > To clarify, I think the way it works is that when the ODBC driver goes out
> > to
> > grab data it lauches PowerTCP which establishes a connection to the Unix
> > server and allows for the data transfer.
> >
> > Is the safe list you are talking about in Internet Explorer sites? Where
> > do
> > I configure the safe list you are talking about?
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> I don't quite understand but one thing you could try is to add the site
> >> to
> >> the safe list in 2003 Server. SP1 locks down accessing other servers
> >> unless
> >> they are part of the safe list.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Rob" <Rob@.discussions.microsoft.com> wrote in message
> >> news:8B537B1B-D382-44FD-928B-FD525BB0C920@.microsoft.com...
> >> > I'm running SQL Server 2005 with Reporting Services. I have developed
> >> > a
> >> > number of reports that use data from a fairly obscure financial package
> >> > that
> >> > we use. The data sits on a Unix server and is pulled into SRSS using
> >> > an
> >> > ODBC
> >> > driver. When the connection to the data is made PowerTCP launches
> >> > (www.dart.com). I had deployed a number of these reports and they were
> >> > working but no longer work from the Report Manager either on a remote
> >> > computer or on the server logged on as the Administrator. The reports
> >> > still
> >> > function in the preview window of the Visual Studio environment. I
> >> > initially
> >> > thought that it could have something to do with the enhanced DCOM
> >> > security
> >> > with Window Server 2003 SP1. I am hesitant to uninstall SP1, but I
> >> > guess
> >> > it
> >> > may be worth a try. I can't definitively pin down a time frame as to
> >> > when
> >> > the reports stopped working (i.e. pre or post SP1). I have combed all
> >> > the
> >> > log files I can think of, but haven't discovered anything. One
> >> > interesting
> >> > note is that when I launch the report the server beeps once and then
> >> > the
> >> > report never comes up, it just sits there. I am at my wit's end so if
> >> > someone can shed some light on this I would appreciate it.
> >> >
> >> > Thanks in advance.
> >> >
> >>
> >>
> >>
>
>
number of reports that use data from a fairly obscure financial package that
we use. The data sits on a Unix server and is pulled into SRSS using an ODBC
driver. When the connection to the data is made PowerTCP launches
(www.dart.com). I had deployed a number of these reports and they were
working but no longer work from the Report Manager either on a remote
computer or on the server logged on as the Administrator. The reports still
function in the preview window of the Visual Studio environment. I initially
thought that it could have something to do with the enhanced DCOM security
with Window Server 2003 SP1. I am hesitant to uninstall SP1, but I guess it
may be worth a try. I canâ't definitively pin down a time frame as to when
the reports stopped working (i.e. pre or post SP1). I have combed all the
log files I can think of, but havenâ't discovered anything. One interesting
note is that when I launch the report the server beeps once and then the
report never comes up, it just sits there. I am at my witâ's end so if
someone can shed some light on this I would appreciate it.
Thanks in advance.I don't quite understand but one thing you could try is to add the site to
the safe list in 2003 Server. SP1 locks down accessing other servers unless
they are part of the safe list.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rob" <Rob@.discussions.microsoft.com> wrote in message
news:8B537B1B-D382-44FD-928B-FD525BB0C920@.microsoft.com...
> I'm running SQL Server 2005 with Reporting Services. I have developed a
> number of reports that use data from a fairly obscure financial package
> that
> we use. The data sits on a Unix server and is pulled into SRSS using an
> ODBC
> driver. When the connection to the data is made PowerTCP launches
> (www.dart.com). I had deployed a number of these reports and they were
> working but no longer work from the Report Manager either on a remote
> computer or on the server logged on as the Administrator. The reports
> still
> function in the preview window of the Visual Studio environment. I
> initially
> thought that it could have something to do with the enhanced DCOM security
> with Window Server 2003 SP1. I am hesitant to uninstall SP1, but I guess
> it
> may be worth a try. I can't definitively pin down a time frame as to when
> the reports stopped working (i.e. pre or post SP1). I have combed all the
> log files I can think of, but haven't discovered anything. One
> interesting
> note is that when I launch the report the server beeps once and then the
> report never comes up, it just sits there. I am at my wit's end so if
> someone can shed some light on this I would appreciate it.
> Thanks in advance.
>|||To clarify, I think the way it works is that when the ODBC driver goes out to
grab data it lauches PowerTCP which establishes a connection to the Unix
server and allows for the data transfer.
Is the safe list you are talking about in Internet Explorer sites? Where do
I configure the safe list you are talking about?
"Bruce L-C [MVP]" wrote:
> I don't quite understand but one thing you could try is to add the site to
> the safe list in 2003 Server. SP1 locks down accessing other servers unless
> they are part of the safe list.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Rob" <Rob@.discussions.microsoft.com> wrote in message
> news:8B537B1B-D382-44FD-928B-FD525BB0C920@.microsoft.com...
> > I'm running SQL Server 2005 with Reporting Services. I have developed a
> > number of reports that use data from a fairly obscure financial package
> > that
> > we use. The data sits on a Unix server and is pulled into SRSS using an
> > ODBC
> > driver. When the connection to the data is made PowerTCP launches
> > (www.dart.com). I had deployed a number of these reports and they were
> > working but no longer work from the Report Manager either on a remote
> > computer or on the server logged on as the Administrator. The reports
> > still
> > function in the preview window of the Visual Studio environment. I
> > initially
> > thought that it could have something to do with the enhanced DCOM security
> > with Window Server 2003 SP1. I am hesitant to uninstall SP1, but I guess
> > it
> > may be worth a try. I can't definitively pin down a time frame as to when
> > the reports stopped working (i.e. pre or post SP1). I have combed all the
> > log files I can think of, but haven't discovered anything. One
> > interesting
> > note is that when I launch the report the server beeps once and then the
> > report never comes up, it just sits there. I am at my wit's end so if
> > someone can shed some light on this I would appreciate it.
> >
> > Thanks in advance.
> >
>
>|||Yes, it is in IE, Tools, Security tab, Safe Sites
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rob" <Rob@.discussions.microsoft.com> wrote in message
news:396E5C0F-470A-4A7C-A73A-894C4C57164E@.microsoft.com...
> To clarify, I think the way it works is that when the ODBC driver goes out
> to
> grab data it lauches PowerTCP which establishes a connection to the Unix
> server and allows for the data transfer.
> Is the safe list you are talking about in Internet Explorer sites? Where
> do
> I configure the safe list you are talking about?
> "Bruce L-C [MVP]" wrote:
>> I don't quite understand but one thing you could try is to add the site
>> to
>> the safe list in 2003 Server. SP1 locks down accessing other servers
>> unless
>> they are part of the safe list.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Rob" <Rob@.discussions.microsoft.com> wrote in message
>> news:8B537B1B-D382-44FD-928B-FD525BB0C920@.microsoft.com...
>> > I'm running SQL Server 2005 with Reporting Services. I have developed
>> > a
>> > number of reports that use data from a fairly obscure financial package
>> > that
>> > we use. The data sits on a Unix server and is pulled into SRSS using
>> > an
>> > ODBC
>> > driver. When the connection to the data is made PowerTCP launches
>> > (www.dart.com). I had deployed a number of these reports and they were
>> > working but no longer work from the Report Manager either on a remote
>> > computer or on the server logged on as the Administrator. The reports
>> > still
>> > function in the preview window of the Visual Studio environment. I
>> > initially
>> > thought that it could have something to do with the enhanced DCOM
>> > security
>> > with Window Server 2003 SP1. I am hesitant to uninstall SP1, but I
>> > guess
>> > it
>> > may be worth a try. I can't definitively pin down a time frame as to
>> > when
>> > the reports stopped working (i.e. pre or post SP1). I have combed all
>> > the
>> > log files I can think of, but haven't discovered anything. One
>> > interesting
>> > note is that when I launch the report the server beeps once and then
>> > the
>> > report never comes up, it just sits there. I am at my wit's end so if
>> > someone can shed some light on this I would appreciate it.
>> >
>> > Thanks in advance.
>> >
>>|||Thanks for your efforts, but I still can't get it working. I'll have to find
a work around.
"Bruce L-C [MVP]" wrote:
> Yes, it is in IE, Tools, Security tab, Safe Sites
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Rob" <Rob@.discussions.microsoft.com> wrote in message
> news:396E5C0F-470A-4A7C-A73A-894C4C57164E@.microsoft.com...
> > To clarify, I think the way it works is that when the ODBC driver goes out
> > to
> > grab data it lauches PowerTCP which establishes a connection to the Unix
> > server and allows for the data transfer.
> >
> > Is the safe list you are talking about in Internet Explorer sites? Where
> > do
> > I configure the safe list you are talking about?
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> I don't quite understand but one thing you could try is to add the site
> >> to
> >> the safe list in 2003 Server. SP1 locks down accessing other servers
> >> unless
> >> they are part of the safe list.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Rob" <Rob@.discussions.microsoft.com> wrote in message
> >> news:8B537B1B-D382-44FD-928B-FD525BB0C920@.microsoft.com...
> >> > I'm running SQL Server 2005 with Reporting Services. I have developed
> >> > a
> >> > number of reports that use data from a fairly obscure financial package
> >> > that
> >> > we use. The data sits on a Unix server and is pulled into SRSS using
> >> > an
> >> > ODBC
> >> > driver. When the connection to the data is made PowerTCP launches
> >> > (www.dart.com). I had deployed a number of these reports and they were
> >> > working but no longer work from the Report Manager either on a remote
> >> > computer or on the server logged on as the Administrator. The reports
> >> > still
> >> > function in the preview window of the Visual Studio environment. I
> >> > initially
> >> > thought that it could have something to do with the enhanced DCOM
> >> > security
> >> > with Window Server 2003 SP1. I am hesitant to uninstall SP1, but I
> >> > guess
> >> > it
> >> > may be worth a try. I can't definitively pin down a time frame as to
> >> > when
> >> > the reports stopped working (i.e. pre or post SP1). I have combed all
> >> > the
> >> > log files I can think of, but haven't discovered anything. One
> >> > interesting
> >> > note is that when I launch the report the server beeps once and then
> >> > the
> >> > report never comes up, it just sits there. I am at my wit's end so if
> >> > someone can shed some light on this I would appreciate it.
> >> >
> >> > Thanks in advance.
> >> >
> >>
> >>
> >>
>
>
Subscribe to:
Posts (Atom)