So it doesn't look like the permissions are this granular. I basically told the end-users to be careful when managing reports. At least I can lock down permissions...

Would this be a matter of adding TOP 5 to the SQL statement?

Something like

SELECT TOP 5 fieldname1, fieldname2 FROM tablename

Glad you got it working! Thanks for letting us know.

What happens if you wrap the expression in the CDate function? Like:

=CDate(Format(DateAdd("d", -1, now()),"dd/MM/yyyy"))

Here is a list of the popular date calculations:

First Date of last month: =Format(DateAdd("m", -1, DateSerial(Year(Now()), Month(Now()), 1)),"dd/MM/yyyy")

Last date of last month: =Format(DateAdd("d", -1, DateSerial(Year(Now()), Month(Now()), 1)),"dd/MM/yyyy")

First date of current...

Have you tried to recreate the line chart in 2008 to see if you get the same "cropped" result? This will tell you if it's a data problem or...

This is a tough one. I'm sure someone will have a better answer as I am just guessing. It doesn't look like the chart is being cropped per...

Hey J -

Just curious... how did you solve this?

Mike

Is there any chance you could take a screenshot of the cropped line chart? Without seeing it, it's going to be difficult to recommend options.

Thanks!

Mike

Glad you figured it out. Thanks for letting us know!

Mike

Could you use the ISNULL function like:

...and (YearVal In (ISNULL(@CalYear, 0)) or FYearShortVal In (ISNULL(@SalesYear,0)))

Did you figure this out? I am curious to know what happened.

Mike

I've had this problem for years with web application development. Adding a single apostrophe (') is the best option. Unfortunately, Excel will always attempt to format the data...

Sounds like there is no love for SSRS 2008. Bummer!

Do you have grouping on the report itself? If you have Row Grouping on the field, this will show the SUM (or whatever aggregate you want) at the bottom...