Problem with report (1 Viewer)

[Ramshan]

Hi everyone,

I am having some problem in displaying the report. I have several columns(64 fields) for each record and I am finding it difficult to make it fit in a report after querying for the data. Can someone help me on this.

Thanks in advance!

 

[vbaInet]

Are all 64 fields coming from one table?

 

[Ramshan]

Yes, all from one table.

 

[carl024]

attach the file i check it

 

[Ramshan]

Hi,

I have attached the table with this message. Can u just create a report that will fit all the 60 odd fields when we query it.

Thank you! Appreciated

 

[vbaInet]

I'm afraid there's nothing I can help with on that front because your table is not normalized. I would advise that you read up on this topic, break your table into meaningful related tables then revisit your report. You will find that everything will fit in nicely once it's normalized.

To get you started, here are some articles on normalization:

http://support.microsoft.com/kb/100139
http://www.deeptraining.com/litwin/dbdesign/FundamentalsOfRelationalDatabaseDesign.aspx

And here's one on data models:

http://www.databaseanswers.org/data_models/

 

[Ramshan]

But I got to do this task in a single table. I am not supposed to split up this table into many by applying data normalization to it. So, is there anyway to perform this task?

Thank you!

 

[vbaInet]

There's really no magic that can be performed to make them fit. You can do things like reduce the font size, reduce the size of the textboxes, change the orientation to Landscape, place your textboxes in a tabular format.

That's about all you can do.