Automatically Regenerate on Depending on parameter input

Hello,
Is there a way to get the reports to automatically regenerate when a user
changes a drop down or selects a radio button?
Thanks
DylanOn Feb 20, 11:45 am, Dylan <D...@.discussions.microsoft.com> wrote:
> Hello,
> Is there a way to get the reports to automatically regenerate when a user
> changes a drop down or selects a radio button?
> Thanks
> Dylan
As far as I know, there is not a way to do that; unless, you are
embedding the report in an application, whereas, you can call a
refresh of the report on a given event.
Regards,
Enrique Martinez
Sr. ASP.NET/SQL Server Developer|||By giving "default value" the report runs automatically (rather pretend to
run, infact it substitutes the values) Otherwise you have to click on view
report to see the report. other option is to write custom code..
Amarnath
"Dylan" wrote:
> Hello,
> Is there a way to get the reports to automatically regenerate when a user
> changes a drop down or selects a radio button?
> Thanks
> Dylansql

Automatic scaling of charts

Is there any way to use expressions or whatever to automatically scale the Y-axis of a chart depending on the data. It looks like everything is hard coded in reporting services especially the chart and you would hard code the max and min values at certain range. This is ridiculous! Is there any way that I can set the max and min values depending on the data, so that when a chart goes up to 600% it doesn't have to show 1000% or when there is no minus (-) numbers, it doesn't have to show -500% in the chart. Can I use expression the max and min windows or is the chart smart enough to bring a decent chart depending on the data without any hardcoded limits, settings, intervals, etc.?

This is ridiculous. Any help is appreciated.

Thanks,

Enkh.

Just leave the min/max settings blank and the axis will autoscale.

Furthermore, in RS 2005 you can use expressions to dynamically calculate min/max/etc. axis settings.

-- Robert

|||

It's not automatically scaling to the right size. For example what I'm seeing is that the max chart is 600%, but the chart is setting the max to 1000% that is too much. Plus the chart is calculation between columns.

Enkh.

|||

I guess it would help if you could post a simple report example (e.g. based on Northwind data or AdventureWorks data) that demonstrates the issue you are experiencing.

-- Robert

Auto Sizing the Page Header

Is there a way to auto-size the height of the page header depending on it's
contents?
For example, I have created a page header with a logo that appears on the
first page (1 inch x 1 1/2 inches) as well as my report title. But on
consecutive pages only the title shows and the image gets surpressed. I
would like to see the header contract in size on consecutive pages so that
only the report title fits at the top in an effort to conserve page real
estate.
Is this possible?
Thanks,
LisaNo. The page header height is set at design time and cannot be modified at
runtime.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Lisa" <Lisa.Lambert@._nospam_etalk.com> wrote in message
news:%23jr%23nYuWEHA.3476@.tk2msftngp13.phx.gbl...
> Is there a way to auto-size the height of the page header depending on
it's
> contents?
> For example, I have created a page header with a logo that appears on the
> first page (1 inch x 1 1/2 inches) as well as my report title. But on
> consecutive pages only the title shows and the image gets surpressed. I
> would like to see the header contract in size on consecutive pages so that
> only the report title fits at the top in an effort to conserve page real
> estate.
> Is this possible?
> Thanks,
> Lisa
>

auto resizing column

hi all

i am working on sql reorting 2005

how can i set the column width to autoresize depending on the maximum length of data for that column?

plz help me.

As far as I know, there is no way to autoresize column width. The only property to account for adjusting a cell's dimensions is "CanGrow." If this is set to True, the cell will increase vertically to fit all the data. However, this only adjusts the height and not the width.