By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,960 Members | 1,142 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,960 IT Pros & Developers. It's quick & easy.

Advanced Report Formatting Resource?

P: 14
Hi everyone,

I'm making reports that are based on queries, and the data has several levels of grouping.

I have set up a report with several nested group headers, but I'm currently stuck where either my data shows up multiple times (in the case that I have the data in the header section) or it has a big gap in spacing (if it's in the detail section).

I've narrowed down the problem to the fact that I have parents (group headers) that have the same data as the children in nested group headers which is the same as the children in the detail section.

Does anyone know of any resources for relatively advanced Access Report formatting? I've surfed around, and I find a lot of basic examples, but nothing when you've got even slightly complicated data...

Help?

Thanks,
Lea Ann
Oct 18 '06 #1
Share this Question
Share on Google+
3 Replies


PEB
Expert 100+
P: 1,418
PEB
Hi,

Pay attention with the grouping in your query...

Open your query first and see the result of it.. If there is repetition so the problem is in the query and it concerns the grouping!

Best regards
Oct 21 '06 #2

MMcCarthy
Expert Mod 10K+
P: 14,534
Can you post the query you are using for the report that may be the problem.

You could also look at creating subreports for each of the groups.

Hi everyone,

I'm making reports that are based on queries, and the data has several levels of grouping.

I have set up a report with several nested group headers, but I'm currently stuck where either my data shows up multiple times (in the case that I have the data in the header section) or it has a big gap in spacing (if it's in the detail section).

I've narrowed down the problem to the fact that I have parents (group headers) that have the same data as the children in nested group headers which is the same as the children in the detail section.

Does anyone know of any resources for relatively advanced Access Report formatting? I've surfed around, and I find a lot of basic examples, but nothing when you've got even slightly complicated data...

Help?

Thanks,
Lea Ann
Oct 23 '06 #3

NeoPa
Expert Mod 15k+
P: 31,343
I don't think this is gonna help too much, but I get all my info from the help files then, if that's no good (whenever?!?), I look on the web - that's how I found these forums.
Oct 24 '06 #4

Post your reply

Sign in to post your reply or Sign up for a free account.