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.
Any help will GREATLY be appreciated. Thanks.
|