显示标签为“displays”的博文。显示所有博文
显示标签为“displays”的博文。显示所有博文

2012年3月29日星期四

Disk usage Report

There needs to be two levels of disk usage reports, one that just reads the meta data (similar to 2000 functionality), and displays the pretty graphs, and then the one that is currently available that does the index analysis and so on. I have a 1.2 TB database on 2005 and it takes forever to pull up that report (which my client has decided they love)...

Also, I do not know how hard it would be to keep a running analysis of database/index fragmentation, but that would be a nice feature also, even if it was an enterprise only feature.

Just a thought.

Hi Jake,

Thanks for the feedback. I'll pass it along to the PM who owns the reports in SSMS.

Cheers,
Dan

2012年3月8日星期四

Disappearing printer icon

I am finding that sometimes the RS web page displays a printer icon between
the refresh and help icons. This icon brings up a standard print dialog (when
the icon is there) which allows users to print to any of the printers
installed on their local system. It is definitely different than the printer
button on the browser. Reports print as though they were scheduled instead of
just rendered out of IE.
My question is, does anyone know why the icon only shows up on some
reporting services installations? It appears to be RS installation specific.
I get it when I connect to my local RS but when I connect to one on a 2000
server I do not.
TIA,
JimThe print icon was new in Service Pack 2. Is it possible that the server
hasn't had the upgrade?
"JimH" wrote:
> I am finding that sometimes the RS web page displays a printer icon between
> the refresh and help icons. This icon brings up a standard print dialog (when
> the icon is there) which allows users to print to any of the printers
> installed on their local system. It is definitely different than the printer
> button on the browser. Reports print as though they were scheduled instead of
> just rendered out of IE.
> My question is, does anyone know why the icon only shows up on some
> reporting services installations? It appears to be RS installation specific.
> I get it when I connect to my local RS but when I connect to one on a 2000
> server I do not.
> TIA,
> Jim

2012年2月17日星期五

Disable Pagination

Hi,
Is there anyway you can disable pagination so when a report is rendered in
HTML it displays all the rows in one page. I am displaying the reports
without the RS toolbar and do not want to use the page functionality.
I understand that it is more effecient to use pages but I will only ever be
displaying maximum 500 rows of data in a report. I would like to see it
displayed in one page where the users will have to scroll down to view the
data. I will also have interactive sorting enabled on the columns.
Currently I have a report that is being rendered on one HTML page but
displays page break lines. However when I sort the data it only displays one
page.
Any help in solving this problem would be greatly appreciated. I am using RS
2005
Thanks
KevinSet the InteractiveSize Height to 0
"Kevin Wilson" wrote:
> Hi,
> Is there anyway you can disable pagination so when a report is rendered in
> HTML it displays all the rows in one page. I am displaying the reports
> without the RS toolbar and do not want to use the page functionality.
> I understand that it is more effecient to use pages but I will only ever be
> displaying maximum 500 rows of data in a report. I would like to see it
> displayed in one page where the users will have to scroll down to view the
> data. I will also have interactive sorting enabled on the columns.
> Currently I have a report that is being rendered on one HTML page but
> displays page break lines. However when I sort the data it only displays one
> page.
> Any help in solving this problem would be greatly appreciated. I am using RS
> 2005
> Thanks
> Kevin
>

Disable links for totals

Hi,
I have a crosstab report that displays the totals of specific data. I have
totals on my groupings(rows). I also have made these totals a hyperlink to
allow the user to drilldown to see the detail of the count. However, I do not
want the totals to be a hyperlink, I need them to be just plain text. How do
I accomplish this in SRS? It seems as though SRS just makes all data items a
hyperlink, whether its the count the total of the figures. I really need to
make these totals plain text.
Any help is much appreciated.
KevinSorry, when I said crosstab, I meant matrix :)
"Kevin" wrote:
> Hi,
> I have a crosstab report that displays the totals of specific data. I have
> totals on my groupings(rows). I also have made these totals a hyperlink to
> allow the user to drilldown to see the detail of the count. However, I do not
> want the totals to be a hyperlink, I need them to be just plain text. How do
> I accomplish this in SRS? It seems as though SRS just makes all data items a
> hyperlink, whether its the count the total of the figures. I really need to
> make these totals plain text.
> Any help is much appreciated.
> Kevin