Passing Option Value to Report

Pinkycz · 2018-05-31

Hi, I wonder if there is a quick way to pass an option values as number to the report.... The thing is, SSRS reports has some show row/cell logic that is trigerred by the option value ie. "Line Type"::Item, this passes value "Item" into the dataset and works ok in English language.
But when user switches language, the option gets passed as the translated (eg. "Artikel") so show/hide logic trips over there.

I could write a short code CASE OF but wonder if there is easier, more elegant way of doing it... pass option values 0,1,2 the logic in report is then language independent...

Any ideas??

Slawek_Guzek · 2018-05-31

Assing (in OnAferGetRecord) the "Line Type" value to some integer var, and add this integer to your Data Items.

A step further would be to use RecordRef/FieldRef and getting an option string text, and add this as a dataitem. It is better imho to have a meaningful text (like 'Item', 'Resource') rather than just 0,1,2,3..

Something like this perhaps:

LineTypeInt := "Line Type";
RecordRef.GETTABLE(yourDataItemTable)
FieldRef := RecordRef.FIELD("Line Type" field number);
LineTypeText = SELECTSTR(LineTypeInt+1, FieldRef.OPTIONSTRING);
RecordRef.CLOSE;

and then include the LineTypeText in your data item.

Slawek_Guzek · 2018-05-31

Assing (in OnAferGetRecord) the "Line Type" value to some integer var, and add this integer to your Data Items.

A step further would be to use RecordRef/FieldRef and getting an option string text, and add this as a dataitem. It is better imho to have a meaningful text (like 'Item', 'Resource') rather than just 0,1,2,3..

Something like this perhaps:

LineTypeInt := "Line Type";
RecordRef.GETTABLE(yourDataItemTable)
FieldRef := RecordRef.FIELD("Line Type" field number);
LineTypeText = SELECTSTR(LineTypeInt+1, FieldRef.OPTIONSTRING);
RecordRef.CLOSE;

and then include the LineTypeText in your data item.

Pinkycz · 2018-05-31

Hi Slawek,

thanks for your sugegstion, never used RecordRef or FieldRef but this should work with 5 lines of code, I had 8 wsuing CAse and passing a language independent value to the dataset for report logic to work. Used integer in my case but agree it is easier with text.

Will try to rework my solution and get more familiar with this approach, Thx!

Passing Option Value to Report

Best Answer

Answers

Categories