On Dec 22, MalcomW wrote:
The easiest way to solve both of your problems is to create a table with one column, with the integers from 0 to 99 as the 100 rows.
You can do a cartesian join to this table to get multiple label copies, and you use it to skip n labels with another parameter.
If you are working with reports, a table like this can be quite useful in your database, yet is extremely compact, and easy to create.
Malcolm
I'm using SCR 8 against a Visual FoxPro 3.0 database linked through an ODBC connection. I was able to create the table fine, but I'm not able to create a link so I can enter a parameter and have the report print multiple labels. I selected the Cartesian Products check box in Options, but it is still greyed out in report options. Could you be more specific on how to create the proper link?
Thanks,
Mike
The easiest way to solve both of your problems is to create a table with one column, with the integers from 0 to 99 as the 100 rows.
You can do a cartesian join to this table to get multiple label copies, and you use it to skip n labels with another parameter.
If you are working with reports, a table like this can be quite useful in your database, yet is extremely compact, and easy to create.
Malcolm
I'm using SCR 8 against a Visual FoxPro 3.0 database linked through an ODBC connection. I was able to create the table fine, but I'm not able to create a link so I can enter a parameter and have the report print multiple labels. I selected the Cartesian Products check box in Options, but it is still greyed out in report options. Could you be more specific on how to create the proper link?
Thanks,
Mike