You can query an SSAS cube directly using SSRS 2008 R2.

@penelson

re:

=((Sum(Fields!field3.Value) / Sum(Fields!field1.Value) * 10 + Sum(Fields!field4.Value) / Sum(Fields!field1.Value) * 10 + Sum(Fields!field5.Value) / Sum(Fields!field1.Value) * 10 + Sum(Fields!field6.Value) / Sum(Fields!field1.Value) * 10) - (Sum(Fields!field7.Value) / Sum(Fields!field2.Value) * 10 +...

I don't believe there is a Format function in Oracle SQL for datetime fields.

If your released_date field is already a datetime type, you should not need to enter a format...

I haven't tried this, but try the solution provided here:

http://www.theruntime.com/blogs/thomasswilliams/archive/2008/09/29/hiding-and-showing-columns-based-on-a-parameter-in-reporting.aspx

jacksoncc

Alternative - you do not have to place a group within a group to accomplish this. Instead:

To the blank report, add a List box large enough to include all...

I don't believe you can include global variables, like page number in a table footer. SSRS does not apper to allow you to start page numbering based on anything...

Here's the expression you can add to a text box placed in the header or footer:

="Page " & Globals!PageNumber & " of " & Globals!TotalPages

Have you tried adding a text box to your list, with the desired header info?

jc

Try adding substring function to your date conversion before you add the to_number conversion, then perform your numeric operation, and filter on this new field:

to_number(

SUBSTR(TO_CHAR(SYSDATE, 'dd/mm/yyyy'),'dd/mm/yyyy'),1,2)

...

Try adding an expression on the textbox font properties - FontWeight property (SSRS 2005).

Something like:

=Iif(Fields!FIELD.Value= "1","Normal","Bold")

jc

I'm sure you have moved on beyond this problem by now. However my users often report this phenomenon when the body dimensions extend (are wider than) the report layout...