c# pdf to image conversion: Adding images to pdf forms SDK control service wpf azure asp.net dnn businessobjects_access

Accessing Data and Data Analysis

389

Calculations

BusinessObjects has standard calculation functions that enable you to make

quick calculations on the data in reports. These calculations are available directly

from a menu. The most commonly used calculations are also available on the

Report toolbar. This section describes how to make calculations using the menu

and toolbar functions.

You can also add calculations to your reports by writing your own formulas. This

is described in Formulas, Local Variables and Functions on page465.

Adding simple calculations to reports

To add a simple calculation to a report:

1. Select the row or column on which you want to make the calculation.

2. Click Data, then the calculation you want, on the Calculations menu.

To...

Choose...

Calculate the sum of the selected data,

Sum

Count all rows for a Measure object.

Count distinct values for a Dimension or Detail

object.

Count

Count the number of rows in the body including all

duplicate and empty rows,

Count All

Calculate the average of the selected data.

Average

Display the maximum value of the selected data, Maximim

Display the minimum value of the selected data, Minimum

Adding images to pdf forms - C# PDF Field Edit Library: insert, delete, update pdf form field in C#.net, ASP.NET, MVC, Ajax, WPF

Online C# Tutorial to Insert, Delete and Update Fields in PDF Document

create pdf form; change font pdf form

Adding images to pdf forms - VB.NET PDF Field Edit library: insert, delete, update pdf form field in vb.net, ASP.NET, MVC, Ajax, WPF

How to Insert, Delete and Update Fields in PDF Document with VB.NET Demo Code

pdf fillable form creator; build pdf forms

390

Accessing Data and Data Analysis

Creating Calculations

The result of the calculation is inserted in a new cell in the table or crosstab.

NOTE

Variance syntax containing the Where operator will work in all cases except when

you have two cascading Wheres (a variance using a Where operator that

contains a formula that also uses a Where operator) or in certain contexts, for

example the variance of the variable "<Revenue>" in Report.

Count and Count All

In the example below, if you insert a Count on the Resort column, the result of

the calculation is 3 because there are three different resorts, Bahamas Beach,

Hawaiian Club and French Riviera. The Count function counts values of a

dimension object that are the same only one time. This is called a distinct count.

If you insert Count All on the same column, the result is 12 because there are

twelve rows of data in the resort column. The Count All function counts all rows

including empty and duplicate rows.

Display the selected data as a percentage,

Percentage

Calculate the difference between two selected

values,

Variance

Calculate the difference between two selected

values and display it as a percentage,

Variance

percentage

To...

Choose...

C# PDF Page Insert Library: insert pages into PDF file in C#.net

NET PDF document page inserting & adding component from PDF page(s) to current target PDF document in server-side application and Windows Forms project using a

add fillable fields to pdf; adding text fields to pdf

VB.NET PDF Library SDK to view, edit, convert, process PDF file

Feel free to define text or images on PDF document and extract accordingly. Capable of adding PDF file navigation features to your VB.NET program.

pdf form save with reader; allow saving of pdf form

Accessing Data and Data Analysis

391

Calculations

If you look at the Revenue column, Count and Count All return 12. For a measure

object, the Count function counts all rows.

X Using the Calculation toolbar

You can also use the buttons on the Report toolbar for certain calculations.

X Deleting calculations from a table or a crosstab

To delete calculations from a table or crosstab:

1. Select the row or column where the calculation is displayed.

2. Click Calculations then the calculation on the Data menu..

You can see which calculations have been applied to a row or column of data.

On the Data menu, the icon next to the calculation is dimmed or has a check

mark next to it to show it has been used. Buttons on the toolbar are dimmed

to show they have been used on the selected data.

NOTE

The calculation commands available on the menu and toolbar depend on the

data you have selected in the table or crosstab.

Making calculations on dimension and detail objects

You can use the following calculations on dimension and detail objects:

• Count

• Minimum

• Maximum

a. Sum

b. Percentage

c. Count

d. Variance

e. Variance percentage

Dimension

objects

Detail objects

VB.NET Image: Adding Line Annotation to Images with VB.NET Doc

full sample codes for printing line annotation on images. Basic .NET sample codes for adding a line System.Text Imports System.Windows.Forms Imports RasterEdge

add text field to pdf acrobat; add fields to pdf

VB.NET PDF Page Insert Library: insert pages into PDF file in vb.

Create new page to PDF document in both ASP.NET web server-side application and .NET Windows Forms. Support adding PDF page number.

create a fillable pdf form from a word document; add form fields to pdf online

392

Accessing Data and Data Analysis

Creating Calculations

Calculation examples

The following section contains several examples of making calculations using the

Calculations menu.

EXAMPLE

Displaying total revenue and subtotals

You want to calculate and display the total revenue in a table. To do this:

1. Click in the Revenue column.

2. Click Sum on the Calculations toolbar.

-BusinessObjects displays the total revenue in the footer at the end of the

table.

-The sum button on the Calculations toolbar is dimmed.

You now decide you want to insert a break on this table to display subtotals for

each resort.

3. Click inside the Resort column and click Insert Break.

The data is broken up and an empty row is inserted at the end of each resort

section.

4. Click in the Revenue column.

5. Click Sum once to remove the existing calculation.

6. Click Sum again to insert the subtotals.

BusinessObjects displays a subtotal for each resort and a total at the end of

Sum

Sum button

dimmed

Insert break

C# Create PDF Library SDK to convert PDF from other file formats

What's more, you can also protect created PDF file by adding digital signature (watermark) on PDF using C# code. Create PDF from Jpeg, png, images.

pdf form save; add jpg to pdf form

VB.NET PDF: VB Code to Create PDF Windows Viewer Using DocImage

