Vantage 8.03 ADO.NET CR report

Yahoo Archive
1
To add tables in Vantage/Vista 8.0 you will need document 7567MPS and
to add additional fields you need document 4778MPS. Call tech support
and request both documents. I have added additional tables to our job
traveler with no problems other than the more tables you add the slower
the report.

Todd Dillman
2
I have taken the Epicor online Crystal course (VERY basic) and am
scheduled for Epicor classroom training next month but cannot wait to
experiment. Nothing in the online course covers standard V8 CR
reports on how they are constructed (apparently they use ADO.NET).

I would like to create another report style for the RcvLabel.rpt. I
can modify a copy of this report with CR Developer on my computer but
when I attempt to preview I get a ADO.NET (XML) connection dialog.
Here is where I get lost. What do I need to understand regarding
Vantage standard reports and the database connection.

Any direction would be greatly appreciated...

Thanks,

Bill
3
This is what I understand about Vantage standard reports:
The report invocation gives you the opportunity to select the report style that have been set up through report style maintenance.
The report produces an XML file that would be located on your Vantage server in the
\\<server name>\mfgsysdata\reports\(vantage user id)\(report type + sequential number).xml
The XML file name is passed to Crystal when the report process invokes crystal viewer.

If you are modifying a report it is best to preview a standard report first, so the XML file is produced and then can be used to test your modified report with. You can point the report you are modifying to the xml file by the Database->Set DataSource Location menu. In the bottom window area expand the create new connection and click the plus sign next to the ADO.NET (XML) icon. This will open a dialog that you use to point the report to your xml file.

(The ADO.NET datasource type is not installed by default when you install Crystal Developer)

After you have selected the xml file and it is highlighted in the bottom section, click on each ReportDataSet icon in the top section and click the update button on the right - you may have more than one ReportDataSet in the top section (if the report contains subreports) and you have to highlight and update each of them....

Always save your report as a different name or in a different folder - just in case

Happy modifying.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of hoomail4me
Sent: Friday, August 17, 2007 2:31 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Vantage 8.03 ADO.NET CR report.

I have taken the Epicor online Crystal course (VERY basic) and am scheduled for Epicor classroom training next month but cannot wait to experiment. Nothing in the online course covers standard V8 CR reports on how they are constructed (apparently they use ADO.NET).

I would like to create another report style for the RcvLabel.rpt. I can modify a copy of this report with CR Developer on my computer but when I attempt to preview I get a ADO.NET (XML) connection dialog.
Here is where I get lost. What do I need to understand regarding Vantage standard reports and the database connection.

Any direction would be greatly appreciated...

Thanks,

Bill





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/links
Yahoo! Groups Links
4
Thanks for the tip Bernie,

I tried you suggestion and it worked beautifully for previewing in
Crystal Developer. Added a calculate field and ran again from Vantage
and addition worked.

Now I just need to learn how to add additional tables to a report. Do
you have any documentation for help in this area?

Thanks again,

Bill
5
Additional tables are not possible in the current version of Vantage without the SDK ($$$$$$)
Sometimes fields from 'linked' tables can be made available in the report data definition but there is no documentation so it is hit or miss

If you have a particular report in mind and a table you need fields from that isn't part of the standard report, I would be happy to try and see if it would work...

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of hoomail4me
Sent: Friday, August 17, 2007 5:16 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Vantage 8.03 ADO.NET CR report.

Thanks for the tip Bernie,

I tried you suggestion and it worked beautifully for previewing in Crystal Developer. Added a calculate field and ran again from Vantage and addition worked.

Now I just need to learn how to add additional tables to a report. Do you have any documentation for help in this area?

Thanks again,

Bill





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/links
Yahoo! Groups Links
6
One quick and easy way to add fields from other tables is by
inserting a subreport with an odbc link.

Peter Volkert



--- In vantage@yahoogroups.com, Bernie Walker <bwalker@...> wrote:
>
> Additional tables are not possible in the current version of
Vantage without the SDK ($$$$$$)
> Sometimes fields from 'linked' tables can be made available in the
report data definition but there is no documentation so it is hit or
miss
>
> If you have a particular report in mind and a table you need
fields from that isn't part of the standard report, I would be happy
to try and see if it would work...
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of hoomail4me
> Sent: Friday, August 17, 2007 5:16 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Vantage 8.03 ADO.NET CR report.
>
> Thanks for the tip Bernie,
>
> I tried you suggestion and it worked beautifully for previewing in
Crystal Developer. Added a calculate field and ran again from
Vantage and addition worked.
>
> Now I just need to learn how to add additional tables to a
report. Do you have any documentation for help in this area?
>
> Thanks again,
>
> Bill
>
>
>
>
>
> 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/links
> Yahoo! Groups Links
>