Search results for query: *

Hi, I have a report in which, when I preview it, the group header repeats properly on second page. If I print to PDF, it looks fine with group headers on both pages, but if I print to printer, the second page loses the group header. It's not the printer as multiple users with different...

I have a report with a group header that I want to repeat on each page (Group 2a) - GH1 is suppressed. I went to the Group Expert and indicated to repeat on each page. But now when the group extends to a second page the summary I had on the group footer only sums the values for the second...

I am trying to copy the sum of a field from a subreport to the details section of the main report and then I am trying to hide all the details based on that value being <0. In the subreport I added formula: @TotalWIP WhilePrintingRecords; shared numbervar x := x +...

I am trying to find out the ip address of a linked server that my predecessor created. The server is linked using OraOLEDB.Oracle provider. If I test the connection it is successful. Currently there is a Server Name... but I can't figure out where it points to. I tried to ping it through...

Hi, I have a report where i renumber pages after each change in group. The last page is a Terms & Conditions page and it is in the Report Footer. Right now it is continuing on the page numbers of the last group in the report. I want to be able to suppress the report header only on this last...

I am trying to suppress a Detail record on conditions.. What I have is: Each record is distinct on InvoiceLineID Each InvoiceLineID can have duplicate SalesOrderLineID Each SalesOrderLineID has an ExtendedCost Each SalesOrderLineID can have a different PartID What I need to do is: Look...

I have a report, created using database wizard connected to our manufacturing ERP system, that list parts remaining to be issued to open jobs. In the report I have a subreport that identifies if there are any open jobs to make any of the parts listed in the main report. One of the custom...

I have a report with a paramater that allows multiple values. When the user enters no values, then the report prints all data. I am trying to disallow printing if at least one value hasn't been entered in the parameter field. Can I write a formula in my Record Select? Or would a formula to...

I have a report with 3 Groups and 2 Detail sections. Detail Section b contains a Subreport. I suppress the Detail section if the Subreport is blank. I want to now suppress Details Section a if Details Section b is is blank. Then I want to suppress Group Header # 3 and Group # 2 if Detail...

I know I am messing up somehow, but not 100 % sure where.... I have this SQL statement, where I want to grab all records with criteria, but if a record doesn't exist in the JobOperations table I still want a "Null" record pulled indicating there are no operations corresponding to the...

Hi all. I am having difficulty trying to get a subreport to summarize based on a formula. In the main report I have a field in my Details section called @HTSCode. This is the formula: If Len(Trim({SalesOrderLines.uomlAlternateHTSCode}))= 0 then IF len({PartRevisions.imrTariffID})= 0 then...

I have a subreport with Summaries in Group Footer. I am trying to suppress the group footer section if summary result is 0. I went to the Group Footer section expert, click the formula tool and inserted Basic formula: if Sum ({@ExportPrice})=0.00 then formula = true else formula = false end...

I have a report to print a sales order acknowledgement. I am grouping by Sales Order ID... In the group footer I show the sales order totals In the footer I have a "Continued" text string to tell user there is a next page. The rule applied here is if current page is less than total pages...

I am using Crystal Reports 2013. I have a Subreport with headers, and I have set conditional suppression for the records. When there are no records displayed due to the suppress conditions I want to suppress the subreport from displaying in my main report. I tried setting the Subreport format...

I have a purchase order report that I am trying to number records based on change in group Supplier ID. So I created a Running Total field called "#NumberLine" Selected a field to summarize by e.g. Part ID Selected Type of Summary: Count Evaluate: For each Record Reset: On Change of Group...

Hi All, I have a running total in my report that evaluates based on a formula as follows: NOT(({RECEIVER.PURC_ORDER_ID}= previous({RECEIVER.PURC_ORDER_ID})) and ({PURC_ORDER_LINE.LINE_NO}= previous({PURC_ORDER_LINE.LINE_NO}))) It works most of the time, but it omits including the very first...

I have a report with a Running total that is to Evaluate based on a formula: NOT({PURC_ORDER_LINE.PURC_ORDER_ID}= next({PURC_ORDER_LINE.PURC_ORDER_ID}) and {PURC_ORDER_LINE.LINE_NO}= next({PURC_ORDER_LINE.LINE_NO})) The field to Summarize is based on a formula field called @fla_extended_amt...

I am trying to suppress duplicates. I have this conditional formula that suppresses the duplicates correctly: {PURC_ORDER_LINE.PURC_ORDER_ID}= next({PURC_ORDER_LINE.PURC_ORDER_ID}) and {PURC_ORDER_LINE.LINE_NO}= next({PURC_ORDER_LINE.LINE_NO}) the only problem is that I have a Running Total...

I have a complex Crystal Report that I created using the SQL created automatically through the various manipulations I did in the report. I need to remove one item from the defaulted "Select" statement. The item is used in a formula and not directly in the report. Is there a way to remove it...

I have a Crystal Report that was working fine until I added one select statement Here is the Sql before: SELECT "PURC_ORDER_LINE"."PART_ID", "PURCHASE_ORDER"."BUYER", "PART"."PRODUCT_CODE", "PURC_ORDER_LINE"."MFG_NAME", "PURC_ORDER_LINE"."MFG_PART_ID", "PART"."DESCRIPTION", "VENDOR"."NAME"...