|Independent multiple data sets [message #421401]
||Tue, 08 September 2009 02:28
Registered: August 2009
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.
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:
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:
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:
Then, the report preview is shown below:
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.