Calling all Crystal Experts

Set up a formula like this:

Shared numbervar MySum;

MySum :=MySum + <field>; //This line will keep a sum of this field

<field>; // this line will display the field when you drop it into the
report



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
IT Support
Sent: Wednesday, November 04, 2009 4:18 PM
To: vantage@yahoogroups.com
Subject: FW: [Vantage] Calling all Crystal Experts







Sean,

Would you please explain how to do that?

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Sean McDaniel
Sent: Wednesday, November 04, 2009 3:11 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Calling all Crystal Experts

You can create your own running total by setting up a shared variable
and
adding to it each time you display the item you want to total.

If you are doing a baq report and you can summarize the table.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of
IT Support
Sent: Wednesday, November 04, 2009 3:44 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Calling all Crystal Experts

I am trying to bring in the quote total to use in several fields &
calculations.

I know that I can calculate the total, but then I cannot sum that sum
(Crystal limitation)

My question is, how can I bring that total into crystal reports already
calculated?

Thanks!

803.408b

Ron Flynn

[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]
Sean,



Would you please explain how to do that?



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Sean McDaniel
Sent: Wednesday, November 04, 2009 3:11 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Calling all Crystal Experts





You can create your own running total by setting up a shared variable
and
adding to it each time you display the item you want to total.

If you are doing a baq report and you can summarize the table.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
IT Support
Sent: Wednesday, November 04, 2009 3:44 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Calling all Crystal Experts

I am trying to bring in the quote total to use in several fields &
calculations.

I know that I can calculate the total, but then I cannot sum that sum
(Crystal limitation)

My question is, how can I bring that total into crystal reports already
calculated?

Thanks!

803.408b

Ron Flynn

[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]
Ron, hope this helps!
Â
1. Create BAQ with all necessary data.
2. Launch BAQ Report Designer: Executive Analysis/Business Activity Management/General Operations/BAQ Report Designer.
3. Select BAQ Report Designer from the Actions Menu.
4. Verify the Crystal Report Executable path is correct by browsing to locate the Crystal Executable file.
5. Verify that the data path is correct.
6. Verify that the local report directory path is correct.
7. Select "New Report Definition" from the new icon menu.
8. Enter a name in the Report ID field.
9. Enter a description in the Description field.
10. Enter or browse for the BAQ you created for your new report.
11. Enter a form title in the Form Title field.
12. Save and Save often!
13. Choose "Test Report Form" from the Actions menu. Wait for the pop up! Close when complete.
14. Select the "Print Preview Icon" from the Standard Toolbox to view.. Wait for the pop up! Close when complete.
15. Select "Generate Sample Data" from the Actions menu.
16. Click OK to confirm the data was successfully created and stored (XML).
17. Open Crystal Reports and click "Standard report Wizard" in the New Reports section.
18. Select "Create new Connection" and select ADO.NET (XML).
19. Click on the ellipsis by the connected then follow the path to where your XML was saved to.
20. Locate then click on your BAQ Report .xml.
21. Click Finish.
Â
Elaina

--- On Wed, 11/4/09, IT Support <itsupport@...> wrote:


From: IT Support <itsupport@...>
Subject: FW: [Vantage] Calling all Crystal Experts
To: vantage@yahoogroups.com
Date: Wednesday, November 4, 2009, 4:17 PM


Â





Sean,

Would you please explain how to do that?

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
Of Sean McDaniel
Sent: Wednesday, November 04, 2009 3:11 PM
To: vantage@yahoogroups .com
Subject: RE: [Vantage] Calling all Crystal Experts

You can create your own running total by setting up a shared variable
and
adding to it each time you display the item you want to total.

If you are doing a baq report and you can summarize the table.

From: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
[mailto:vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com> ] On
Behalf Of
IT Support
Sent: Wednesday, November 04, 2009 3:44 PM
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Subject: [Vantage] Calling all Crystal Experts

I am trying to bring in the quote total to use in several fields &
calculations.

I know that I can calculate the total, but then I cannot sum that sum
(Crystal limitation)

My question is, how can I bring that total into crystal reports already
calculated?

Thanks!

803.408b

Ron Flynn

[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]