Hi Expert,
I need you guys suggestion about my problem.
Im making a SSRS Report and the report using 2 datasets and 2 design.
Every report contain 2 datasets.
Above is the Summary design, the report using 2 datasets, and every datasets Im adding table and group it by Account Number.
Below is the result of the report, number 1-4 is the dataset 1 and from the second number 4 is the result of the dataset 2.
In the dataset 1 Im using this code
=RunningValue(Fields!PIL_AkunNumber.Value, CountDistinct, "Vendor_DS")
and in the dataset 2 Im using the same code Im using for dataset 1, so the result showing number 4 repeatedly.
If Im using this code below for dataset 1
=RunningValue(Fields!PIL_AkunNumber.Value, CountDistinct, "Vendor_DS")
and using this code below for dataset 2
=RunningValue(Fields!PIL_AkunNumber.Value, CountDistinct, "Journal_DS")
Here is the result
I need to make the row number repeat continuously 1,2,3,4,5,6,7,8 not 1,2,3,4,1,2,3,4 or 1,2,3,4,4,4,4,4
Is there any possibilities to make report according to my requirement ?
Please tell me if you guys have any idea, I've tried some research on the internet and still not found something helpful.
Regards,
Enggar
