a BAQ will allow you to select the "last" record (most recent) in the PartTran table.
The Epicor Tools User Guide (about $70 from your CAM) will quickly teach you how to write BAQs. Or there may be an on-demand eLearning course on MyEpicWeb depending on your level of support.
And to send the BAQ results to Crystal, there are AnswerBooks on MyEpicWeb with the instructions.
This one is applicable:
AnswerBook # 7905MPS, BAQ Instructions for creating a Crystal Report from a BAQ in BAQ Report Designer.
Lately, I have been gravitating away from creating Crystal BAQ Reports from my BAQs. Instead I have found it more useful to use my BAQs to create dashboards. (to go paperless!) Data from Dashboards is easier to copy to Excel (as opposed to Crystal) for further data manipulation by the users.
If you can't find the Answerbook, let me know.
Lynn
The Epicor Tools User Guide (about $70 from your CAM) will quickly teach you how to write BAQs. Or there may be an on-demand eLearning course on MyEpicWeb depending on your level of support.
And to send the BAQ results to Crystal, there are AnswerBooks on MyEpicWeb with the instructions.
This one is applicable:
AnswerBook # 7905MPS, BAQ Instructions for creating a Crystal Report from a BAQ in BAQ Report Designer.
Lately, I have been gravitating away from creating Crystal BAQ Reports from my BAQs. Instead I have found it more useful to use my BAQs to create dashboards. (to go paperless!) Data from Dashboards is easier to copy to Excel (as opposed to Crystal) for further data manipulation by the users.
If you can't find the Answerbook, let me know.
Lynn
--- In vantage@yahoogroups.com, "Charlie Wilson" <foamdesigncsw@...> wrote:
>
> My mind was headed down that thought line that the results were to big for
> ODBC. Guess it's time to figure out how to write a BAQ to export to XML and
> then run crystal on that...
>
> BTW if I take the group by off it runs fine... Any Thoughts?
>
> I need the group by cuz I want to select the record with the most recent
> trans in the part tran table.
>
> ~Charlie
>
> -----Original Message-----
> From: Vic Drecchio [mailto:Vic.Drecchio@...]
> Sent: Wednesday, March 25, 2009 11:01 AM
> To: vantage@yahoogroups.com
> Cc: foamdesigncsw@...
> Subject: RE: [Vantage] Crystal report Error Help
>
> Using ODBC requires the entire result-set to be brought client-side.
>
> Not sure how large your PartTran table is but oftentimes it's too much
> for ODBC to handle. And if you are bringing ALL columns, that's a wide
> table.
>
> For troubleshooting, see if you can import simply the PartTran table
> into Excel via ODBC (or Access).
>
>
>
> Vic
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Charlie Wilson
> Sent: Wednesday, March 25, 2009 10:49 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Crystal report Error Help
>
>
>
> All I built a crystal report that links the Part table to the part tran
> table. And then I selected every field to display on the report then I
> set
> it to group by the partnum field in the part table.
>
>
>
> When I run this report I get an error message that states:
>
>
>
> Database Connector Error: "HY000:[DataDirect][ODBC Progress OpenEdge
> Wire
> Protocol driver][OPENEDGE]Internal error -1 (see dsmret.h) in SQL from
> subsystem DSM Services function dsmrecordget from sts_t:::scan_cursor on
> .SRTT_Temp_2 for . Save log for progress technical support. [Database
> vendor
> code: -219901]'
>
>
>
> Can any one shed any light on what this message is trying to tell me.
>
>
>
> ~Charlie
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder
> and Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>