SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Total field outside of scope
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

tech2
Starting Member

37 Posts

Posted - 03/29/2013 :  11:28:19  Show Profile  Reply with Quote
SSRS Report Builder 3.0 2008 R2

I'm getting the message below when I try to total my 'ExtendedOverCurrentMax' field.

The Value expression for the textrun ‘Textbox2.Paragraphs[0].TextRuns[0]’ has a scope parameter that is not valid for an aggregate function. The scope parameter must be set to a string constant that is equal to either the name of a containing group, the name of a containing data region, or the name of a dataset.

=Sum(Fields!ExtendedOverCurrentMax.Value,InventoryTurnover)

'InventoryTurnover' is my dataset and 'Tablix4' is my date region.

Thanks,

visakh16
Very Important crosS Applying yaK Herder

India
52309 Posts

Posted - 03/29/2013 :  13:43:30  Show Profile  Reply with Quote
try

=Sum(Fields!ExtendedOverCurrentMax.Value,"InventoryTurnover")

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

tech2
Starting Member

37 Posts

Posted - 03/29/2013 :  15:33:58  Show Profile  Reply with Quote
Thanks for the response. Below is the ERROR, when I tryed your expression.

The Value expression for the text box ‘Textbox2’ refers to the field ‘ExtendedOverCurrentMax’. Report item expressions can only refer to fields within the current dataset scope or, if inside an aggregate, the specified dataset scope. Letters in the names of fields must use the correct case.

quote:
Originally posted by visakh16

try

=Sum(Fields!ExtendedOverCurrentMax.Value,"InventoryTurnover")

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/



Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52309 Posts

Posted - 03/30/2013 :  01:56:37  Show Profile  Reply with Quote
is ExtendedOverCurrentMax within dataset which is bound to your table where you used the expression?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

tech2
Starting Member

37 Posts

Posted - 03/30/2013 :  10:29:45  Show Profile  Reply with Quote
No, I inserted a colunm to the right of my table. All the extended totals are calculating across but I'm trying to get the Grand Total at the bottom.

Thanks,

quote:
Originally posted by visakh16

is ExtendedOverCurrentMax within dataset which is bound to your table where you used the expression?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/



Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52309 Posts

Posted - 03/30/2013 :  13:07:55  Show Profile  Reply with Quote
you didnt answer my question. Is ExtendedOverCurrentMax field returned by dataset?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

tech2
Starting Member

37 Posts

Posted - 04/01/2013 :  08:44:28  Show Profile  Reply with Quote
I thought I did answer your question. I created a calclated field by adding a field to the right of my table. Do you call that Bound? I'm new to Report Builder.


quote:
Originally posted by visakh16

you didnt answer my question. Is ExtendedOverCurrentMax field returned by dataset?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/



Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52309 Posts

Posted - 04/01/2013 :  09:58:31  Show Profile  Reply with Quote
I created a calclated field by adding a field to the right of my table
You mean in dataset or adding a column and using expression in report area?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

tech2
Starting Member

37 Posts

Posted - 04/03/2013 :  11:08:59  Show Profile  Reply with Quote
I added the calculated field in the 'Report Area'

I'm just extending the cost times the qty. across by location and trying to get a total at the bottom.

Thanks for your patience

quote:
Originally posted by visakh16

I created a calclated field by adding a field to the right of my table
You mean in dataset or adding a column and using expression in report area?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs



Edited by - tech2 on 04/03/2013 11:22:48
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52309 Posts

Posted - 04/03/2013 :  13:56:21  Show Profile  Reply with Quote
ok...can you try this instead

=Sum(Fields!ExtendedOverCurrentMax.Value,"Tablix4")

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

tech2
Starting Member

37 Posts

Posted - 04/05/2013 :  12:37:06  Show Profile  Reply with Quote
Thanks for the coninued support. Below is the ERROR message. when using =Sum(Fields!ExtendedOverCurrentMax.Value,"Tablix4")

The Value expression for the text box ‘Textbox2’ refers to the field ‘ExtendedOverCurrentMax’. Report item expressions can only refer to fields within the current dataset scope or, if inside an aggregate, the specified dataset scope. Letters in the names of fields must use the correct case.

Thanks,

quote:
Originally posted by visakh16

ok...can you try this instead

=Sum(Fields!ExtendedOverCurrentMax.Value,"Tablix4")

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs


Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52309 Posts

Posted - 04/09/2013 :  01:15:39  Show Profile  Reply with Quote
then i'm sure the field itself is not present in the dataset you created

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.12 seconds. Powered By: Snitz Forums 2000