Home » Other » Marketplace » Independent multiple data sets (RAQ Report 4.0)
Independent multiple data sets [message #421401] Tue, 08 September 2009 02:28
juniormy
Messages: 11
Registered: August 2009
Location: US
Junior Member

RAQ Report Development Edition supports multiple data sets and correlative multiple data sources.

RAQ Report Free Edition supports multiple data sets in report properties.

The functions about multiple data sets in these two editions are different. Many users of Free Edition don't know how to use the multiple data sets function, and we will introduce the using method of this function.

In RAQ Report Free Edition, this function is called multiple data sets in report properties. It means that other data sets can be used in report properties.

Next, we will explain this concept with an example.

Example

Step 1: Use the database demo of RAQ Report to make dataset ds1 for order report.

The SQL statements is "SELECT Order.OrderID,Order.EmployeeID,Order.CustomerID FROM Order". Then, corresponding grid report is generated as shown below:

https://54ruma.blu.livefilestore.com/y1mw5_6SK4cwtP5V1cDsr0afAk_r3pp7fMpx6e94-PSw9JaWL6FAM3L0bnJeCX4SX9L7foYvnAkT-KRjZUg69QXD29_CTpBcJKjINVSubGCcPZFF5rpbJZFgp_m3gpB-G7gAy9qRvsdNnUCFT_TSJTHgQ/clip_image002_thumb%2069E31157.jpg

We can see that we only get employee IDs and customer IDs in order report, but we need to know the names of employees and customers. Therefore, we need to get the names from employee table and customer table. Then, we will use multiple data sets.

Next, we will display the content of 3 data tables in the report, and change the IDs of employees and customers to names in next 2 steps. They are are very important, and please pay more attentions to them.

Step 2: Add two datasets ds2 and ds3 from employee table and customer table.

The SQL statement of ds2 is "SELECT Customer.CustomerID,Customer.COMName FROM Customer".

The SQL statement of ds3 is "SELECT Employee.Employee ID,Employee.EMPName FROM Employee"..

Now, there are 3 datasets as shown below:

https://54ruma.blu.livefilestore.com/y1mEd_7twbshbN_aKTmpNlACr-JMKHlvWGI6nXSfbrE_ZzN8w98fHeQHlWFvaxrL5Clc_Of5QFqdYTCoMGe4j1QnpxWfmxlUaaVn76nZ2hzx2tdzgy6NcuYFXn2P2C4301_GYtT1EYhch3WsKgaC8alpQ/clip_image003_thumb%202A026055.jpg

Next, we will learn to use multiple datasets in report properties. This is the most important step, and it is all done in the properties bar.

In RAQ Report, cell has two values, actual value and display value. In the example above, employee IDs and custom IDs are actual values. After correlating them with display values, they will display employee names and customer names.

Step 3: Select cell B2, and set the display value of employee ID by writing the display value expression as "ds3.select1(EMPName,EmployeeID==value())". Then, select cell C2, and set the display value of customer ID by writing the display value expression as "ds2.select1(COMName,CustomerID==value())". As shown below:

https://54ruma.blu.livefilestore.com/y1mdejNW1n1lKOSEyFAvIlbWv2H1PfMu0eBHCJMcrCI5Xw0c2HoNG2_UOxwYMmiA8JzqxtaEbTh0lKHf0r9frLIDQqASOGNAKOVjVLhMHu06Dp50251xoHY7iXTFMzlm6UCkXlsvMQD69Z9aL4PUBZmaA/clip_image005_thumb%205B0FF1DA.jpg

Then, the report preview is shown below:

https://54ruma.blu.livefilestore.com/y1m3voC3SUHtFUO9Fz0ZEMyVs0Ghg6Z_tj_C7ONvosjBYCiSXOGYuaXY6odxhuu8zK-S_xzTQ0QT9HFLpcb8tebwsDe9LmlTn2_HT9FRWKI7X8ur56McWGAIsGat3ryYX7r9ZHHtGmb9bxmI0LR4d81Ag/clip_image007_thumb%205852FC5D.jpg

Now, employee names and customer names are displayed in the report. After changing employee IDs and customer IDs to employee names and customer names in the report header, a report with multiple datasets is made with RAQ Report.

P.S.: RAQ Report Free Edition can only use multiple data sets in report properties, so it is called independent multiple data sets in report properties.

RAQ Report Development Edition can use multiple data sets in report cells directly, and it is more allsided correlative multiple data sources.

Previous Topic: Schema Version Control for Oracle with Extension for SQL Developer
Next Topic: Urgent opening for Peoplesoft Finance(Technical)
Goto Forum:
  


Current Time: Thu Sep 29 19:16:06 CDT 2016

Total time taken to generate the page: 0.09204 seconds