Search results for query: *

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

I am a relative novice with Crystal Reports 9.0 but have created a Production Scheduling report showing Job#, Release Date, Release Quantity, etc. I would like to add a column showing the total quantity shipped. Each Job has multiple Releases and Grouping & Subtotaling gives the total however I...

That's easy, (I assume you have all the components). Connect the Super Injector into the far end (use a patch cable if testing per-wired jacks). Connect the NextScanner into the near end, turn it on, set the scanner to 10BaseT by selecting Network Setup and then the 10BaseT button. Press Auto...

The spec's call for 9 VDC @ 1 amp. The polarity is positive center. I found that 11 VDC @ 350 mA and it works just fine, don't be afraid to use something reasonably close. But remember, Positive Center Polarity. By the way, when you get it charged,let me know what flash version are you running.

Try a Soft Reset, found on the back of your palm. If this doesn't work, try a Hard Reset (Hold Power button while Pressing Reset)

I have checked with Fluke support, to no avail. This model was prior to their aquisition. My best bet at this point is to find someone with this scanner and get a copy of their flash.