QR code - Epicor 10 Order Entry form

Epicor ERP 10
, ,
1

Our company is trying to generate a QR code next to each line of an order entry form that is printed as long as there is a Release Reference field filled out. Using Report Builder, we have been able to add a QR code but it only works on the first line of each order. Is there a way to do this for each line?

The code used to build the QR code image expression is:
=“http://qrcode.kaywa.com/img.php?s=8&d=” & Fields!OrderRel_Reference.Value & " " & Fields!OrderNum.Value & " " & Fields!PartNum.Value & " " & Fields!PartNum_PartDescription.Value

2

Can you provide a screenshot of your design view inside of Report Builder? If the solution is working, then it sounds like your Expression is not in the correct spot to show for each line

3

image
image775×694 23.3 KB

Screenshot attached of the form in report builder. The QR Code is located in the middle of the page far right. Should I move it below within the order detail section so it’s linked?

4

Yes. You currently have it in the OrderNum Group/Group1.

Use the Row Groups section in Report Builder to accurately tell where to place your additions.

image
image902×586 23.4 KB

5

image
image840×577 19.7 KB

I moved the image within the group (see attached), but now the QR code doesn’t populate at all whereas before it would at least show up for line 1 of the order

6

Have you confirmed that the section you put it into isn’t hidden?

7

Yes I have, the group is set to show visibility

8

There are multiple places you can place visibility criteria on. Tablix, Group, Row, Column, Cell.

image
image

Make sure you right click on the section to the left of the row you placed your QR code in. I bet you there is more visibility criteria on it.

9

I would print this to a textbox, see what it generates per release/line.

10

This error pops up:

The Value expression for the textrun ‘Textbox4.Paragraphs[0].TextRuns[0]’ contains a colon or a
line terminator. Colons and line terminators are not valid in expressions.

11

All visibility you mentioned are on

12

You may need to “escape” the data passed along to the URL.

for example:
...?s=6&d=Hello%26World produces
image
Which a QR scanner reads as Hello&World

Where as
...?s=6&d=Hello&World produces
image
which scans as Hello

That ampersand in the source text is interpreted as the start of an escape code.

13

The & sign is producing the data correctly based on the string requirements already, but just for line 1 of an order. I would like a QR code to be generated for each line of an order using the same data fields

14

Get @hkeric.wci 's suggestion working first.

Set that text box to

=Fields!PartNum_PartDescription.Value

Then to

=Fields!PartNum.Value & " " & Fields!PartNum_PartDescription.Value

And so on until

="http://qrcode.kaywa.com/img.php?s=8&d=" & Fields!OrderRel_Reference.Value & " " & Fields!OrderNum.Value & " " & Fields!PartNum.Value & " " & Fields!PartNum_PartDescription.Value

Once that last one is working, copy the text it produces and paste it in a browser.

Then scan the image it generates to see if it gives you what you want. (It mostlikely won’t)

you’ll probably need to end up with something like

="http://qrcode.kaywa.com/img.php?s=8&d=" & WebUtility.UrlEncode(Fields!OrderRel_Reference.Value & " " & Fields!OrderNum.Value & " " & Fields!PartNum.Value & " " & Fields!PartNum_PartDescription.Value)

Not sure if the WebUtility.UrlEncode function can be called in SSRS

edit

one last point on the URL encoding … Just because a string works in the browser doesn’t mean it will work in the report. The browser may “do you the favor” of encoding the url for you.
If the data part of my URL is Hello World, and I hit enter, Chrome changes that to Hello%20World

3 Likes