Report without the ugly headers from the subform

megatronixs

Registered User.
Local time
Today, 05:02
Joined
Aug 17, 2012
Messages
719
Hi all,

I have a database that has a subform in it. There is the group address data for the client. What I would like to do is to show the products from the client, but without the table look it gets when I produce the report. Is there a way to keep that awful header away from the report?
Any help in the good direction would be great.

Best regards,
megatronixs
 

Attachments

Why are you using a form in the report instead of a subreport. Just build a subreport and then format it just like you want.
 
Hi Boblarson,

I tried that one today at work and still looking the same, or unless I did something wrong.
Is there a particular way to follow so the ugly looking headers don´t show up?

Greetings
megatronixs
 
Hi Boblarson,

I tried that one today at work and still looking the same, or unless I did something wrong.
Is there a particular way to follow so the ugly looking headers don´t show up?

Greetings
megatronixs
Once you create it go into design view of the subreport and format it as you like. The label controls are what make the captions on the datasheet. Just delete all of the labels if you don't want any of them to show up.
 
Hi Boblarson,

I had a try with it, no luck. The header still show up like the headings from a data sheet (like the headers on top of the excel spreadsheet).
It would be great if I could get rid of it.
Please see attached file where you will find the report looking ugly with it.
(is there a way I can make the report take the ID from the open form? Now it ask me a little box to choose the ID nr)

Greetings,
megatronixs
 

Attachments

Hi Boblarson,

I tried that one today at work and still looking the same, or unless I did something wrong.
Is there a particular way to follow so the ugly looking headers don´t show up?

Greetings
megatronixs
You are still using af form as sub, you have to create a real report and use is as sub-report!
 
Hi JHB,

I just give up, I have no clue how to make this sub-report that is linked. Now all lines apear there. at least in the form I could link it to the ID nr and show only those the clients has, and not all.

Is it maybe possible to get an example to see how it works and I can learn from it. I was going trough google, but nothing found that could help.

Thanks in advance.
 
Do you know how to create a report? If so, you create a report the way you want to see it, not a form, but a report and in the report you can remove the report header, any titles for the fields, etc. Then save it.

Then drag and drop it onto your main report like you have been doing your form.
 
Hi JHB,

I just give up, I have no clue how to make this sub-report that is linked. Now all lines apear there. at least in the form I could link it to the ID nr and show only those the clients has, and not all.

Is it maybe possible to get an example to see how it works and I can learn from it. I was going trough google, but nothing found that could help.

Thanks in advance.

I've made an example for you, se the attached database.
 

Attachments

Hi all,

Thanks a lot for your help. Finally I got the trick :-) after seeing this, it looks so simple, but at the start I had no clue how to do this.

Really, thanks a lot.
 

Users who are viewing this thread

Back
Top Bottom