Skip to Content

Standard List Report


Hi, my name is Kumar, and in this video I will demonstrate how to create Standard List Report using components.

For that, let us go to Report Designer in iVend Management Console. In Management Console, go to Reports, then under menu Designer Label, select Report Designer. Report Designer screen appears. Here, put a Data Band on a page of Report Template. For that, click here and then click on Data Band.

Provide a Data Source, click on this new Data Source, Connection, and select the Data Source. Let us take a Table. I will take INVProduct. This is the table and let us choose some field like ID and Description and then Okay. Select the Data Source and Okay.

Now, let us edit the Data Band. You may align the Data Band by height. If you wish the Data Band to be broken then change the value of band properties such as set the Can Break property to True.

You can change the Data Band background also. Go to Brush and you can change the color from here.

You may enable the borders. From here, you can make the borders.

Also, you can change the color of the borders. So, in this way, you can edit the Data Band.

Now, let us put the Text Component with Expression in the Data Band where Expression is the reference to the Data Field. For example, let us put 2 Text Components with expressions which are INVProduct.ID and INVProduct.Description, so drag and drop the Text Component in the Data Band. Provide the Data column, ID. Let us increase, then put another Text Component, Data Column. Let us align the height and width of text components.

You can also align the text of the Text Component. You may change the background color of the Text Component. You can provide the borders of the Text Components and you may change the value of properties of the Text Component. For example, set the Word Wrap property to True if you need a text to be wrapped. This is the Word Wrap, make it True.

Now, we have a report template with a list. You may preview the report by clicking the Preview or you may press F5 to generate it. Let us press F5. After rendering all references, Data Field will be changed on Data from Specified Field. Data will be out put in consecutive order from the Database that was defined for this report. The amount of copies of the Data Band in the rendered report will be the same as the amount of data rows in the database. So, this is the Standard List Report created manually using component.

You may add other bands to the report template such as Report Title band and Report Summary band. So, let us go back to Report template. Here, let us drag and drop the Report Title Band. Go here, Report Title, and let us give a label here. Put a Text Component and let us give a name Standard List Report. Align it. You may edit the properties of the Title Band as well.

Now, let us put the Report Summary Band. This is the Report Summary Band. Drag and drop the Text Component in the band with Expression. Click on Summary, select the summary function, let us make it count, and say Okay. So, this is the Expression in the Text Component. The Expression in this Text Component will be a summary in report Summary Band.

Now, click preview or you can press F5 to generate this report. Let us press F5. So, this is the Title Band, and in last you will have the Count.

So, in this way you can manually create the Standard List Report using components.

With this, we end our session.

Thank you for watching this video.