Hi
No you are kind of right, but you can get realy time by running the report from a menu item (but that again I suppose would only give you a snapshot).
The closest thing you can get to a snapshot this way is to with a BAQ export on a scheduled task every minute.
You can teach me something now - if you create a report to odbc does it automatically update in real time without having to refresh?
Thanks,
________________________________
From: flexial_ma <mike.abell@...>
To: vantage@yahoogroups.com
Sent: Friday, 18 May 2012, 15:30
Subject: [Vantage] Re: ODBC - Crystal reports 8 ,8.5 - Vantage 8.03
Â
Thanks Chris,
I think I understand what you are saying and I tried it. Correct me if am wrong but does this not just create a "snapshot" in time of the data at the time you ran the report through vantage that created this XML file. What if we want "realtime" reporting of the data. I don't want to have to "regenerate" an XML file through Vantage and then update the Crystal Report from there? Am I missing something?
Mike..
No you are kind of right, but you can get realy time by running the report from a menu item (but that again I suppose would only give you a snapshot).
The closest thing you can get to a snapshot this way is to with a BAQ export on a scheduled task every minute.
You can teach me something now - if you create a report to odbc does it automatically update in real time without having to refresh?
Thanks,
________________________________
From: flexial_ma <mike.abell@...>
To: vantage@yahoogroups.com
Sent: Friday, 18 May 2012, 15:30
Subject: [Vantage] Re: ODBC - Crystal reports 8 ,8.5 - Vantage 8.03
Â
Thanks Chris,
I think I understand what you are saying and I tried it. Correct me if am wrong but does this not just create a "snapshot" in time of the data at the time you ran the report through vantage that created this XML file. What if we want "realtime" reporting of the data. I don't want to have to "regenerate" an XML file through Vantage and then update the Crystal Report from there? Am I missing something?
Mike..
--- In vantage@yahoogroups.com, Chris Thompson <chriselectrix@...> wrote:
>
> Hi Mike
>
> The topic is huge, and I dont have took much time today so I will go over it hi-level.
>
> When Epicor prints to a crystal document, it creates an xml which is then pushed into the .rpt and runtime displays it as a preview or prints it.
>
> Typically these are stored in ...\EpicorData\Reports\[user name]
>
> So if you were to print an eg Quote to screen and locate your folder, you should see the xml it creates.
>
> You can then add additional fields to the canned reports.
>
> You can also create BAQs and Dashboards then create fully custom crystal reports from data stored within the dashboards (or if you dont want to create a dashboard you can create a BAQ Report (which is literally a print screen with filters/criteria)).
>
>
> You can then add the dashboard or BAQ report to a menu item for anyone to run (depending on security levels required).
>
> Sorry to be brief.
>
> I can give you more info on specific areas if you need it.
>
>
>
> ________________________________
> From: flexial_ma <mike.abell@...>
> To: vantage@yahoogroups.com
> Sent: Friday, 18 May 2012, 14:48
> Subject: [Vantage] Re: ODBC - Crystal reports 8 ,8.5 - Vantage 8.03
>
>
> ÂÂ
> Chris,
>
> Could you give me an example of what you mean by "XMLs which Epicor creates when it prints" and how you "use" that in CR. This is GOOD information Chris and I really appreciate it.
>
> Mike...
>
> --- In vantage@yahoogroups.com, Chris Thompson <chriselectrix@> wrote:
> >
> > I have crystal developer or whatever it is called installed on my PC and create all the reports on it using XMLs which Epicor creates when it prints.
> >
> > Never had to touch odbc and have all the reports we need and more.
> >
> >
> > You can then make menu items in Epicor to run the reports if you want to (using crystal run time).
> >
> >
> >
> >
> > ________________________________
> > From: flexial_ma <mike.abell@>
> > To: vantage@yahoogroups.com
> > Sent: Friday, 18 May 2012, 14:39
> > Subject: [Vantage] Re: ODBC - Crystal reports 8 ,8.5 - Vantage 8.03
> >
> >
> > ÂÂÂ
> > Thanks for the reply Chris,
> >
> > Acutally, I am a developer and I am used to creating CR in my apps which "connect" to external data sources (in this case Vantage) but I usually create the Crystal Report first and import it into my app. The CR 11 app that I think Epicor provides is not installed on any of our clients (including mine) so Vantage will not let me create a Crystal Report from "within" it. I think only the "runtime" engine is installed.
> >
> > Mike..
> >
> > --- In vantage@yahoogroups.com, Chris Thompson <chriselectrix@> wrote:
> > >
> > > I find you can pretty much do everything you need within Epicor (link tables etc) then connect to Crystal to make it look 'pretty' if you need to.
> > >
> > > What specifically cant you do in Epicor that makes you want to do everything externally?
> > >
> > >
> > >
> > > ________________________________
> > > From: flexial_ma <mike.abell@>
> > > To: vantage@yahoogroups.com
> > > Sent: Friday, 18 May 2012, 14:28
> > > Subject: [Vantage] ODBC - Crystal reports 8 ,8.5 - Vantage 8.03
> > >
> > >
> > > ÂÂÂÂ
> > > Guys,
> > >
> > > I am very new to Vantage and I came from a company that used CR exclusively with their ERP system for designing reports outside of the actual software. I am very familiar with CR versions 8 to 11 and I have the OpenEdge ODBC driver installed on my PC connected to our Vantage Progress database. Since no one else here uses Crystal and Vantage outside of the software, I just wanted to know if there are any downsides to using Crystal with the OpenEdge driver and specifically are their any issues with an older version of CR(like 8,8.5) that I should know about. I've been indirectly told here I shouldn't connect to the Vantage database this way but I wanted expert opinions. Thanks in advance for any help!
> > >
> > > Mike Abell
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
> [Non-text portions of this message have been removed]
>
[Non-text portions of this message have been removed]