Convert RDLC to Stimulsoft and dynamic columns

[had1223]

I want to convert report from rdlc to stimulsoft
There is only 1 datasource in rdlc

I will explain the rdlc report in attached image:
- Data is grouped by EntryDate, then "Transaction details area" grouped by Id (rdlc row grouping), "VTypes area" grouped by VTypeId (rdlc row grouping), "Dynamic Coumns" grouped by ACTypeId (rdlc column grouping)
Sample of 1 record in rdlc:
We call each record in data is "Transaction":
Transaction:
- Date
- Ref
- Name
- Id
- EntryDate
- VTypeId
- VtypeValue
- VtypeName
- ACTypeId
- ACTypeName
- ACTypeValue
You can ignore first 3 properties because they do not affect to calculation
Sample data:
(Id: 1, EntryDate: 04/2024, VTypeId: 1, VtypeName: "VType Name 1", VtypeValue: 4.5, ACTypeId: 1, ACTypeName: "ACType1", ACTypeValue: 150)
(Id: 2, EntryDate: 04/2024, VTypeId: 1, VtypeName: "VType Name 1", VtypeValue: 4.5, ACTypeId: 2, ACTypeName: "ACType2", ACTypeValue: 200)
(Id: 3, EntryDate: 04/2024, VTypeId: 3, VtypeName: "VType Name 3", VtypeValue: 5, ACTypeId: 1, ACTypeName: "ACType1", ACTypeValue: 100)
(Id: 4, EntryDate: 05/2024, VTypeId: 3, VtypeName: "VType Name 3", VtypeValue: 5, ACTypeId: 2, ACTypeName: "ACType2", ACTypeValue: 100)

"Transaction details area" will show detail of transaction, ACType Columns are dynamic
"VTypes area" will sum VtypeValue of Transactions that belong to EntryDate for each VType

My solution is:
Make new EntryDate datasource, it is parent DataBand, and in each EntryDate:
Transaction datasource to display in "Transaction details area"
TransactionCopy datasource to display in "VTypes area", group them by VTypeId
ACType dynamic columns, I dont know how to do that
ACType dynamic columns included in both "Transaction details area" and "VTypes area". And please take notice on last total row of "Transaction details area" - I also have no solution for it.
Take a look on sample data above:
In "Transaction details area", 1 record has only 1 value in 1 ACType cell (other ACType cells will be empty) , but in "VTypes area", for example "VType Name 3" may has value on "ACType1" cell and "ACType2" cell

Give me advices, solutions or anythings else to solve them please.
Its fine to ignore my solution if u have a better idea to convert my rdlc to stimulsoft.
(Its better if you send me mrt file for your solution, im just a newbie in stimulsoft)
Please let me know if you need anything else.
RDLC report:

Untitled.png (29.4 KiB) Viewed 5717 times

[Lech Kulikowski]

Hello,

Please try to use the Cross-Data component on the databand for dynamic columns.

Thank you.

[had1223]

Thanks,
I have used Cross-Data, but it does not work.
In my attached mrt file, I added 2 cross-data bands in "GroupHeaderBand2" to fill data, position: after "VTypeValue" cell, but it does not work, so I remove them.
Could you please review my mrt and point me the way to make it works.

[had1223]

Hello,

Please try to use the Cross-Data component on the databand for dynamic columns.

Thank you.

Hello, could you please help me?

[Lech Kulikowski]

Hello,

What product and version are you use?

Thank you.

[had1223]

Hello,

What product and version are you use?

Thank you.

Hello,
Im using Stimulsoft "Version 2020.5.2 from 26 November 2020, ASP.NET, JS".

[Lech Kulikowski]

Hello,

Please send us your request with a detailed description on support@stimulsoft.com. We will try to find a solution for you.

Thank you.

[had1223]

Hello,

Please send us your request with a detailed description on support@stimulsoft.com. We will try to find a solution for you.

Thank you.

Hello,
I have sent a request to support@stimulsoft.com, check it please.

Thanks.

[Lech Kulikowski]

Hello,

Ok. We will reply to you by email.

Thank you.