Crystal Reports date parameter field not working

Yahoo Archive
1
I have Crystal Reports XI R2.

When I have a date type parameter field then the calendar icon will not work on my workstation. It gives a error message that an error has occurred in the script on this page.
It does the same thing for Crystal Run Time and for Crystal Development.
Epicor said it was a known issue but was supposed to have been fixed.
Â
The date parameter works if I key the date instead of using the calendar icon to select the date from the calendar.
I have reinstalled Crystal Runtime and Crystal Development both.
Anyone have any idea's?
Â




[Non-text portions of this message have been removed]
2
FOR EACH ttShipDtl no-lock , EACH OrderHed no-lock, EACH InvcHead no-lock WHERE ttShipDtl.Company = OrderHed.Company AND ttShipDtl.Company = InvcHead.Company AND ttShipDtl.OrderNum = OrderHed.OrderNum AND ttShipDtl.OrderNum = InvcHead.OrderNum AND OrderHed.OrderNum = InvcHead.OrderNum AND InvcHead.OpenInvoice = false.

I'm using this on a BPM query to sum up all invoices related to an order. When I don't have the InvcHead table joined in the query, it's instantaneous however when the InvcHead table is in the mix, it takes 15 seconds to execute.
3
Try this.

I'm not sure why you are wanting to put the join to OrderHed within the join
to InvcHead.



FOR EACH ttShipDtl no-lock ,

EACH OrderHed no-lock WHERE ttShipDtl.Company = OrderHed.Company AND
ttShipDtl.OrderNum = OrderHed.OrderNum,

EACH InvcHead no-lock WHERE

ttShipDtl.Company = InvcHead.Company

AND ttShipDtl.OrderNum = InvcHead.OrderNum

AND OrderHed.OrderNum = InvcHead.OrderNum

AND InvcHead.OpenInvoice = false.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
pbparker
Sent: Friday, February 05, 2010 12:50 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Anyone see a flaw in this 4GL query?





FOR EACH ttShipDtl no-lock , EACH OrderHed no-lock, EACH InvcHead no-lock
WHERE ttShipDtl.Company = OrderHed.Company AND ttShipDtl.Company =
InvcHead.Company AND ttShipDtl.OrderNum = OrderHed.OrderNum AND
ttShipDtl.OrderNum = InvcHead.OrderNum AND OrderHed.OrderNum =
InvcHead.OrderNum AND InvcHead.OpenInvoice = false.

I'm using this on a BPM query to sum up all invoices related to an order.
When I don't have the InvcHead table joined in the query, it's instantaneous
however when the InvcHead table is in the mix, it takes 15 seconds to
execute.





[Non-text portions of this message have been removed]
4
Yup, that worked perfect. After looking at the ShipDtl table, you're right I don't need to link to the OrderHed table, I can relate them directly with the OrderNum, I think I thought the OrderNum was only embedded in the ShipHead table.

I'm creating a BPM that will stop shipment on customers we're going to mark "prepaid required". The BPM will sum up all posted invoices for an order and if they're less than the total of the order, it will stop the shipment attempt.

Thanks much, it runs perfectly now (until I add in the run Bpm/BpmEmail.p portion, but guess there's no quick way around that).


--- In vantage@yahoogroups.com, "Sean McDaniel" <smcdanie@...> wrote:
>
> Try this.
>
> I'm not sure why you are wanting to put the join to OrderHed within the join
> to InvcHead.
>
>
>
> FOR EACH ttShipDtl no-lock ,
>
> EACH OrderHed no-lock WHERE ttShipDtl.Company = OrderHed.Company AND
> ttShipDtl.OrderNum = OrderHed.OrderNum,
>
> EACH InvcHead no-lock WHERE
>
> ttShipDtl.Company = InvcHead.Company
>
> AND ttShipDtl.OrderNum = InvcHead.OrderNum
>
> AND OrderHed.OrderNum = InvcHead.OrderNum
>
> AND InvcHead.OpenInvoice = false.
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> pbparker
> Sent: Friday, February 05, 2010 12:50 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Anyone see a flaw in this 4GL query?
>
>
>
>
>
> FOR EACH ttShipDtl no-lock , EACH OrderHed no-lock, EACH InvcHead no-lock
> WHERE ttShipDtl.Company = OrderHed.Company AND ttShipDtl.Company =
> InvcHead.Company AND ttShipDtl.OrderNum = OrderHed.OrderNum AND
> ttShipDtl.OrderNum = InvcHead.OrderNum AND OrderHed.OrderNum =
> InvcHead.OrderNum AND InvcHead.OpenInvoice = false.
>
> I'm using this on a BPM query to sum up all invoices related to an order.
> When I don't have the InvcHead table joined in the query, it's instantaneous
> however when the InvcHead table is in the mix, it takes 15 seconds to
> execute.
>
>
>
>
>
> [Non-text portions of this message have been removed]
>