Hi @Madelyn_SAS ,
I am using version 8.5.1 (SAS Viya V.03.05) and values are chosen from drop-down list.
In general it looks in the following way:
I have a drop-down list with DATE values ('2022-05', '2022-06', '2022-07'), listing table with current report (when I select '2022-05' I print values for May, when I select '2022-06' I print values for June and so on), and I need to create headline with values from another table:
when I select '2022-05' I should print Report for: '2022-05' Report name: Some sample title
when I select '2022-06' I should print: Report for: '2022-06' Report name: Another sample title
For headline I am using multidimentional table and it looks quite good. But unfortunately there is automaticaly added measure with counts, and when I delete this measue the headline looks like typical database table.
Here is a sample "data model":
TABLE WITH VALUES FOR HEADLINE
DATE
NAME_OF_REPORT
VERSION_OF_REPORT
2022-06
Report One
v.6
2022-07
Report Two
v.6_1
TABLE WITH VALUES
DATE
SOME_CATEGORY
SOME_MESURE
2022-06
OneTwo
423
2022-06
ThreeFour
241
2022-06
FiveSix
543
2022-06
SevenEight
42
2022-07
NineTen
543
2022-07
ElevenTwelve
656
Report, when I choose 2022-06 from drop down list:
Name of report
Report One
Version of report
v.6
DATE
SOME_CATEGORY
SOME_MESURE
2022-06
OneTwo
423
2022-06
ThreeFour
241
2022-06
FiveSix
543
2022-06
SevenEight
42
Report, when I choose 2022-07 from drop down list:
Name of report
Report Two
Version of report
v.6_1
DATE
SOME_CATEGORY
SOME_MESURE
2022-07
NineTen
543
2022-07
ElevenTwelve
656
Regards,
Filip
... View more