Do a search for a record in reportextension

(0) Share

Report

Posted on by Josue Morales

Hello All.

I have a problem I hope you can help me.

What I want to do is make an extension of a report where depending on whether the field is true or false, it puts a certain image.

1.-The field is taken from the provider file (of an extension).
2.- The report is 402
3.-The image was taken from the company information (same with an extension)
The procedure is the next:
From purchase orders you execute the 402 report located in
Actions -> Publication -> Test report here I want to know if the provider has the boolean field activated and put the corresponding image

Thanks. ReportExtension VendorCard ExtensionImageCompany

All responses (3)

Answers (1)

Sort by

Suggested answer

JAngle 159 on at

Like (0)

Report
Copy link

Link copied!

So if the field from the vendor is true calculate a specific image?

The if statement need’s altering in that case. Something like below.

If vendor.get(“Buy-From Vendor No.”) then begin

If vendor.changeimage then

CompanyInfo.calcfields(image1)

else

CompanyInfo.calcfields(image2);

You have already declared the images as columns so it is more about getting the binary data into the column variables.

This also feels like wasted effort as you can achieve a similar result with no development. On a vendor you have document layouts which act as an override to the standard. It would mean not having a dynamic image but how often do they really change.
Verified answer

YUN ZHU 103,227 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi, I agree with Josh, it looks like you're missing a part of the calculation.

Below is an example of report 1305 "Standard Sales - Order Conf."

Hope this helps.

And, you can also add iif condition in rdlc expression.

https://docs.microsoft.com/en-us/sql/reporting-services/report-design/expression-examples-report-builder-and-ssrs?view=sql-server-ver16#DecisionFunctions

Hope this helps as well.

Thanks.

ZHU
Josue Morales 30 on at

Like (0)

Report
Copy link

Link copied!

Thank you for replying

the image change depends on whether the field in the vendor card table is enabled or not and it is as the user wants, normally it is used usually.

Thanks for your help

I am a beginner at this, I will read more documentation so I can understand the concepts better again thanks.