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

Disk Time 100% during Insert Data

Hi ,
I am using SQL 2000 SP3 2 CPU (Intel II ~1230) with 4 GB RAM .
The server is data warehouse server that load data and served reports.

I am loading data every 15 minute with Balk Insert command into temporarty tables and than insert the data to two fact tables with logic implemented by store procedure.

Each time I am insert new data ( every 15 minutes , for around ~ 4 minute of ~ 250,000 lines) the Disk time is 100% .

I am using RAID 5 with logical partitions for system ,SQL Data file and SQL transaction log file .

In order to solve the Disk Time bottleneck ( the CPU is normal during the insert ~ 40 % but still the duration is too long due to the disk time problem) I though to create separate file group to each fact table and change the Disk configuration from RAID 5 to double RAID 1 ,each one for each File group ( and other disks for the transaction log and system ) .I though that in this way I will be able to use each of the physical disks rather than current RAID 5 .

Any idea ? do you know other option to solve this problem ? what is the reaon for the fact that the Data file that store on RAID 5 do not use the 5 physical Disk headers ?

Thanks in advance
EyalYou didn't mention the "C" word...but I imagine it's in play...where's the data coming from? INSERTS are a logged operation...and 250k of rows, every 15 minutes...is a lot of data...

I would try to figure out a way to perform a nonlogged operation (bulk insert?) and apply the logic against the database...

My own opinion (MOO)

What type of data is this?|||Howdy

Worth removing any indexes on the load tables & then recreating the indexes once data has been loaded?

FWIW

Cheers,

SG.|||Hi no one response regard the Disk configuration .This is my best solution to the Disk time - separate the two Fact table to different phiscal disk means working with two disk header in parallel . !!??|||And you mentioned that you're interested in speed...if you're doing insert a row at a time then that'll be slow, if you're using a cursor, that'll be slow, if your modifying data on import, that'll be slow...

If you want to split the data across attached drives, go ahead, make a patitioned view and go nuts...

Is that the root cause of your problem?

Hard for us to tell until the mind reading machine comes back online...|||I agree with Brett 100%...more info required please

Cheers,

SG

Disk Full of transactions log's

Hi,
One of my app servers has filled the c:\ drive with transactions log's.
Someone moved the log's to another disk, SQL now reports the database as
being suspect. We moved the log's back, it still reports the db as suspect?
Any help would be greatly appreciated
Rich
Hi,
take a look here:
http://www.karaszi.com/SQLServer/inf...suspect_db.asp
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
|||reset should resolve the problem (order in sequences, try the next step
if the first one doesn't work).
1) restart the MSSQL services (starts the auto recovery)
2) detach and re-attach the database
3) restore the latest database backup
Mel

Disk Full of transactions log's

Hi,
One of my app servers has filled the c:\ drive with transactions log's.
Someone moved the log's to another disk, SQL now reports the database as
being suspect. We moved the log's back, it still reports the db as suspect?
Any help would be greatly appreciated
RichHi,
take a look here:
http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--|||reset should resolve the problem (order in sequences, try the next step
if the first one doesn't work).
1) restart the MSSQL services (starts the auto recovery)
2) detach and re-attach the database
3) restore the latest database backup
Mel

Disk Full of transactions log's

Hi,
One of my app servers has filled the c:\ drive with transactions log's.
Someone moved the log's to another disk, SQL now reports the database as
being suspect. We moved the log's back, it still reports the db as suspect?
Any help would be greatly appreciated
RichHi,
take a look here:
http://www.karaszi.com/SQLServer/in..._suspect_db.asp
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--|||reset should resolve the problem (order in sequences, try the next step
if the first one doesn't work).
1) restart the MSSQL services (starts the auto recovery)
2) detach and re-attach the database
3) restore the latest database backup
Mel

Disappearing point labels

