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...
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.
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...
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...
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...
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...
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
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...
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 -...
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...
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...
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...
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)...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.