Changing the Chart Legend Labels

Hi,
I am new to SSRS report development. Would like to know whether it is
possible to change the label display for the chart legend. Currently the
legend text populated based on the data in the dataset, not sure whether we
can change that.
ThanksCurrently we dont have any option to do that.I think you can Expect in
2008.Lets see
Thanks
Raj Deep.A
On Apr 23, 12:33=A0pm, "Thalia Mei" <thalia...@.gmail.com> wrote:
> Hi,
> I am new to SSRS report development. Would like to know whether it is
> possible to change the label display for the chart legend. Currently the
> legend text populated based on the data in the dataset, not sure whether w=e
> can change that.
> Thankssql

changing subtotal expression

Hello,

I'm using a matrix report to display scores for certain items on certain criteria.
The items are on the left and the criteria at the top.

Now I would like to have some sort of subtotal row at the end of each group of items that displays the average value of all the scores for that group and not simply adds up the scores.
The built-in subtotal just adds up the scores, where I want the average value to be displayed.

Isn't there an easy way to change the subtotal expression and make it calculate the average value instead of the sum?

Thank you for your time,

Kenny

Yes this can be done through the InScope function. Please read this related thread: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=276213&SiteID=1

-- Robert

Changing PageHeight dynamically

My requirement is to have my report display on one 11 by 8.5 page. Is there a way to programmatically change the PageHeight report property based on the number of rows returned in a table? i.e., if the rowcount for table x >= 10, change PageHeight to 9.5.

Any ideas?

Thanks.

Brad

Is there anyway to achieve this?|||

Not really but you can use the next size or change the orientation of your report but before you do that run test copies through either preview or Reportveiwer depending of your choice for display and printing. Here is what I know there is an interactive height setting which you can use to reduce the size so maybe you can use it to increase it. Try the link below for details.

http://blogs.msdn.com/bwelcker/archive/2005/08/19/Alien-Lanes-_2800_Logical-and-Physical-Pagination-Rules_2900_.aspx

Changing Object Explorer Details Window

is it possible to change the columns that display in the Object Explorer
Details Window? I'd like to be able see some Extended Properties in this
window.
TIA
Dean
Nope...sorry but that's not an option.
-Sue
On Fri, 10 Aug 2007 09:51:26 -0400, "Dean"
<deanl144@.hotmail.com.nospam> wrote:

>is it possible to change the columns that display in the Object Explorer
>Details Window? I'd like to be able see some Extended Properties in this
>window.
>TIA
>Dean
>

Changing language helps ( rrRenderingError) but.....

I want to display my reports in dutch.
Of what is the language dependent? server properties ?
Can you explain how the export to PDF-format effects the report-language
properties and/or serverproperties ?
Thanks in AdvanceLanguage is a Report property.
Open the Properties window (F4), and select 'Report' from the dropdown list.
Language is the second-last property displayed.
If you set it to Dutch, functions like Month() will return Dutch month names.
My 2c.
Flip
"Bobby" wrote:
> I want to display my reports in dutch.
> Of what is the language dependent? server properties ?
> Can you explain how the export to PDF-format effects the report-language
> properties and/or serverproperties ?
> Thanks in Advance
>
>
>

changing images on the fly

I am building an app to print Recipes and I need to display a different picture for each dish

The Database is Access 97 which is fine and I want to keep my images in a seperate folder on the users PC

like "C:\RecipePictures\Soup.jpg"

I have tried using an embedded, External and Database sources and cannot get any to do what I want has anybody got any ideas please

I guess I realy want to use external but it won't accept C:\RecipePictures\Soup.jpg it is looking for a URL

any help gratefully received

You need to make sure the path to your images is located under your web root. Assume your web root is c:\inetpub\wwwroot, then you need to put the RecipePictures folder in wwwroot (or a subfolder to wwwroot). Or you could create a virtual directory under wwwroot that points to C:\RecipePictures. You create a virtual directory in the IIS manager (MMC). Good luck!

|||

if the DB has the path to the image, you can have the picture in the report as expression "file://" & {the path to the imge}

that may bring the picture in.

Best solution is to do everything in SQLserver express its free! and you can have pictures in the DB

|||

thanks I will have a play with that

the problem is that my users are strictly non technical and the picures will be saved where they are saved, I have struggled to get them to save them with english names

|||

Thanks, sounds good

the access Database is a legacy thing and I may move to SqlServer but these guys are working on the road so we currently use replication through their company VPN if we added images, most are over 1meg, the syncro would be horrendous (they use 3G when they don't have wireless)

|||

OK FYI

I set the source to External

the Value to +"Fill://"+Fields!Photolocation.Value //Text field in Access DB holding the path and name of the image like C:\Recpe pictures\Soup.jpg

the MimeType was empty

this means that each record can have it's own image

|||

sorry an error should be ="File://" NOT +"Fill://"

I set the source to External
the Value to ="File://"+Fields!Photolocation.Value //Text field in Access DB holding the path and name of the image like C:\Recpe pictures\Soup.jpg
the MimeType was empty

this means that each record can have it's own image