How Create Collapsed & Expand Report

How Create Collapsed & Expand Report

 

If user want to create Collapsed & Expand reports using (+ -) in front of Group.

1. Open a new report and create a data-source, and create a relation in between 2 tables. (Here I am using 2 tables “InvProduct” and “InvProductGroup”).

 

2. Drag the Group-band Header & Footer and assign the Group column as using the above table select the ProductGroupId as Group Column.

 

3. Select the Group band > Go to property panel > select Interaction Property

 

4. The interaction window > Select Collapsed from right panel > put the formula using same format {GroupLine!=0} for all groups comes with + sign as Collapsed mode, {GroupLine!=1} to display first group with – sign and it will comes with Expand mode, and then select the check-box on Collapsed Enabled and select the check-box on Collapsed Group Footer . (See Image 1).

 

5. Now see the preview, like in Image 2. The group display with all Collapsed mode.

 

6. Now see the preview, like in Image 3. The first group display with all Expand mode and remaining with Collapsed mode

          

 

• Related Articles

• iVend POS Drill-Down Report

  iVend Retail POS - Drill-Down Report This article explains the basic steps for creating a drill-down report. A Drill-Down report is an interactive report in which blocks can collapse and expand their contents by clicking on the block title. Follow ...

• iVend POS - Report with Sub-Report

  Report with Sub-Report The following are the steps to create a Report displaying the Sub-Report data: On the report Designer right clock on the iVend Connection under the Data source. Then click on New Data Source Figure 1 Report Designer Click on ...

• iVend POS - Standard Report

  iVend Retail POS – Creating a Standard Report using the Wizard This article provides the basic steps for creating a Standard Report through the use of the Report Wizard. When creating a report using the Standard Report Wizard, the report will contain ...

• iVend POS - Label Report

  iVend POS - Label Report This article provides the basic steps for creating a Label Report in iVend Retail. In iVend, the user can design their own label(s) using the following two options: · Thermal Label Setup · Report Designer Label Report Thermal ...

• iVend POS - Graphical Report

  iVend Retail POS - Graphical Report This article explains the basic steps for creating a Graphical Report. 1.On the Report designer click on components and then charts. Figure 1 Report Designer Put the Chart component on a page as seen in the picture ...