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 bkrike 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: *

  • Users: BJD
  • Content: Threads
  • Order by date
  1. BJD

    record suppression based on a parameter

    I have the details section of a report suppressed based on the following formula: IF {?NAME}='SCARLSON' THEN ({DESCRIPTION} STARTSWITH 'RPM')=FALSE ELSE IF {?NAME}='LINGLE' THEN ({DESCRIPTION} STARTSWITH 'BOBC' =FALSE ELSE NO So, for example, if the parameter entered is SCARLSON, then it is...
  2. BJD

    Different "versions" of fonts

    Is there a way to get rid of or hide the extra versions of fonts that show up in Crystal? For example, Times New Roman has Times New Roman (Arabic), Times New Roman (Baltic), etc., etc. The only place I see these extras is in Crystal Reports.
  3. BJD

    Printing problems

    I created a simple report this morning and when I went to print it, the page was blank. Everything showed on the screen but nothing would print out. I tried several different printers to no avail. The one 'printer' that did work was PDF mailer which creates a PDF file of the report and I was...
  4. BJD

    Print Setup script step

    I would like to have a script that prints my report to a specific printer which is NOT the one I normally use. Can I set it up so that I can use a script with the Print Setup step but not have to choose the printer each time? I only want this report to print to this printer and so need to...
  5. BJD

    portal row in a script

    I am trying to create a script that goes to the 2nd portal row, goes to the field TOOL_ID and copies that field's information. My script steps are: Go to Portal Row (have 'select entire contents' unchecked, 'perform without dialog' checked and set it to go to row 2) Go to field (have...
  6. BJD

    Subreport detail section displays on screen but WON'T PRINT

    I have subreport that will display correctly on screen with Print Preview but when I actually print it out, the details section does not show. (FYI-If you export this report to Excel, the detail section will show there.) The subreport has information in the group header that prints fine. The...
  7. BJD

    Suppress page header on first page only

    My page header contains page number and some other information from my report. I need to suppress the page header on page 1 only. Also want it suppressed if the report is only 1 page long. Thanks
  8. BJD

    added field to view but not available to add to report

    I have a report created from a view. I added a field to the view. When I go back to my report to add this field, it is not listed as a field under that view. If I create a new report using this view, the field is available. Is this normal behavior and if so, any suggestions on working around...
  9. BJD

    strange grouping

    I have a report that groups by customer_order.ID with this same field in the detail section. One of my groups is for customer order 10280. This customer order shows in the detail section, followed by a DIFFERENT customer order 10351. This order is in the wrong group. Also tried this -...
  10. BJD

    linking problem

    I have 3 tables linked as follows: OPERATION with an equal join to OPERATION BINARY , and OPERATION with a left outer join to REQUIREMENT. This was working fine but I need to add one more table. I need to add a table called PART as an equal join to REQUIREMENT. When I do this, the report acts...
  11. BJD

    subreport within a subreport

    I have a report that is used as a subreport (call it report A) . It has one subreport (subreport B). When I insert report A into my main container report, subreport B is not there. The Detail section where I had inserted subreport B is there but empty. Reports A & B are reports that were...
  12. BJD

    Group by week

    I have a report of cash receipts for the month of January. I would like a subtotal for each week. What is the best way to do this?
  13. BJD

    problem with shared variable - date

    In my subreport I have a field called Desired_ship_date that I want to pass to my main report. Not every record in the main report will have records in the subreport so Desired_ship_date from the subreport will be null on some records. When I try my shared date variable, it works on the first...
  14. BJD

    Choosing 1 date from 3 different date fields

    I have 3 date fields, each from a different table, and would like to use a formula that shows only one date based on the following conditions: If cld_desired_ship_date is null, return cl_desired_ship_date, but if cl_desired_ship_date is null, return co_desired_ship_date. The table (CLD)...

Part and Inventory Search

Back
Top