luv2bike2nv
IS-IT--Management
Does anyone have any experience with creating Crystal Reports 8.5 and MAX version 3.7 and using MAX Report Extract DB?
I have a user that wants me to create a report that i need to get information from Purchase Orders and the information on the PO is a formula that is taken from Report Extract DB. The field information that MAX provides for what the fields are does not help me out at all.
example:
Field Offset Length Type Description
Line 0 2 Integer Line Number
Key50 2 50 String 50 character key field
Group 52 2 Integer Group Number
Len02 54 2 String 2 Character Len Field
....
RPTL80 85 80 String 80 Character Report line
...
... represents more lines that are same but the character len is increased (Len05, Len06 Len15, RptL132, RPTl120)
One of the fields the user wants is Last PO Unit Cost and when I go to the Last PO Unit Cost formula it says
If {Report Extract.Group} = 1 then
{Report Extract.RPTL132} [62 to 71]
Else ""
in my report to include the Last PO Unit Cost I added the Report Extract DB, I link it up with another DB just like the way it is linked up in another report using one of the same DBs. I created the same formula as above for my report for the Last PO Unit Cost, ran the report and Crystal Reports Hangs up on me.
Can anyone shed any light on Report Extract from MAX DBs?
Thanks in advance!
I have a user that wants me to create a report that i need to get information from Purchase Orders and the information on the PO is a formula that is taken from Report Extract DB. The field information that MAX provides for what the fields are does not help me out at all.
example:
Field Offset Length Type Description
Line 0 2 Integer Line Number
Key50 2 50 String 50 character key field
Group 52 2 Integer Group Number
Len02 54 2 String 2 Character Len Field
....
RPTL80 85 80 String 80 Character Report line
...
... represents more lines that are same but the character len is increased (Len05, Len06 Len15, RptL132, RPTl120)
One of the fields the user wants is Last PO Unit Cost and when I go to the Last PO Unit Cost formula it says
If {Report Extract.Group} = 1 then
{Report Extract.RPTL132} [62 to 71]
Else ""
in my report to include the Last PO Unit Cost I added the Report Extract DB, I link it up with another DB just like the way it is linked up in another report using one of the same DBs. I created the same formula as above for my report for the Last PO Unit Cost, ran the report and Crystal Reports Hangs up on me.
Can anyone shed any light on Report Extract from MAX DBs?
Thanks in advance!