Search results for query: *

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...

Using Foxpro DB and CR 2008. Two tables (Students and Payments) linked by Client_no. Report has 4 parameters : ?Date Range, ?Amount, ?Last Name and ?Receipt Number The goal of the report is to list student payment info based on the results of 3 different search possibilities: 1. by...

Sorry....after posting the 1st time I thought I posted in the wrong place since it has nothing to do with FORMULAS. Are you saying these 2 "issues" I have are FEATURES of 2008 and NOT something I'm doing wrong? Thanks again.

I'm converting CR 8.5 reports to CR 2008, and writing new reports in 2008 using Visual FoxPro DB and ODBC driver. I have a simple report with one STRING parameter. "Allow discrete values" = True. "Default Value" field is blank. 1. When I run the report the first time, the parameter field is...

I'm converting CR 8.5 reports to CR 2008, and writing new reports in 2008 using Visual FoxPro DB and ODBC driver. I have a simple report with one STRING parameter. "Allow discrete values" = True. "Default Value" field is blank. 1. When I run the report the first time, the parameter field is...

Thank you Terry. That was also very helpful. Are those/other shortcuts documented somewhere?