Recent content by LRBFAN

BINGO.......that did it!! Not sure why this works but am happy and thankful to you that it does. I was about to suggest I send you a test table and link to the Foxpro ODBC so you could run the report yourself. Thanks again and have a nice weekend.

Sorry.....Was thinking you could see it after I ran it the first time. Here is another that I saved after running it the 2nd time showing the dups. Thanks again.http://www.mediafire.com/file/98n9zpruw6uj7wr/Test_File_Folder_Labels_2.rpt

Finally figured out how to attach....I think:):)http://www.mediafire.com/file/wsgfyvwkfqrvskv/Test_File_Folder_Labels.rpt

Oops....looks like it didn't attach. I tried to attach by entering C:\Custom Reports\ADI\Test File Folder Labels.rpt in the Step 3 box. What's the correct way? Thanks.

Thanks.....I have attached (hopefully) the report with Saved Data. It is correctly printing 4 labels starting at label #3. If I rerun it, it will print 8 labels starting at label #3

I created a non label report using the same Command and entered the same code in the Suppress Blank Section etc, and had the same result.....the first time prints perfectly and all other times after that prints dups. I've used this table 200+ times before but first time using the Add...

Issue #1 fix - Select RTRIM(Students.`lname`) + ', ' + RTRIM(Students.`fname`) AS Client_Name, Issue #2 fix - Students.`status` = '{?Status}' and Students.`program` = '{?Program}' .......I never saw ANY examples of putting single quotes around a STRING Parameter. I just tried it and it worked...

Finally able to figure out issues 1 and 2 and learned some SQL in the process. Now I have issue #3. When I create a new label program using the Add Command, the labels print at the correct starting label. When I REFRESH, the labels print at the correct starting label BUT it prints 2 labels...

Thank You Lbass.....replacing "null" with '' (without a space in between) worked. Now I'm having 2 additional issues that I've tried to resolve but can't figure them out quite yet. Issue #1 - I have the following @Client_Name formula that I would like to use which is....Lname + ", " + Fname...

Lbass......I used your example/code using the Xtreme Sample Database and of course it works perfectly:):) Both our reports use ODBC but I'm accessing a FOXPRO DB. I'm guessing my version isn't creating NULL fields/records from the SQL Select?? Hmmmmmm.

As I mentioned above, I am sorting by Students.lname ascending.

I am showing the actual command which I copied/pasted from the command. Database->select distinct records AND Report Options->select distinct records is NOT a highlighted option for me to check/uncheck.

Convert Database NULL Values to Default" and "Convert Other NULL Values to Default" are both unchecked.

thread149-1421170 CR2008 Foxpro DB using ODBC I've tried using lbass's suggestions from the above Thread on how to print mailing labels starting at a certain label, BUT so far I've had no success. It ALWAYS prints on the first label instead of the label I specify in the parameter. I created...

Thank you LB for this true/false testing tip. This will come in handy many times I'm sure. After writing/deleting a LONG sob story of all my efforts, the lightbulb came on. {payments.receiptno} and {?Receipt Number} were displaying the same way but still showing FALSE even though they looked...