Report "Detail" Section

[ariel81]

refer to the attached .jpg file:

the report in design view, under the "Detail" section
there are 5 textboxes:

1st textbox for month
2nd textbox for year
3rd textbox for AE
4th textbox for EI
5th textbox for RC

during report run time,
the group of 5 textboxes will multiply itself to display all the datas which are inside the table.

my question is, how can i prevent the group of 5 textboxes from multiplying itself?

how to make one group of textboxes reference to one row inside the table and another group of textboxes reference to another row inside the table.
e.g: one group of textboxes reference to month "1", another group of textboxes reference to month "2", etc...

 

[boblarson]

In edit mode, click the control you want to not show duplicates and in the properties find the HIDE DUPLICATES property and change NO to YES.

 

[ariel81]

boblarson:

In edit mode, click the control you want to not show duplicates and in the properties find the HIDE DUPLICATES property and change NO to YES.

thank you. however, by changing HIDE DUPLICATES property from NO to YES only makes repeated data not to show.

i want to have a group of 5 boxes for each month. if there are 12 months then there will be 5 * 12 = 60 textboxes.

the report should looks something like this:

   Mth/Yr           AE              EI              RC
=======            ===            ===           ===

Jan/ 2007           12              13             14         <-  5 textboxes
Feb/ 2007          12              15             16
Mar/ 2007          12              13             16
Apr/ 2007          17              15              18
May/ 2007                         
Jun/ 2007      
Jul/ 2007           20              15             19
Aug/ 2007      
Sep/ 2007         21
Oct/ 2007                          31  
Nov/ 2007                                          40
Dec/ 2007          12              13             19         <-  5*12 = 120 textboxes (total)

reference to the abv sample, for May, Jun, Aug...even where there's no data for (AE,EI,RC) the report should be able to print it's corresponding mth/yr even when there's no data for it.

 

[ariel81]

hi,
refer to the attached (report1.jpg). how shall i design the report to print out months without data?

refer to the attached (report1.jpg). how shall i design the report from the (bottom left) to make it become to the (bottom right)?

thanks...

 

[boblarson]

The trick is in the query. The normal method is to change your query to a left OUTER join - in other words Select all records from one table and only those records which match in the other. The usual join is a left INNER join, which takes all records that has a match in both tables.

Now, if there isn't any way to get a left outer join to return all months, then you can synthesize one by first creating a table with all months in it and then using that as the first table in the left outer join.

 

[ariel81]

i've created a "Function testing(ReportMth)" in the modules. then created 12 textboxes in the report and their control source set from " =testing(1)"...to " =testing(12)" respectively.

after that, i created another 12 "unbound" textboxes to display the data. it works...

see (report3.gif)