Joined: 09 May 2013
Online Status: Offline
Posts: 6
Topic: Barcode Range Values Posted: 09 May 2013 at 10:23am
Hello,
I have been struggling with this for a while now, but I need a way to generate barcode labels in Crystal Reports. Here's out it works, when the report is run, two parameters are asked for, a lower bound value and an upper bound value. So, if for example, a user types in a lower bound value of 1 and and upper bound value of 100, the report will generate barcodes with labels from 1 to 100. I accomplished this by using a command object and creating a field with a temporary SQL table that appends the values until the upper bound is reached and with my SQL field I simply place it within the details section of my barcode report. The problem here is that common users need to view this report, and some might now have elevated privleages to perform the task of creating a temporary SQL table -- not only that but it requires a connection to a database everytime it is run.
I initially was trying to use arrays in a formula field to spit out the results, but CR XI (which is what I am using) has that annoying feature not being able to return array values. So as you can see I am currently forced to use the SQL option.
Don't get me wrong, the SQL option is a neat trick in itself, but I'd prefer to keep away from a database when all this report is doing is generating range values to be displayed in a details section of a barcode report.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum