Stifunction vlookup - Error messages

Stimulsoft Reports.NET discussion
Post Reply
MKA
Posts: 9
Joined: Thu Mar 09, 2023 9:10 am

Stifunction vlookup - Error messages

Post by MKA »

Dear

In an incident report I have two data sources:
* A json file with information of a particular incident (for ex incident code)
* Several master data tables with codes and descriptions

On my report, I would like to lookup the description of a specific code in the masterdata table and print it on the report.
I'm trying to do it with a StiFunction directly in a text field, but getting error messages. Can you please let me know what I'm doing wrong?

Are there better ways to do it without using a relation?

Best regards
Manuel
Attachments
Stifunctions error.png
Stifunctions error.png (314.35 KiB) Viewed 79 times
20250606 report.mrt
(215.96 KiB) Downloaded 6 times
Lech Kulikowski
Posts: 7259
Joined: Tue Mar 20, 2018 5:34 am

Re: Stifunction vlookup - Error messages

Post by Lech Kulikowski »

Hello,

Please check the correct arguments for the VLookup function.

Thank you.
Attachments
Screenshot 2025-06-11 231114.png
Screenshot 2025-06-11 231114.png (115.4 KiB) Viewed 69 times
MKA
Posts: 9
Joined: Thu Mar 09, 2023 9:10 am

Re: Stifunction vlookup - Error messages

Post by MKA »

Dear Lech

Thank you very much, it works finally!
Lech Kulikowski
Posts: 7259
Joined: Tue Mar 20, 2018 5:34 am

Re: Stifunction vlookup - Error messages

Post by Lech Kulikowski »

Hello,

You are welcome.
Post Reply