I have deployed a number of reports with bar charts. Most of these bar
charts have numeric point labels. On some charts the upper most and lowest
bars do not display the point labels in preview or report manager. I have
experimented with font size and style, point label position as well as chart
size but I cannot seem to find a consistant solution.
Appreciate any help with this problem.This is a known issue in the chart control and we will look into providing a
fix in a future release.
Current workaround: Turn on margins for the x-axis (which is shown as
vertical axis in bar charts) and the labels will work consistently.
As you have noticed resizing the entire chart or using different font sizes
is not reliable. You may also try turning on 3D mode.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"O8" <andrew.stokes@.vodafone.net> wrote in message
news:usaRaTKpEHA.3848@.tk2msftngp13.phx.gbl...
> I have deployed a number of reports with bar charts. Most of these bar
> charts have numeric point labels. On some charts the upper most and lowest
> bars do not display the point labels in preview or report manager. I have
> experimented with font size and style, point label position as well as
chart
> size but I cannot seem to find a consistant solution.
>
> Appreciate any help with this problem.
>
>

Disappearing lines when rendering as an IMAGE

I'm having some problems rendering reports as images. We've been using PDF
rendering in the past and had no problems. However, when we switched over to
IMAGE we noticed that in reports with grid type layouts, some of the lines in
the grid would be missing. For example, a grid starting on the second page
of a particular report looks fine there, but on the next page all of the
gridlines are gone. On the next page I get the same result, but the
gridlines begin to show up again halfway down the page (within the same
grid). Any thoughts?
ThanksCould you create a sample report that demonstrates the problem and post it
to the newsgroup? Please use an embedded image and use one of the sample
databases as a data source.
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Boese" <Boese@.discussions.microsoft.com> wrote in message
news:77FC51EB-5F6B-48BF-95CF-84D138362FDD@.microsoft.com...
> I'm having some problems rendering reports as images. We've been using
PDF
> rendering in the past and had no problems. However, when we switched over
to
> IMAGE we noticed that in reports with grid type layouts, some of the lines
in
> the grid would be missing. For example, a grid starting on the second
page
> of a particular report looks fine there, but on the next page all of the
> gridlines are gone. On the next page I get the same result, but the
> gridlines begin to show up again halfway down the page (within the same
> grid). Any thoughts?
> Thanks|||It would probably be useful if I remembered to inclued the link...
http://www.rose-hulman.edu/~boeseaw/|||Increasing the border width should solve this problem.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Boese" <Boese@.discussions.microsoft.com> wrote in message
news:8658F69E-CAF5-4F41-B925-38F6AC615618@.microsoft.com...
> It would probably be useful if I remembered to inclued the link...
> http://www.rose-hulman.edu/~boeseaw/

Disappearing data elements in the header

I have created a number of reports where I need to display database elements in the Header record. I have been using the reportitems feature to get them to display there. When I preview the report the header looks fine; however, when the report is exported to pdf or printed out the header information completly disappears.

Any suggestions would be great.

Hi,

While displaying the data fileds in the Header you are using report items and using those in the text box of the Report header then the textbox has the Repeat With property.Set it to the data region with which the report item need to be repeated.Previously I tried this it is looking good in the preview When i am exporting the data fileds are displaying in the first page only not displaying in the consecutive pages of report.Can you try by setting the Repeat with property.

Thanks.

|||

Using RepeatWith property is not an ideal solution because the cause for a new page creation need not necessarily be the data region that spans more than 1 page. So create a new hidden report parameter and have the default value of that as the one which you have used in your hidden report item.

Shyam

Disabling report processing

Hi
I have to disable report processing at certain times for some reports. It's
like when you don't have selected a value in a combo parameter. I have a
function that returns true if you can view the report or false if don't.
Any ideas?
AndrésWhen you configure your parameter, ensure you do not allow null.
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"afontan" <andres.fontan@.alcuadrado.com> wrote in message
news:%23Itbbo1eEHA.2848@.TK2MSFTNGP10.phx.gbl...
> Hi
> I have to disable report processing at certain times for some reports.
> It's
> like when you don't have selected a value in a combo parameter. I have a
> function that returns true if you can view the report or false if don't.
> Any ideas?
> Andrés
>

Disabling print and export options

Hi,

Obviusly RS wasn't created for this, but i have to ask.

It's posible disable print and export buttons for specific reports?
For example, reports in a specific directory.

Thanks.

Hi Dark_V

It is possible to hide the Toolbar. You can use the following as your url

The following example hides the HTML Viewer toolbar by setting therc:Toolbar parameter value tofalse:

