RDLC Report

Question

Hello,

I am having data as below in my dataset

1234 DEFG 100

1234 DEFG 133

and i want to show data in rdlc as below

1234 DEFG  233

         DEFG

i have used group property for grouping 1234 but how to add 3rd column for the group please help

Answer 1

um just sum(yourvariable)  ?

Answer 2

Hello,

Thanks for the quick response.sum will give the sum of complete column i want sum based on group.

i have used sum(Fields!Variable.value,"Group1")

but the resulting rdlc report is as below

1234 DEFG 233

         DEFG 233

i want the result to be as

1234 DEFG 233

         DEFG

Answer 3

Don't get dataset which are equal to the whole table in the database. 

While testing with a new database this gives still usable results. As soon as the database is used more everything goes to slow. 

Use a good SQL Transact Select string to select the data you need for reports.

---

Success
Cor

Answer 4

I can expect one row to come out of the two rows above as grouped, but what is the second row that you want in the reuslt as DEFG only?

1234 DEFG 233

         DEFG  ??

---

Fouad Roumieh

Answer 5

I want second row as empty.

Answer 6

Then Cor's suggestion should work for you, a simple t-sql query like below will do this job:

SELECT Col1, Col2,  SUM (Col3)
FROM Table
GROUP BY Col1, Col2,Col3;

Are you loading data from DB via t-SQL?

---

Fouad Roumieh

Answer 7

No,I am using postgreSQL in my case.Please suggest if it is possible through expression.

Answer 8

The group by option is available vai postgreSQL also

You can do that via the report wizard by simply applying the below configuration, let's say I have 3 columns in my DT and I want to group by Summation of Total column:

---

Fouad Roumieh

Answer 9

And that will create for you a report as below:

---

Fouad Roumieh