Hi, i've created a report based on a table. The table stores 3 main components.
PeriodId
YearId
MiscInfo
what I'm doing is passing in the PeriodId from a parameter. I would then like to be able to select all data from table which has a periodid <= parameter AND the yearid the same as the yearid of the periodid derived from the parameter.
I thought this would be simple but i could do with some help!
Thanks,
Noel
PeriodId
YearId
MiscInfo
what I'm doing is passing in the PeriodId from a parameter. I would then like to be able to select all data from table which has a periodid <= parameter AND the yearid the same as the yearid of the periodid derived from the parameter.
I thought this would be simple but i could do with some help!
Thanks,
Noel