Solved

crystal report at runtime return a calculated sum variable?

Posted on 2013-01-14
7
694 Views
Last Modified: 2013-01-14
Hi Experts-

I am wondering if this is possible?

I create a CR and export it to PDF using the below code.
After execution, can I retrieve a sum Variable from my Crystal report and send it back to a variable in WFC ?

 CrExportOptions = report.ExportOptions
                With CrExportOptions
                    .ExportDestinationType = ExportDestinationType.DiskFile
                    .ExportFormatType = ExportFormatType.PortableDocFormat
                    .DestinationOptions = CrDiskFileDestinationOptions
                    .FormatOptions = CrFormatTypeOptions
                End With
                report.Export()
0
Comment
Question by:BKennedy2008
  • 4
  • 3
7 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 38775060
What version of Crystal?

mlmcc
0
 

Author Comment

by:BKennedy2008
ID: 38775127
It's the latest Crystal reports for VS 2010
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 38775332
I don't believe the .Net versions allow that.

If they do I don't know what the method is.

mlmcc
0
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 

Author Comment

by:BKennedy2008
ID: 38775504
Everything is passing parameters to crystal, not crystal to .net
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 38775569
Understood.  Crystal has full versions and versions built for use with Visual Studio.  The VS versions are referred to as .Net versions.

The full versions used to provide access to report objects though I don't know if you could get formula values.  The .Net versions were more limited and I don't believe they provide access to what you want.

mlmcc
0
 

Author Comment

by:BKennedy2008
ID: 38775571
That was too easy....Ran a Query that summed up the total field prior to executing the CR, and voila, now I have the amount in a variable...
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 38775937
Good workaround.

So long as the filtering is the same the value should be correct

mlmcc
0

Featured Post

Is Your AD Toolbox Looking More Like a Toybox?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity) (CODE) There are three files available HERE (http://www.ecb.europa.eu/stats/exch…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question