﻿
Accessing Data and Data Analysis
499
More examples of using formulas
EXAMPLE
Calculating total revenue for all resorts when some are filtered out
In this example you have a report containing the top two resorts in a report
showing resorts, their countries and their associated revenues. You restrict the
report to the top two resorts by placing a rank on the Resort column.
If you insert a Sum calculation on the Revenue column, BusinessObjects uses
the following formula by default:
Sum(<Revenue>)
which gives the following result:
Why is this different from the result above? By default the Sum function takes into
account only the revenues in the block; the sum shown is the total revenue for
the Hawaiian Club and Bahamas Beach resorts. The French Riviera resort is
filtered from this report by the rank on the Resort column. However, you need to
include its revenue in the calculation of total overall revenue. The NoFilter()
function makes this possible. This function tells BusinessObjects to ignore filters
when calculating, so the formula
NoFilter(Sum(<Revenue>))
returns the total revenue for all resorts.
Pdf forms save - 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
add form fields to pdf without acrobat; adding form fields to pdf
Pdf forms save - 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
changing font in pdf form; add an image to a pdf form
500
Accessing Data and Data Analysis
Formulas, Local Variables and Functions
C# PDF: PDF Document Viewer & Reader SDK for Windows Forms
objects, zoom PDF document page, view PDF file in different display formats, and save source PDF file using C# code within a .NET Windows Forms application.
create pdf form; pdf form creation
C# PDF: How to Create PDF Document Viewer in C#.NET with
Eaisly save and print designed PDF document using C# code; PDF document viewer can be created in C# Web Forms, Windows Form and mobile applications.
convert word doc to pdf with editable fields; pdf form creator
part
Appendix
C# PDF Convert to Images SDK: Convert PDF to png, gif images in C#
Besides raster image Jpeg, images forms like Png, Bmp inputFilePath); // Get the first page of PDF. bitmap1 = page.GetBitmap(); bitmap1.Save(inputFilePath + "_1
VB.NET PDF: VB Code to Create PDF Windows Viewer Using DocImage
with great capabilities to view, annotate, process, save and scan and BMP) and document files (TIFF, PDF and Word NET, VB.NET, ASP.NET and .NET Windows Forms.
allow saving of pdf form; change font in pdf form
C# PDF Page Insert Library: insert pages into PDF file in C#.net
web server-side application and Windows Forms project using a outPutFilePath = Program.RootPath + "\\" Output.pdf"; PDFDocument doc1 doc2.Save(outPutFilePath
change font pdf fillable form; pdf form save
Save, Print Image in .NET Winforms | Online Tutorials
& printing capabilities into your Windows Forms applications Covert Format to Others; Save & Print Image Tiff Processing; RasterEdge OCR Engine; PDF Reading; Encode
add email button to pdf form; best way to create pdf forms
a
ppendix
the Run Command
VB.NET Word: VB Code to Create Windows Word Viewer | Online
Word documents displaying, processing and printing in .NET Windows Forms project. Word Windows Viewer enables developers to load, view, process, save and print
VB.NET Image: How to Save Image & Print Image Using VB.NET
ASP.NET web application or .NET Windows Forms project, without Allow VB.NET developers to save source image file to multi-page document files, like PDF and Word
create a fillable pdf form from a word document; create a pdf form from excel
504
Accessing Data and Data Analysis
Launching BusinessObjects with the Run Command
Overview
This appendix explains how to run BusinessObjects by using the Run command
on Windows. You can use the Run command as an alternative way of double-
clicking the BusinessObjects icon. You can also specify command line options
such as your user name, password and other options.
C# PDF: Start to Create, Load and Save PDF Document
void Save(String fileName); void SaveToStream(Stream stream ASP.NET AJAX, Silverlight, Windows Forms as well & profession imaging controls, PDF document, image
convert word to editable pdf form; adding signature to pdf form
VB.NET TIFF: Demo to Create a TIFF Windows Viewer in .NET
_Quality_" + QualityPercentage + "%.tif") bm.Save(newFileName, ici NET AJAX, Silverlight, Windows Forms as well profession imaging controls, PDF document, image
adding image to pdf form; change font size in pdf form field
Accessing Data and Data Analysis
505
Using the Run command
Using the Run command
The following procedure describes how to launch BusinessObjects by using the
Run command. The options you can include in the Run command are listed and
explained in “Run command options” below.
1. Click the Start button, then click Run on the Start menu.
The Run dialog box appears.
2. In the Open text box, enter the path to the BusinessObjects executable file
(Busobj.exe). By default, this file is located in the BusinessObjects folder. You
can click Browse to specify the path, rather than type it.
3. Click OK.
The User Identification dialog box appears.
provided, then click OK.
The BusinessObjects application is now launched.
506
Accessing Data and Data Analysis
Launching BusinessObjects with the Run Command
Run command options
Run command options allow you to log in to BusinessObjects with your user
name and password. The table below describes the options that you can use.
Option
Description
-user [user name]
The user name assigned to you by your supervisor.
User names that include spaces must be written in
double quotes, for example “user name”.
The password assigned to you by your supervisor.
This option is mandatory if you enter the -user
option. Passwords that include spaces must be
written in double quotes, for example “my
-online or
-offline
By default, the last connection mode of the specified
user, or “online” the first time you launch
Offline mode disconnects you from the repository
and therefore disables remote connections during
your work session.
repname.rep
The name of the document that you wish to work
with on launching BusinessObjects. You must
include the path to this file, for example:
-keyfile [keyfile name
If you are working with multiple repositories,
specifies the repository you want to work with.
-nologo
Runs BusinessObjects without showing the logo
screen.
-vars myfile.txt
Name of a text file in which variables are specified.
You can specify BOUSER and BOPASS, which
manage your access to BusinessObjects. You can
also declare your own variables in the file. For more
information on these variables, refer to “Specifying
BOUSER, BOPASS and Other Variables” below.
Accessing Data and Data Analysis
507
Using the Run command
TIP
In the file you declare after the -vars option, you can also specify the variables
such as DBUSER, DBPASSWORD and DBDSN. (The names of such variables
depend on the database at your site). These variables can be used to define a
restriction on an object, for example. For further information on these variables,
refer to “BusinessObjects Variables” in the Database Guide included in your
Specifying BOUSER, BOPASS and Other Variables
You can use the BOUSER and BOPASS variables to manage your access to
BusinessObjects. You can specify the values of these variables in the Run
command, or in a file that you call from the Run command. Other variables can
be declared in this file.
BOUSER and BOPASS
When the BusinessObjects supervisor creates users, they assign each one a
user name and password. The user’s name and password are stored on the
repository. When you log in to BusinessObjects in online mode, which is the
your security information. Your user name and password are then written to
either the objects.lsi file or the objects.ssi file, located in either the ShData folder
or the LocData folder.
Once you have launched BusinessObjects in online mode, you can use the
BOUSER and BOPASS variables in the Run command. You can:
• Declare the value of the variables after -user and -pass.
For example, if your supervisor assigned you the user name JOHN and the
password SMITH, you can write the following command: