Recent content by MyComputerGuy

We have an Access database for quoting jobs. Currently, we enter a Quote# manually into a text field (generally a number but frequently followed by a letter). I would like to create a button that could be used to insert the current AutoNumber field data into the Quote# field. The AutoNumber...

I am trying to add data from a Memo field to a report but have a phrase that is repeated in many of the records. Printing this field has increased the report size from 13 pages to 83 pages (not a good thing). My initial thought to create a subreport, selecting the text field if it does (or...

In response to the original question, in laymens terms, A View is a process which shows the user only the data that they need or want to see, not all of the data available. Thus, some of the work has already been done for you, i.e. linking the tables and selecting which fields are available for use.

I checked, and you are correct. This is a Memo field, I'll try a new post.

The problem is that the select expert does not show this field as a selection option. Is there a CR option that may prevent selection based on field type?

I am trying to add a text field to a report but have a phrase that is repeated repeated in many of the records. Printing this field has increased the report size from 13 pages to 83 pages (not a good thing). My initial thought to create a subreport, selecting the text field if it does not...

Just checking for responses before taking that step

Are there any JobBoss users willing to share there knowledge? I have found Tek-Tips members VERY helpful with other, more commonly used applications and would like to see if anyone else is using this program. If so I would be happy to share info.

I am using Crystal Reports v9.2 with an Access database and am working on a report showing the last Release_Date of all Part#'s. Sorted by Part# now shows: Part # Release_Date 12345 01/01/2003 01/02/2004...

Sorry All, I'm still stumped. I've created a subreport, Grouped by Job.Job . I am using 3 tables; CUSTOMER, JOB, & DELIVERY. Links are CUSTOMER.CUSTOMER - JOB.CUSTOMER, JOB.JOB - DELIVERY.JOB I'm trying to add the folowing SQL Expression field within the subreport: If {Delivery.Job} =...

Thanks, I'll have to play with CR a bit more to figure out how & where to enter the code into a sub-report, but this helps.

My experience with programming reports may be a bit outdated but it still should work: Check into embedding the required printer command codes (PCL) into the page header or footer. Each printer/manufacturer has unique codes but the are easily found with a web search. You may need a Hex editor to...

Thanks for the reply but I'll need more detailed info. I've done these types of reports years ago but have gotten rusty. The real trick will be selecting data from the next record to be included onto the same data line as the current record. All help is appreciated.

I am working on a report listing release dates and quantities for products (see thread149-1041264) Currently, these fields exist in the database: Job#, Release_Date, Release_Qty, Remaining_Qty. I have created a sub-report and calculated a subtotal for 'Remaining_Qty' within each Job#. I want to...

Currently, these fields exist in the database: Job#, Release_Date, Release_Qty, Shipped_Qty, Order_Qty Shipped_Qty is for each release, But I want to see a total shipped for each job. Sorted by Date now shows: Job # Release_Date Release_Qty Shipped_Qty Order_Qty 12345 01/01/2005...