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

Too many fields in a report

P: 78
I am have a report that has too many fields.

The fields I need to display in the report are all required and they take about 277 fields to create.

I can acheive the desired result by calling subform(s) if I am not mistaken. (correct me if I will still be limited on my fields) However, I need each of the subforms to pull data in regards to my paramater query on my main report. I can acheive this by adding the paramater field in each subform but then it will ask the parameter for every subform on my report. Is it possible to make it so I only ask the parameter once?

The report is serving as a complete listing of an entry in my database. (seperate but 1to1 linked tables linked by the main table AutoNumber)
Nov 23 '11 #1
Share this Question
Share on Google+
10 Replies


Rabbit
Expert Mod 10K+
P: 12,342
I seriously think you need to reconsider the design of the report. I can't think of any reason anyone would need to see 277 fields all the time all the way across. How would they even manage it? And that's not to mention the overhead of running and rendering such a report.
Nov 23 '11 #2

P: 78
The report is in regards to real estate. It describes the property in full detail. It fits to a legal 8.5" x 14". It contains various data related to the property such as room dimentions, heating, layouts, legal information, sale, information, exterior conditions, and more.

This report will generally be used to reflect one complete record set.

I included a sample pic.

Thanks you for taking the time to help Rabbit.

I tried making a section into a subform and it works as desired. However. I have to enter my parameter query answer twice. Is it possible to make it so the paraent parameter setting will be adopted by the child subfrom?

Attached Images
File Type: jpg Sample.jpg (101.4 KB, 603 views)
Nov 23 '11 #3

Rabbit
Expert Mod 10K+
P: 12,342
Not that I know of. However, you could create a form where the user enters in the required values and then the report can reference the controls on the form.
Nov 23 '11 #4

NeoPa
Expert Mod 15k+
P: 31,308
You can link subforms to their parent data by specifying the Link Child Fields and Link Master Fields properties, but this won't necessarily ensure there is no need for the value to be prompted again.
Nov 24 '11 #5

100+
P: 759
Just an idea:

Declare all parameters as public variables, set the values from the main form and use it where you need.
Nov 24 '11 #6

P: 78
Mihail,

That sounds like it could work. Can you provide an example?
Nov 25 '11 #7

NeoPa
Expert Mod 15k+
P: 31,308
That may work for you, but I should warn you it is a clumsy approach that will lead to further complication down the line.

An appreciably more sensible approach would be to recognise the wisdom of post #4 by Rabbit. It really isn't a good idea in a proper project to be using parameter queries at all.
Nov 25 '11 #8

P: 78
I'm not completely sold on a parameter query if it is not needed. I am using the report to display a complete record of a property. Their are several tables which are joined by a 1:1 relationships. I just need to list all the fields on a single (printable) report. Currently it is set up as a parameter query which asks for the Primary key (BWA_ID).

In regards to Rabbit in post#4. I don't quite understand. I have a form that has all the controls on it that would be used in the report(Input Form). I don't understand how this would solve my too many field issue.

Thanks for your help as always.
Nov 25 '11 #9

NeoPa
Expert Mod 15k+
P: 31,308
It means you don't need to use parameters. This is what the question of this thread is (See post #1). If you need help with anything else then you should ask for it in a thread for that new question.
Nov 25 '11 #10

100+
P: 759
Hope you can use that (see attachment) to reduce the fields number in your report by replacing with text boxes.

Good luck !
Attached Files
File Type: zip Demo_UsingPublicVariables.zip (44.5 KB, 75 views)
Nov 26 '11 #11

Post your reply

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