http://servername/reportserver?/ReportName&rs:Command=Render&rs:Format=HTML4.0&rc:Toolbar=false

|||

l0n3i200n wrote:

Hi Dark_V

It is possible to hide the Toolbar. You can use the following as your url

The following example hides the HTML Viewer toolbar by setting therc:Toolbar parameter value tofalse:

http://servername/reportserver?/ReportName&rs:Command=Render&rs:Format=HTML4.0&rc:Toolbar=false

Although, this is the best option I can think of, I just want to pointout that the user can remove the toolbar=false part to still access thetoolbar. I don't think there's any capability to keep the user fromprinting because they can still just print the page from the browser'smenu.

Disabling print and export options

Hi,

Obviusly RS wasn't created for this, but i have to ask.

It's posible disable print and export buttons for specific reports?
For example, reports in a specific directory.

Thanks.

This is not possible using the default viewer. You can hide or disable them entirely but having this logic would require you building your own viewer.

|||

Thanks,

I can't find any component or viewer code with this features.

Someone find something with this functions?

Thanks

Disabling Export to Excel Sheets In MS SQL Reports 2005

Hello All,

Can i disable export to Excel sheet in ms sql server 2005 reporting services.

This is due to security reasons as the client doesnt want the reports to be send via mail.

Can someone provide the solution on how to disable export to excel

Thanks

Pritam Shetty

Look at the article here:

http://msdn2.microsoft.com/en-us/library/ms156281.aspx

This will only disable the option in the Report Manager, URL access will be still allowed.

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

I'm a little concerned about something...

>>

This is due to security reasons as the client doesnt want the reports to be send via mail.

<<

Disabling export doesn't prevent the reports from being sent email. Someone can still select the text on the page and dump it into an e-mail message from the HTML version, or Save the page As and attach the result to an email.

>L<

|||

Hello Lisa,

Indirectly i will be disabling all the options.

As of the copy paste thing the clients are ok with it.

But They have just asked to disble the export feature.

So i m just going with it as of now

Thanks & Regards

Pritam Shetty

Disabling AutoRendering for Reports with Default Parameters

