Click any where n the Year Header band ( Notice that the "Bands" are named on the left of the report design window and color coded - Blue for group headers and footers ).To add the year field into the "Year" group header:. ![]() The query looks like this then:įine - now how about adding some fields to the report. I will then sort the results based by YEAR first, then MONTH. What I will use are the functions YEAR, MONTH, MONTHNAME. Now I want to add 3 Calculated fields, each is going to be based on the Date field, so I just double click the Date field 3 times. I created a table that mimics the one you described and named the table tblIncomeExpense - just open a query design window and add the table to the designer window and select all fields by double clicking the asterisk. One thing also, I am going to add one more grouping and this is by year. So, the first step is to get the data into a nice format - by which I mean that I will add a couple of Calculated Fields and sort on these in the query. I like to go the second route and that is what I am going to do here. The next thing is that there are really two ways to go - you can either do all the sorting and grouping in the report writer or you can prep the data in a query first. ( This is the latest version available at the extensions download site and has a bug in it under 2.4.1, but the patched file should be available very shortly ). To do this I am going to use the SUN Report Builder extension, release 1.0.4.
0 Comments
Leave a Reply. |