Store Months of the year in a variable

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi all,

I just wanted to ask if it is possible to store the months of the year in a variable and loop it inside a matrix table defined in my customized report.

It would look like this.

4010.1.png

this is my layout for the report in rdlc.

7633.123.jpg

I don't know how to do it. but my desired output would be like the screenshot on the top.

and for the variable that i'm saying .

i decalred a variable Months. with the datatype of Date.

is this okay?

thank you for anyone who helps me on this.

*This post is locked for comments

All responses (7)

Answers (2)

Verified answer

Binesh 7,885 on at

Like (0)

Report

RE: Store Months of the year in a variable

You need to declare all Like:

DataItem DataSource Name

Column Month[1] January

Column Month[2] Feburary

-------

Column Month[12] December
Community Member Microsoft Employee on at

Like (0)

Report

RE: Store Months of the year in a variable

Do i need to put the whole array of the month under Customer Item Ledger Entry.

or just the variable of Month?
Binesh 7,885 on at

Like (1)

Report

RE: Store Months of the year in a variable

Under Customer Item Ledger Entery.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Store Months of the year in a variable

Hi Binesh,

This is the Report Design

and this is the layout
Suggested answer

Binesh 7,885 on at

Like (0)

Report

RE: Store Months of the year in a variable

Hello,

After ItemNo. create all. for better result plz add screenshot of Report Design & RDLC both, so we can look.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Store Months of the year in a variable

Hi Binesh,

where do i need to put the Dataset to call the values in my layout
Verified answer

Binesh 7,885 on at

Like (0)

Report

RE: Store Months of the year in a variable

Hello,

Just simply create a YearVar as a Option dataType and & Month Variable Text Datatype with dimension 12 and write the code for updating the column.

For more details see the below screenshot.