I have a report with default parameters. Every time the report is selected,
it automatically renders the report using the defaults. Is there any way to
disable the AutoRendering feature so my users can choose to override the
report's defaults and then render the report manually?
--
Jay P. Meredith
Senior Software Engineer
Columbia Helicopters, Inc.
PO Box 3500
Portland, OR 97208Just a stab, but maybe worth trying... What if you add a hidden parameter
which has no default value, and is not used... That might prevent
auto-render, and force the user to select the view report button... ( I
don't know what potential bad side effects might occur tho...)
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Jay Meredith" <JayMeredith@.discussions.microsoft.com> wrote in message
news:5E0D389A-8EE3-417B-A658-8DFCBD01D483@.microsoft.com...
>I have a report with default parameters. Every time the report is
>selected,
> it automatically renders the report using the defaults. Is there any way
> to
> disable the AutoRendering feature so my users can choose to override the
> report's defaults and then render the report manually?
> --
> Jay P. Meredith
> Senior Software Engineer
> Columbia Helicopters, Inc.
> PO Box 3500
> Portland, OR 97208|||Wayne,
A hidden parameter with no default value will cause the report not to render
at all. After all, if it has no default, it has to be told what its value
is. And if the user can't see it to choose a value, then the report will
just sit there, waiting for input.
The only way I've found against AutoRender when the report is first open is
to leave one of my parameters with no default, forcing the user to make a
choice on it.
BLARGH... It would be nice if RS was old enough that someone else had all
the answers and we didn't have to be the ones to find out the answers the
hard way. @.=/
Catadmin
--
MCDBA, MCSA
Random Thoughts: If a person is Microsoft Certified, does that mean that
Microsoft pays the bills for the funny white jackets that tie in the back?
@.=)
"Wayne Snyder" wrote:
> Just a stab, but maybe worth trying... What if you add a hidden parameter
> which has no default value, and is not used... That might prevent
> auto-render, and force the user to select the view report button... ( I
> don't know what potential bad side effects might occur tho...)
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Jay Meredith" <JayMeredith@.discussions.microsoft.com> wrote in message
> news:5E0D389A-8EE3-417B-A658-8DFCBD01D483@.microsoft.com...
> >I have a report with default parameters. Every time the report is
> >selected,
> > it automatically renders the report using the defaults. Is there any way
> > to
> > disable the AutoRendering feature so my users can choose to override the
> > report's defaults and then render the report manually?
> > --
> > Jay P. Meredith
> > Senior Software Engineer
> > Columbia Helicopters, Inc.
> > PO Box 3500
> > Portland, OR 97208
>
>|||Leaving one or more unhidden parameters without defaults seems to be the best
compromise. In defaulting all parameters, I was trying to save the user a
few keystrokes. Thanks.
--
Jay P. Meredith
Senior Software Engineer
Columbia Helicopters, Inc.
PO Box 3500
Portland, OR 97208
"Catadmin" wrote:
> Wayne,
> A hidden parameter with no default value will cause the report not to render
> at all. After all, if it has no default, it has to be told what its value
> is. And if the user can't see it to choose a value, then the report will
> just sit there, waiting for input.
> The only way I've found against AutoRender when the report is first open is
> to leave one of my parameters with no default, forcing the user to make a
> choice on it.
> BLARGH... It would be nice if RS was old enough that someone else had all
> the answers and we didn't have to be the ones to find out the answers the
> hard way. @.=/
> Catadmin
> --
> MCDBA, MCSA
> Random Thoughts: If a person is Microsoft Certified, does that mean that
> Microsoft pays the bills for the funny white jackets that tie in the back?
> @.=)
>
> "Wayne Snyder" wrote:
> > Just a stab, but maybe worth trying... What if you add a hidden parameter
> > which has no default value, and is not used... That might prevent
> > auto-render, and force the user to select the view report button... ( I
> > don't know what potential bad side effects might occur tho...)
> >
> > --
> > Wayne Snyder, MCDBA, SQL Server MVP
> > Mariner, Charlotte, NC
> > www.mariner-usa.com
> > (Please respond only to the newsgroups.)
> >
> > I support the Professional Association of SQL Server (PASS) and it's
> > community of SQL Server professionals.
> > www.sqlpass.org
> >
> > "Jay Meredith" <JayMeredith@.discussions.microsoft.com> wrote in message
> > news:5E0D389A-8EE3-417B-A658-8DFCBD01D483@.microsoft.com...
> > >I have a report with default parameters. Every time the report is
> > >selected,
> > > it automatically renders the report using the defaults. Is there any way
> > > to
> > > disable the AutoRendering feature so my users can choose to override the
> > > report's defaults and then render the report manually?
> > > --
> > > Jay P. Meredith
> > > Senior Software Engineer
> > > Columbia Helicopters, Inc.
> > > PO Box 3500
> > > Portland, OR 97208
> >
> >
> >|||Always glad to be of assistance. @.=)
Catadmin
"Jay Meredith" wrote:
> Leaving one or more unhidden parameters without defaults seems to be the best
> compromise. In defaulting all parameters, I was trying to save the user a
> few keystrokes. Thanks.
> --
> Jay P. Meredith
> Senior Software Engineer
> Columbia Helicopters, Inc.
> PO Box 3500
> Portland, OR 97208
>
> "Catadmin" wrote:
> > Wayne,
> >
> > A hidden parameter with no default value will cause the report not to render
> > at all. After all, if it has no default, it has to be told what its value
> > is. And if the user can't see it to choose a value, then the report will
> > just sit there, waiting for input.
> >
> > The only way I've found against AutoRender when the report is first open is
> > to leave one of my parameters with no default, forcing the user to make a
> > choice on it.
> >
> > BLARGH... It would be nice if RS was old enough that someone else had all
> > the answers and we didn't have to be the ones to find out the answers the
> > hard way. @.=/
> >
> > Catadmin
> > --
> > MCDBA, MCSA
> > Random Thoughts: If a person is Microsoft Certified, does that mean that
> > Microsoft pays the bills for the funny white jackets that tie in the back?
> > @.=)
> >
> >
> > "Wayne Snyder" wrote:
> >
> > > Just a stab, but maybe worth trying... What if you add a hidden parameter
> > > which has no default value, and is not used... That might prevent
> > > auto-render, and force the user to select the view report button... ( I
> > > don't know what potential bad side effects might occur tho...)
> > >
> > > --
> > > Wayne Snyder, MCDBA, SQL Server MVP
> > > Mariner, Charlotte, NC
> > > www.mariner-usa.com
> > > (Please respond only to the newsgroups.)
> > >
> > > I support the Professional Association of SQL Server (PASS) and it's
> > > community of SQL Server professionals.
> > > www.sqlpass.org
> > >
> > > "Jay Meredith" <JayMeredith@.discussions.microsoft.com> wrote in message
> > > news:5E0D389A-8EE3-417B-A658-8DFCBD01D483@.microsoft.com...
> > > >I have a report with default parameters. Every time the report is
> > > >selected,
> > > > it automatically renders the report using the defaults. Is there any way
> > > > to
> > > > disable the AutoRendering feature so my users can choose to override the
> > > > report's defaults and then render the report manually?
> > > > --
> > > > Jay P. Meredith
> > > > Senior Software Engineer
> > > > Columbia Helicopters, Inc.
> > > > PO Box 3500
> > > > Portland, OR 97208
> > >
> > >
> > >

Disabled or Locked Date Parameters

Hi
I'm fairly new to Reporting Services. We have three or four parameters in
our reports. The FirstDate and LastDate parameters (datetime) are disabled
or locked until we fill in information in the other parameter fields. If the
date parameters are first in the list, they are not disabled or locked. But
we would like them to be last most of the time. Is there a way to "unlock"
them so they are enabled when the report is run instead of having to fill out
the other parameters first?
TIA
MarieJOn Apr 19, 8:08 am, MarieJ <Mar...@.discussions.microsoft.com> wrote:
> Hi
> I'm fairly new to Reporting Services. We have three or four parameters in
> our reports. The FirstDate and LastDate parameters (datetime) are disabled
> or locked until we fill in information in the other parameter fields. If the
> date parameters are first in the list, they are not disabled or locked. But
> we would like them to be last most of the time. Is there a way to "unlock"
> them so they are enabled when the report is run instead of having to fill out
> the other parameters first?
> TIA
> MarieJ
As long as they are not dependent on preceding report parameters, they
should not appear locked. Make sure that the datasets that are
sourcing the parameters are not dependent on the wrong parameters
themselves. To check this, select the Data tab and select the correct
Dataset name from the drop-down list and select the Edit Selected
Dataset [...] button and then check the parameter mappings of the
dataset via the Parameters tab. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

Disable user configurable Subscription

Hi,

Does anyone know if you can disable a users ability to set their own schedules and only choose from shared schedules for their reports. The reason I ask is because we have a window from about 3-7 in the morning where we do DTS and maintenance etc and dont want the databases queried as the results could be wrong. Therefore we want to setup a range of shared schedules for users to pick which wont coincide with that time.

Thanks in advance

Dan.

Sorry this feature does not exist in the current subscription framework. You could write your own delivery extension that did this, but it would not stop someone from using another extension and using a non shared schedule.

Disable Right Click?

Is there anyway to disable mouse right click events in Reporting Services
Reports?
I am using RS 2005.
On custom web pages, I can either use javascript/vbscript or set
oncontextmenu="return false".
How can I accomplish the same results using Reporting Services?
I've been searching and find no built-in property for my desired result. I
do have access to Visual Studio 2005, is there a custom way to provide what I
need using VB.Net or other method?
I realize that even if possible, users can probably get around it, but at
least it will limit users from exporting data to Excel for example.
Thanks!labsRcool@.community.nospan wrote:
> Is there anyway to disable mouse right click events in Reporting Services
> Reports?
> I am using RS 2005.
> On custom web pages, I can either use javascript/vbscript or set
> oncontextmenu="return false".
> How can I accomplish the same results using Reporting Services?
> I've been searching and find no built-in property for my desired result. I
> do have access to Visual Studio 2005, is there a custom way to provide what I
> need using VB.Net or other method?
> I realize that even if possible, users can probably get around it, but at
> least it will limit users from exporting data to Excel for example.
> Thanks!
I also responded to your other posting. It seems that you should
design a custom interface in VB.NET that allows a user to view the
report in some manner; but not actually have access to the report to
export it. I believe that an application can customize user access
much better.
Regards,
Enrique Martinez
Sr. SQL Server Developer|||Thanks EMartinez for your input.
When you say "VB.Net", are you refering to creating custom asp.net webpages
via vb.net, or are you suggesting the only way to accomplish my goal is to
move away from webpages all to gether?
Thanks
"EMartinez" wrote:
> labsRcool@.community.nospan wrote:
> > Is there anyway to disable mouse right click events in Reporting Services
> > Reports?
> >
> > I am using RS 2005.
> > On custom web pages, I can either use javascript/vbscript or set
> > oncontextmenu="return false".
> >
> > How can I accomplish the same results using Reporting Services?
> >
> > I've been searching and find no built-in property for my desired result. I
> > do have access to Visual Studio 2005, is there a custom way to provide what I
> > need using VB.Net or other method?
> >
> > I realize that even if possible, users can probably get around it, but at
> > least it will limit users from exporting data to Excel for example.
> >
> > Thanks!
> I also responded to your other posting. It seems that you should
> design a custom interface in VB.NET that allows a user to view the
> report in some manner; but not actually have access to the report to
> export it. I believe that an application can customize user access
> much better.
> Regards,
> Enrique Martinez
> Sr. SQL Server Developer
>|||On Mar 2, 5:10 pm, labsRc...@.community.nospan
<labsRcoolcommunitynos...@.discussions.microsoft.com> wrote:
> Thanks EMartinez for your input.
> When you say "VB.Net", are you refering to creating custom asp.net webpages
> via vb.net, or are you suggesting the only way to accomplish my goal is to
> move away from webpages all to gether?
> Thanks
> "EMartinez" wrote:
> > labsRc...@.community.nospan wrote:
> > > Is there anyway to disable mouse right click events in Reporting Services
> > > Reports?
> > > I am using RS 2005.
> > > On custom web pages, I can either use javascript/vbscript or set
> > > oncontextmenu="return false".
> > > How can I accomplish the same results using Reporting Services?
> > > I've been searching and find no built-in property for my desired result. I
> > > do have access to Visual Studio 2005, is there a custom way to provide what I
> > > need using VB.Net or other method?
> > > I realize that even if possible, users can probably get around it, but at
> > > least it will limit users from exporting data to Excel for example.
> > > Thanks!
> > I also responded to your other posting. It seems that you should
> > design a custom interface in VB.NET that allows a user to view the
> > report in some manner; but not actually have access to the report to
> > export it. I believe that an application can customize user access
> > much better.
> > Regards,
> > Enrique Martinez
> > Sr. SQL Server Developer
You should be able to use VB.NET to create custom web pages w/various
access levels.
Regards,
Enrique Martinez
Sr. SQL Server Developer|||Thank for your input.
I will attempt custom asp.net approach,
Thanks!
"EMartinez" wrote:
> On Mar 2, 5:10 pm, labsRc...@.community.nospan
> <labsRcoolcommunitynos...@.discussions.microsoft.com> wrote:
> > Thanks EMartinez for your input.
> >
> > When you say "VB.Net", are you refering to creating custom asp.net webpages
> > via vb.net, or are you suggesting the only way to accomplish my goal is to
> > move away from webpages all to gether?
> >
> > Thanks
> >
> > "EMartinez" wrote:
> >
> > > labsRc...@.community.nospan wrote:
> > > > Is there anyway to disable mouse right click events in Reporting Services
> > > > Reports?
> >
> > > > I am using RS 2005.
> > > > On custom web pages, I can either use javascript/vbscript or set
> > > > oncontextmenu="return false".
> >
> > > > How can I accomplish the same results using Reporting Services?
> >
> > > > I've been searching and find no built-in property for my desired result. I
> > > > do have access to Visual Studio 2005, is there a custom way to provide what I
> > > > need using VB.Net or other method?
> >
> > > > I realize that even if possible, users can probably get around it, but at
> > > > least it will limit users from exporting data to Excel for example.
> >
> > > > Thanks!
> >
> > > I also responded to your other posting. It seems that you should
> > > design a custom interface in VB.NET that allows a user to view the
> > > report in some manner; but not actually have access to the report to
> > > export it. I believe that an application can customize user access
> > > much better.
> >
> > > Regards,
> >
> > > Enrique Martinez
> > > Sr. SQL Server Developer
>
> You should be able to use VB.NET to create custom web pages w/various
> access levels.
> Regards,
> Enrique Martinez
> Sr. SQL Server Developer
>

Disable Rendering Extensions for some Reports

Hello everyone,
I have a question about Rendering Extensions in RS 2000.
I´d like to disable the Excel-Rendering Extension for some Reports. Is there
a way to do it on folder or Item-Level?
I only found the way to disable it by default for the hole Server in the
RSReportServer.config
Thanks in advanced,
MarcusNope, that is the only way (disabling sitewide). AFAIK, the same is true in
RS 2005.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Marcus Ross" <Marcus Ross@.discussions.microsoft.com> wrote in message
news:2887BBF9-2C4E-4EE1-B966-BB730A81443D@.microsoft.com...
> Hello everyone,
> I have a question about Rendering Extensions in RS 2000.
> I´d like to disable the Excel-Rendering Extension for some Reports. Is
> there
> a way to do it on folder or
Item-Level?
> I only found the way to disable it by default for the hole Server in the
> RSReportServer.config
> Thanks in advanced,
> Marcus|||Thanks for the answer.
I though about a workaround meantime. What about getting up pararlell
instances of RS. One with as example Excel-Rendering and one instance
without. This should work, shouldn´t?
"Bruce L-C [MVP]" wrote:
> Nope, that is the only way (disabling sitewide). AFAIK, the same is true in
> RS 2005.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Marcus Ross" <Marcus Ross@.discussions.microsoft.com> wrote in message
> news:2887BBF9-2C4E-4EE1-B966-BB730A81443D@.microsoft.com...
> > Hello everyone,
> >
> > I have a question about Rendering Extensions in RS 2000.
> > I´d like to disable the Excel-Rendering Extension for some Reports. Is
> > there
> > a way to do it on folder or
> Item-Level?
> >
> > I only found the way to disable it by default for the hole Server in the
> > RSReportServer.config
> >
> > Thanks in advanced,
> > Marcus
>
>

Disable pagination in HTML reports

Hi,
Is there any way to disable page breaks in HTML reports?
I have a long list and SSRS puts page breaks within report. I need the whole
report in one page.
I cannot put a large number for the report page height because I don't know
how big is my list and also I prefer to have pagination in PDF export
format.
Any help would be appreciated,
MaxHi Maxwell,
Welcome to use MSDN Managed Newsgroup Support.
If you put the Page Breaks in your Report Designer, by default, the HTML
Render will render pages as separate HTML pages.
If you want to see the report in a whole page, there is a way to do. In the
URL you use to access the report please add a Html Parameter like the
following:
http://servername/reportserver?/Sales/YearlySalesSummary&rs:Command=Render&r
s:Format=HTML4.0&rc:Toolbar=false
There, since the Toolbar does not display in the HTML Viewer, you will see
the whole report in a html Page.
Hope this will be helpful.
Sincerely,
Wei Lu
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.|||If you dont use grouping, it wont put pagination. When you export to excel
etc.. All the data's will be on a single sheet.
Amarnath
"Maxwell2006" wrote:
> Hi,
>
> Is there any way to disable page breaks in HTML reports?
>
> I have a long list and SSRS puts page breaks within report. I need the whole
> report in one page.
>
> I cannot put a large number for the report page height because I don't know
> how big is my list and also I prefer to have pagination in PDF export
> format.
>
> Any help would be appreciated,
> Max
>
>

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 local report cache

Does anyone know how to disable caching of local reports with
Reporting Services 2005?On Dec 9, 4:12 pm, lachlan.h...@.gmail.com wrote:
> Does anyone know how to disable caching of local reports with
> Reporting Services 2005?
This article should be helpful.
http://www.databasejournal.com/features/mssql/article.php/3695721
Regards,
Enrique Martinez
Sr. Software Consultant