Where do Calc_ field come from in Crystal Reports

Yahoo Archive
1
Correction: you create a new report style using a copy of the form (which you copy into mfgsys803/server/reports/CustomReports), using your new report data definition and new form. Presumably you're going to want to display the additional field(s) on the report so you'll need to make a copy of the report form.

-bws

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
    bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Brian W. Spolarich
Sent: Friday, May 15, 2009 4:03 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Where do Calc_ field come from in Crystal Reports

1. Those Calc fields are created by the server-side program that generates the report. You can't do anything with them.

2. The missing fields you can add through Report Data Definition manager. Basically you create a duplicate of the system report data definition, add the excluded field(s) to be included (there's a tab for this), and then create a new report style using the same form, but a different report data definition.

-bws

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
    bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of rapat_mark
Sent: Friday, May 15, 2009 4:00 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Where do Calc_ field come from in Crystal Reports

I am trying to make some changes to the standard quote form and have 2 questions:

1. Where do the Calc_ fields come from? In the quoteqty table there is a Calc_NetPrice that does not show in the data dictionary. Since it isn't a formula field I am not sure how to see the calculation.

2. Is there a way to add the fields that don't appear in the field explorer? Again in the quoteqty table there is a MaterialMarkUp field that I need to use but it doesn't show in the Field Explorer window.

I went to a Crystal class many years ago when I was just learning the basics...must be time to go through it again.

Have a great weekend...thanks.

Mark



------------------------------------

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





------------------------------------

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
2
I am trying to make some changes to the standard quote form and have 2 questions:

1. Where do the Calc_ fields come from? In the quoteqty table there is a Calc_NetPrice that does not show in the data dictionary. Since it isn't a formula field I am not sure how to see the calculation.

2. Is there a way to add the fields that don't appear in the field explorer? Again in the quoteqty table there is a MaterialMarkUp field that I need to use but it doesn't show in the Field Explorer window.

I went to a Crystal class many years ago when I was just learning the basics...must be time to go through it again.

Have a great weekend...thanks.

Mark
3
1. Those Calc fields are created by the server-side program that generates the report. You can't do anything with them.

2. The missing fields you can add through Report Data Definition manager. Basically you create a duplicate of the system report data definition, add the excluded field(s) to be included (there's a tab for this), and then create a new report style using the same form, but a different report data definition.

-bws

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
    bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of rapat_mark
Sent: Friday, May 15, 2009 4:00 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Where do Calc_ field come from in Crystal Reports

I am trying to make some changes to the standard quote form and have 2 questions:

1. Where do the Calc_ fields come from? In the quoteqty table there is a Calc_NetPrice that does not show in the data dictionary. Since it isn't a formula field I am not sure how to see the calculation.

2. Is there a way to add the fields that don't appear in the field explorer? Again in the quoteqty table there is a MaterialMarkUp field that I need to use but it doesn't show in the Field Explorer window.

I went to a Crystal class many years ago when I was just learning the basics...must be time to go through it again.

Have a great weekend...thanks.

Mark



------------------------------------

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