Sage 100

Sage 100 Advanced 2014 - custom Crystal report to print a sheet of labels runs fine in the Designer, but when put on a menu the parameter screen comes up blank and hangs. Any ideas?

Did you try a different workstation? Is it pulling data from Sage directly or through an Access PTQ? Is the form current? have the required verbiage (Converted to version 5.30)??? Are you running the ODBC client?

Sames behavior on multiple workstations and on the server. Sage ODBC direct. ""Converted"" text added manually as it did not prompt for conversion on first launch from the menu. It is using a UDT if there are any weirdnesses associated with that...

Are the parameter fields static or dynamic? If Dynamic, change to static and see if that helps. Tanya from JobOps (I was on the phone with her when this question popped up) suggested to review ODBC settings to make sure user has ODBC rights to the parameter info. Not sure either will help, but might be ""food for thought.

Both parameters are static. ODBC security is not turned on. removing UDT did not change behavior...

In File -> Report Options, make sure Convert to Null checkboxes are checked (first two on left). If you still get no data, comment out all your record selection conditions to see if you get data. If you do, add back conditions one at a time until your report hangs again. That should at least tell you what field or fields are causing the problem

Does it have sub-reports? Starting back with Sage 2013 upgrades, we ran into a couple of reports for 2 different clients that we can't run from the menu no matter what we tried. We ended up creating a shortcut in one instance and running from the task menu in the other instance.

No subreports. What I did find was that if I remove the parameter that is not used for data selection the report runs. The report has a parameter for ""first line"" to let them reuse label sheets that were only partially used a on a previous run. There is a formula in the report header that uses that to start printing the specified number of labels down. local numbervar n := {?Starting Row Number} - 1; local numbervar i; local stringvar x := """"; for i := 1 to n do x := x + chr(13)+chr(13)+chr(13)+chr(13)+chr(13)+chr(13); x It works in the designer, but not from the menu.

How about the printer used in Crystal and that from the menu? Can you assign no printer in Crystal? (Sometimes, labels can be so frustrating!!)

Sometimes, @ThereseLogeais ????

Google: ""Print labels on partial sheet at 1st available label"". There's an entry on vbforums. I tested the example there with employee labels from the menu, and it worked fine. Not sure if it will work with multiple columns, or non-legacy modules, but principles should be similar. The spacing takes place in the page header, so that should allow for multi-column labels.

Okay, labels are USUALLY frustrating!

@ChrisStAmand - that article looks like what the customer used to create his formula

It does look like it may have been a starting point.

Maybe if you define the variable as global rather than local. Big maybe.