PDF page in many ways, like adding rectangle, line view, annotate, process, save and scan images (supporting JPEG and BMP) and document files (TIFF, PDF and Word

add forms to pdf; adding text field to pdf

Accessing Data and Data Analysis

393

Calculations

the table:

BusinessObjects inserts a

subtotal for each resort,

and a grand total for all resorts.

C# Image: Document Image Ellipse Annotation Creating and Adding

on color, bitional and black & white images; annotation shape to image - support adding rubber stamp powerful & profession imaging controls, PDF document, tiff

change pdf to fillable form; chrome save pdf with fields

C# PDF: PDF Document Viewer & Reader SDK for Windows Forms

After adding WinViewer DLL into Visual Studio Toolbox, you link to see more C# PDF imaging project converting, compressing and stroing images, documents and

changing font size in pdf form field; add date to pdf form

394

Accessing Data and Data Analysis

Creating Calculations

EXAMPLE

Displaying average, maximum and minimum revenue

The following table has four different calculations for revenue. Notice that the

Average revenue, the Maximum and Minimum revenues and the Sum are all

displayed in separate rows in the order they were applied. Each figure is

identified by the name of the calculation. When you add a Percentage calculation,

BusinessObjects adds an extra column that shows each row as a percentage of

the total.

EXAMPLE

Calculating the difference in revenue between two quarters

In this example you have a crosstab that displays revenue per resort per quarter

and total revenue per quarter. You want to show in the table the difference in

revenue between two quarters. To do this:

1. Select Q2 with the mouse, then, holding down the Ctrl key, select Q1.

2. Click Variance Percentage on the Calculations toolbar.

BusinessObjects displays the difference in revenue between Q1 and Q2 for

each resort as a percentage in a new cell called Q2-Q1.

3. Select Q4 with the mouse.

4. Hold down the Control key and select Q3.

BusinessObjects displays the difference in revenue between Q1 and Q2 for

Variance

Percentage

VB.NET Image: How to Draw Annotation on Doc Images with Image SDK

other image annotating tutorials besides adding annotation using PDF document, image to pdf files and converting, compressing and stroing images, documents and

add photo to pdf form; add fillable fields to pdf

VB.NET TIFF: Read, Edit & Process TIFF with VB.NET Image Document

at the page level, like TIFF page adding & deleting controls, PDF document, image to pdf files and converting, compressing and stroing images, documents and more

adding text to a pdf form; edit pdf form

Accessing Data and Data Analysis

395

Calculations

each resort as a percentage in a new cell called Q4-Q3.

NOTE

You can also use the Shift key to select columns and rows. If you use the Shift

key, BusinessObjects does not take into account the order in which you selected

the columns and rows and always selects cells from top to bottom and from left

to right. If you carry out the calculation above using the Shift key,

BusinessObjects will calculate Q1-Q2.

X Re-using a calculation elsewhere in a report

You can drag a calculation from a table or a crosstab and place it in a different

position in a report. BusinessObjects keeps the formula with the cell. To do this:

1. Click inside the cell containing the calculation.

2. Click inside the cell again and, holding down your mouse button, drag the cell

to the desired position.

3. Release the mouse button.

NOTE

When you move a cell containing a calculation to a different part of the report, the

calculation result depends on where exactly the cell is positioned as this can

change the context in which the calculation is made. For more information on this

point see Calculation Contexts and Extended Syntax on page407.

EXAMPLE

Displaying total revenue as a table title

You have a report showing overall total and maximum revenues, and total and

maximum revenue by resort and service line. You want the total revenue to

appear at the top of the report. To do this:

396

Accessing Data and Data Analysis

Creating Calculations

1. Select the Sum cell at the bottom of the report and drag it to the top of the

report.

2. Click Cell on the Insert menu and type “Total Revenue” in the inserted cell,

then align it next to the cell you placed at the top of the report.

Mouse pointer during

drag operation

Accessing Data and Data Analysis

397

Calculations

3. Select the block at the bottom of the report that contains the overall sum and

maximum calculations and press the Delete key to delete it.

398

Accessing Data and Data Analysis

Creating Calculations

Converting to and from Euros

The following section describes how BusinessObjects uses built-in functions to

help you quickly and accurately convert a currency to or from euros.

What is the euro?

The euro is the official currency unit of the European countries that belong to the

EMU (European Monetary Union).

Each one of these countries has a conversion rate between the euro its former

national currency. EMU regulations stipulate how the conversion must be carried

out.

BusinessObjects euro conversion functions adhere to these stipulations.

Displaying the euro symbol

The euro is designated by an official symbol. To display this currency symbol in

BusinessObjects, you need to have a Windows operating system that can display

it or you need to install a euro font upgrade to your Windows operating system.

If your operating system cannot display the euro symbol, you can use the official

ISO three-letter code, EUR, instead.

How does the conversion work?

Each currency has a fixed conversion rate of six significant digits. The number of

digits after the decimal point depends on the number of digits before the decimal

point.

EXAMPLE

Converting to euros: six- digit conversion rates

The conversion rate for Dutch guilders (NLG) is 2.20371, with 1 digit before the

decimal and five after.

The conversion rate for Belgian francs (BEF) is 40.3399, with 2 digits before the

decimal point and four after.

To convert to euros from an EMU-compliant currency, you divide the local

currency amount using the six-digit conversion rate for that currency and then

round the result to display the appropriate number of decimal digits.

To convert from euros to an EMU-compliant currency, you multiply the amount in

euros by the six-digit conversion rate for the target currency and then round the

result to display the appropriate number of decimal digits.

Euro currency

symbol

Documents you may be interested

c# pdf to image conversion : Adding images to pdf forms SDK control service wpf azure asp.net dnn businessobjects_access_analysis39-part1876