Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mike250

    Repeat Labels

    Let me add a bit more info: I presently have used the Report Expert to set up labels using a custom size. I've set it to 4.000in x 5.250in to represent 4 to a page, 2 across and 2 down. From within Crystal when I query all records I get 4 to a page. What I need now is to repeat the same label...
  2. mike250

    Repeat Labels

    Evening all, I am needing to create dock receiving slips; 4 to a page. In our software program the user specifies in a data field how many cartons they received. Let's say this number is 3 and the field is named cartons. I need to print labels for this shipment. Using a stored parameter off...
  3. mike250

    Export Crystal Report to seperate files based on Grouping

    Good afternoon, Is it possible to export to an RTF file of some sort from Crystal Reports (7.0) but have it create seperate files for each change in grouping? Our scenario: The crystal report prints a performance report for a list of 50 stores, we've got the report setup to begin on a new...
  4. mike250

    SQL Question

    Using DISTINCT.
  5. mike250

    Autonumbers (range)

    Does anyone has code? An example? Cheers!
  6. mike250

    Autonumbers (range)

    What I want is this. We receive a bunch of barcoded customer loyalty cards that are sequential in barcodes. I am building an Avery Label report that also has the same barcodes for affixing to the customers completed form while we hand them their new card. I want to have an entry form for...
  7. mike250

    Autonumbers (range)

    I need to populate a table column with a range of numbers beginning with 40000000001 through to 400000000500. So the first record would be 40000000001 and the last record would be 400000000500. Is there a quick and dirty way to insert each record that sequentially adds a number between this...
  8. mike250

    Formatting concatenated field

    Thank you sir.
  9. mike250

    Formatting concatenated field

    Hello, I have a report with a concatenation of text and a numeric field that I want to convert to currency. Here's an example: Table Structure =============== ID - Autonumber Store - Text Sales - Currency When I insert the Sales field into the report by itself, it correctly formats as a...
  10. mike250

    Access 97 Form parameter passing to Crystal

    I'm trying to pass parameters from an Access 97 form to crystal. An example is a date range. I have a db with sales information for different stores, one total sales figure for each day. I've set up an Access form that allows the user to select a beginning date and an ending date. I want to...
  11. mike250

    mysql_connect() Undefined function??

    How do you install the RPM?
  12. mike250

    Crosstab Question - % instead of total

    Thank you. I will see what I can do here. I've never created a manual cross tab or even heard of one. I have done a little research on what it is and will take a stab at it!
  13. mike250

    Crosstab Question - % instead of total

    Hi. I've created a Crystal Crosstab report that pulls retail sales analysis data from a SQL Server in 3 categories, or crosstabs. The purpose for this report is trending. 1. Retail sales total for each month. 2. Customer count total for each month. 3. Average Transaction total for each month...
  14. mike250

    Crosstab Question - % instead of total

    Hi. I've created a Crystal Crosstab report that pulls retail sales analysis data from a SQL Server in 3 categories, or crosstabs. The purpose for this report is trending. 1. Retail sales total for each month. 2. Customer count total for each month. 3. Average Transaction total for each month...

Part and Inventory Search

Back
Top