Show all months even if i have data for 2 months

[saumyashah90]

I have 2 months Data for Nov and Dec

But on UI i want to see all months(in a listbox).

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

when i click on nov dec data should change but when i click on others no data display

[gautik92]

oops sry i dint see that list box in that brackets

then yu should use master calendar

[sasikanth]

hi,

please find the attachment

[Gabriel]

Hi,

Do you have Calendar Table created in your Data Model.

I supposed if you have the Calendar Table, you can simply show your Month in List Box from Calendar table.

[saumyashah90]

calendar table i will make from date column.but i have data for 2 months only

[tamilarasu]

Hi Samya,

In the below attachment, I have created ID for two months and created a master calendar by using year start and year end functions. I have linked both the tables with Date field. So If you have ID for the selected month, it will  be filtered automatically. Let me know.

[sasikanth]

hi,

did u check my attachment

[saumyashah90]

yup there was a format problem