Accessing Data and Data Analysis
371
Building combined queries
NOTE
If the universe designer has set the up the universe with a restrictive connection, 
BusinessObjects prompts you to enter your database username and password 
before parsing the script. For more information on restrictive connections, see 
Restrictive connections on page 40
6. Click Save to save the edited script to a file.
7. Click OK to return to the Query Panel.
Save
Change font size in pdf form field - 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 submit button to pdf form; adding a signature to a pdf form
Change font size in pdf form field - 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
can reader edit pdf forms; create pdf forms
372
Accessing Data and Data Analysis
Customizing Queries on Universes
C# PDF File Compress Library: Compress reduce PDF size in C#.net
can help to reduce PDF file size effectively. RasterEdge.Imaging.Font.dll. ops.MonochromeImageOptions.TargetResolution = 150F; // to change image compression
adding text to a pdf form; adding images to pdf forms
VB.NET PDF File Compress Library: Compress reduce PDF size in vb.
can help to reduce PDF file size effectively Reduce font resources: Font resources will also take up too TargetResolution = 150.0F 'to change image compression
adding signature to pdf form; adding form fields to pdf
c
hapter
Using and Customizing Lists of 
Values
C# PDF Sticky Note Library: add, delete, update PDF note in C#.net
Allow users to add comments online in ASPX webpage. Able to change font size in PDF comment box. Able to save and print sticky notes in PDF file.
change font size pdf fillable form; change font size in pdf fillable form
C# PDF insert text Library: insert text into PDF content in C#.net
Powerful .NET PDF edit control allows modify existing scanned PDF text. Ability to change text font, color, size and location and output a new PDF document.
pdf forms save; adding form fields to pdf files
372
Accessing Data and Data Analysis
Using and Customizing Lists of Values
Overview
This chapter describes lists of values (LOVs) and how you can use them to make 
your reports more efficient.
C# PDF Annotate Library: Draw, edit PDF annotation, markups in C#.
Support to add text, text box, text field and crop marks to PDF document. Able to edit and change PDF annotation properties such as font size or color.
create a fillable pdf form online; adding a text field to a pdf
C# PDF Text Box Edit Library: add, delete, update PDF text box in
Support to change font color in PDF text box. Ability to change text size in PDF text box. Adding text box is another way to add text to PDF page.
add attachment to pdf form; create a fillable pdf form
Accessing Data and Data Analysis
373
What is a list of values?
What is a list of values?
A list of values contains the values returned by an object. You use lists of values 
to select the value(s) you need when defining conditions on a query or when 
selecting the value(s) in a prompt.
When you use or view a list of values for the first time, BusinessObjects creates 
a .lov file that contains the query definition and the values it returns. By default, 
.lov files are located in sub-folders inside the UserDocs folder.
C# PDF Convert to Word SDK: Convert PDF to Word library in C#.net
PDF document, keeps the elements (like images, tables and chats) of original PDF file and maintains the original text style (including font, size, color, links
cannot save pdf form in reader; adding text to pdf form
VB.NET PDF Form Data Read library: extract form data from PDF in
RasterEdge.Imaging.Font.dll. As String = Program.RootPath + "\\" 1_AF.pdf" Dim fields ToString()) Console.WriteLine(" Size: " + field.Size.ToString()) Next
add print button to pdf form; cannot save pdf form
374
Accessing Data and Data Analysis
Using and Customizing Lists of Values
How are lists of values created?
In Designer, the universe designer decides whether to associate a list of values 
with an object. Once associated, the list of values can be viewed or edited in 
Designer or BusinessObjects.
The first time you view an object’s list of values, BusinessObjects runs a query 
and retrieves the values from the database; the object’s default list of values is 
generated by the object query.
C# PDF Form Data Read Library: extract form data from PDF in C#.
RasterEdge.Imaging.Font.dll. Program.RootPath + "\\" 1_AF.pdf"; List<BaseFormField Position.ToString()); Console.WriteLine(" Size: " + field.Size.ToString
create a pdf form from excel; change font size in pdf form field
Accessing Data and Data Analysis
375
Customizing lists of values in BusinessObjects
Customizing lists of values in BusinessObjects
You can customize lists of values in the following ways:
• By editing the list’s corresponding query.
For example, you can limit the data returned by a list of values by applying a 
condition.
• By assigning data from personal data files.
This feature is especially useful if you always use the same subset of the values 
available in the database when applying conditions. You can view only the values 
you need without having to connect to your remote database. For more 
information, refer to Assigning personal data to a list of values on page380.
376
Accessing Data and Data Analysis
Using and Customizing Lists of Values
Editing lists of values
The universe designer decides whether a list of values is editable in 
BusinessObjects. You can edit a LOV only if the designer has granted you the 
right to do so.
Because the list of values is a query, you edit it by editing its corresponding query 
in the Query Panel. You can edit the query by:
• applying conditions to restrict the values returned
• applying sorts to order the values
• building a combined query
• including additional objects in the query
The following example shows you how to edit a list of values.
EXAMPLE
Showing cities and regions in a list of cities
The Island Resorts Marketing universe has a City object. However, it is possible 
for cities in different regions to have the same name. To identify a city precisely, 
you want to display the city’s region along with the city’s name in a list of values. 
To do this:
Accessing Data and Data Analysis
377
Editing lists of values
1. Click Universes on the Tools menu.
The Universes dialog box appears.
2. Select the Island Resorts Marketing universe and click List of Values.
3. Navigate to the City object beneath the Customer class.
378
Accessing Data and Data Analysis
Using and Customizing Lists of Values
4. Click Edit.
The Query Panel appears showing the query for the City object’s list of 
values.
5. Add the Region object to the query.
6. Click Run.
Now when you see the City list of values dialog box it shows the cities and their 
regions.
Documents you may be interested
Documents you may be interested