CODEWITHSUNDEEP
ssrs-tablix
Angelika
Angelika

Reputation: 1

I have two tablix in ssrs report.I am using the same dataset for first tablix which shows details second shows

There are two tablix in ssrs report. I am using the same dataset for both tablix. First tablix which shows JOB details and $amnt BY Date (5 month worth of data) and second tablix shows records Grouped by Job and total of $amonts from tablix1. Tablix 2 shows correct $Sum but for some records there are duplicate rows- if Tablix#1 has more than 1 $amnt.

Example Tablix1: ProjectABC - 1/1/2019 =$2 ; 1/5/2019=$5
                 ProjectHTG -1/1/2019 =$3

Exampl  Tablix2: ProjectABC -$7
                 ProjectABC -$7
                 ProjectHTG -$3

how do i modify my expression "=sum(Fields!units.Value,"project2")" to print "ProjectABC -$7" as one line?

Upvotes: 0

Views: 1340

Answers (1)

Hannover Fist
Hannover Fist

Reputation: 10880

Assuming that your field name if JOB for the project, you would add the field along with the dash to your current expression.

You should NOT group by amount if you want to SUM the amount. You are getting a separate line for each different amount for the same JOB. Only JOBs with the same amounts will be SUMmed as one.

=Fields!JOB.Value & " - " & sum(Fields!units.Value)

A few other issues:

Why are you using the Dataset name in your SUM? It sounds like you have a simple table that groups by JOB and Amount. The table is associated to the Dataset that you want to use. You should only use the dataset name in a table when you're referring to a different dataset than the table is using.

Why do you need two datasets if they have the same info? The second table can do the grouping and summing (and already is) from the same dataset as the first table.

Upvotes: 0

Related Questions