How to outer border of group

arctushar

Registered User.
Local time
Today, 08:40
Joined
Feb 25, 2010
Messages
17
Helloo Everybody
I have a report which is as below
attachment.php


Now I want to display the report as below
attachment.php

Here you can see My needed report is outer bordered by son group field. As well as it skip blank cell ( grandson cell of Mozzem and Tushar)

So if it is possible then plz help me.
 

Attachments

  • current.jpg
    current.jpg
    38.2 KB · Views: 267
  • need copy.jpg
    need copy.jpg
    43.5 KB · Views: 264
There's two problems here. The first is to get the boxes to appear. The second is to remove the blank lines.

You can deal with the first problem by build a rectangle out of a series of lines.

In your Son group header section you will put the top line and two side lines that extend from the top line to the bottom of the group header section.

In your Grandson section you will put just the side lines extending the full height of the section.

In your Son footer section you will put side lines and the bottom line. The side lines will extend from the top of the footer section to the line.

If you've done all your lines correctly then they will all line up neatly and when you run the report you will see a rectangle.


For the second problem you need to enter some code like this in the On Format event for the Grandson section (this example assumes it's the detail section):
Code:
If Nz(Me.Grandson, "") = "" Then
    Me.Detail.Visible = False
Else
    Me.Visible = True
End If

Let me know if you need an example of all this.

Chris
 
Last edited:
In your Son group header section you will put the top line and two side lines that extend from the top line to the bottom of the group header section. I did not understand. How can I do this. Thank u stopher. If possible please attach example file
 
Last edited:
thank u stopher. but this is table only. where is report. I need the report setting with rectangle and skip of blank as I described earlier.
 
thank u stopher. but this is table only. where is report. I need the report setting with rectangle and skip of blank as I described earlier.
There's definitely a report unimaginatively named "report1". Take another look (in the reports section).

By the way, I created three separate tables for Father, Son, Grandson. This is obviously poor design and I did it purely to create a simple database to demonstrate the report, rather than bogging it down with self relationships.

Chris
 
There's definitely a report unimaginatively named "report1".

Yes sir I found it. I m extremely sorry. this was hidden. but How did u draw line in report. I tried but failed. Its amazing.
 
Sorry not solved

I changed the format of text box and report show this
attachment.php

Here you can see that james's child is blank. and also this vb code is not working. I deleted the code and appear same result. If possible work with my attached database file.
access01.PNG
 

Attachments

  • access01.PNG
    access01.PNG
    6.9 KB · Views: 286
  • father.mdb
    father.mdb
    324 KB · Views: 110
Last edited:
Here's you amended database. There was a slight error in my code.
Chris
 

Attachments

Still there is blank field in the report. here is the photo
attachment.php

did u tested this report view?
 

Attachments

  • father2.PNG
    father2.PNG
    8.3 KB · Views: 231
Did you view the report in "Print Preview" or "Report View". You will only see the effect in Print Preview.

Chris
 
Yea, Its fully working. Thank you. It would be pleasure for me if u explain the necessary of the code Debug.Print "here" as well as other code. thank u again
 

Users who are viewing this thread

Back
Top Bottom