cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
elodie_2891
Regular Visitor

Report builder : total of several SUM from several datasets

Hello everybody,

 

My problem and request are for REPORT BUILDER.

In order to do a total of several SUM from several datasets,  I have 2 requests :

1- How to call an already created textbox (textebox32) in another Text Zone ? 

I tried this, but it doens't work : =Fields!Textebox32.Value 

I also tried this : =Fields!Textebox32.Value, "dataset1"

2- I want to do the total of several SUM from several datasets, how to do ?

I have 3 sums, and i want to do a total : 

sum(Fields!deduction_1.Value, "Dts_dataset1")

sum(Fields!deduction_2.Value, "Dts_dataset2")

sum(Fields!deduction_3.Value, "Dts_dataset3")

 

I think if I can call the 3 textboxes (my first request), then I could do the sum ?

Thanks everybody 🙂

1 ACCEPTED SOLUTION
d_gosbell
Super User II
Super User II


@elodie_2891 wrote:

Hello everybody,

 

My problem and request are for REPORT BUILDER.

In order to do a total of several SUM from several datasets,  I have 2 requests :

1- How to call an already created textbox (textebox32) in another Text Zone ? 

I tried this, but it doens't work : =Fields!Textebox32.Value 

I also tried this : =Fields!Textebox32.Value, "dataset1"

 


Fields refers to items in datasets, to reference a text box you would use the ReportItems collection

 

eg.   ReportItems!Textebox32.Value

 

So you should be able to do something like ReportItems!Textebox32.Value  + ReportItems!Textebox33.Value

 

Note, you can rename textboxes. If I am going to reference a text box in another expression I will usually rename it to something like txtTotalSales and txtTotalTax - it makes it much easier to understand what you were doing if you have to come back later and alter the report when you read:

    ReportItems!txtTotalSales.Value  + ReportItems!txtTotalTax.Value

 

instead of something like:

    ReportItems!Textebox32.Value  + ReportItems!Textebox33.Value

View solution in original post

1 REPLY 1
d_gosbell
Super User II
Super User II


@elodie_2891 wrote:

Hello everybody,

 

My problem and request are for REPORT BUILDER.

In order to do a total of several SUM from several datasets,  I have 2 requests :

1- How to call an already created textbox (textebox32) in another Text Zone ? 

I tried this, but it doens't work : =Fields!Textebox32.Value 

I also tried this : =Fields!Textebox32.Value, "dataset1"

 


Fields refers to items in datasets, to reference a text box you would use the ReportItems collection

 

eg.   ReportItems!Textebox32.Value

 

So you should be able to do something like ReportItems!Textebox32.Value  + ReportItems!Textebox33.Value

 

Note, you can rename textboxes. If I am going to reference a text box in another expression I will usually rename it to something like txtTotalSales and txtTotalTax - it makes it much easier to understand what you were doing if you have to come back later and alter the report when you read:

    ReportItems!txtTotalSales.Value  + ReportItems!txtTotalTax.Value

 

instead of something like:

    ReportItems!Textebox32.Value  + ReportItems!Textebox33.Value

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.