Report Formatting

%3CLINGO-SUB%20id%3D%22lingo-sub-2018948%22%20slang%3D%22en-US%22%3EReport%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2018948%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20client%20pulling%20a%20large%20report%20from%20a%20DB%2C%20but%20they're%20running%20in%20to%20a%20problem.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20example%20below%2C%20Box%201%20is%20data%20pulled%20from%20the%20database%20that%20contains%20numbers%2C%20dates%2C%20costs%20etc.%20Each%20line%20is%20individual%20data.%20The%20data%20in%20box%202%20is%20all%20descriptive%20text%2C%20that%20can%20be%20any%20amount%20of%20text%2C%20and%20again%2C%20each%20section%20is%20individual%20data.%20If%20text%20in%20any%20one%20of%20the%20sections%20in%20box%202%20runs%20long%2C%20creating%20a%20second%20page%20for%20a%20print%20out%2C%20the%20data%20in%20box%201%20gets%20split%20in%202.%20Some%20on%20page%201%2C%20some%20on%20page%202.%3C%2FP%3E%3CP%3EI%20need%20to%20find%20a%20way%20to%20fix%20the%20data%20in%20box%201%20so%20it%20stays%20below%20the%20image.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20not%20a%20pro%20with%20Access%2C%20far%20from%20it%2C%20so%20reaching%20out%20for%20any%20advice%20I%20can%20get.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22dmillar_0-1609188530296.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F243235i37C06F9430136056%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22dmillar_0-1609188530296.png%22%20alt%3D%22dmillar_0-1609188530296.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2018948%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2019285%22%20slang%3D%22en-US%22%3ERe%3A%20Report%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2019285%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F631361%22%20target%3D%22_blank%22%3E%40dmillar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20first%20attempt%20at%20resolving%20this%20would%20be%20to%20create%20a%20subreport%20with%20just%20the%20information%20that%20needs%20to%20remain%20together%2C%20and%20a%20second%20subreport%20for%20the%20information%20that%20can%20exceed%20the%20one%20page.%20But%20without%20seeing%20REAL%20data%20and%20REAL%20reports%2C%20that's%20just%20a%20potential%20thought%20to%20explore.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Visitor

I have a client pulling a large report from a DB, but they're running in to a problem.

 

In the example below, Box 1 is data pulled from the database that contains numbers, dates, costs etc. Each line is individual data. The data in box 2 is all descriptive text, that can be any amount of text, and again, each section is individual data. If text in any one of the sections in box 2 runs long, creating a second page for a print out, the data in box 1 gets split in 2. Some on page 1, some on page 2.

I need to find a way to fix the data in box 1 so it stays below the image.

 

I'm not a pro with Access, far from it, so reaching out for any advice I can get.

 

Thanks in advance.

 

dmillar_0-1609188530296.png

 

3 Replies

@dmillar 

My first attempt at resolving this would be to create a subreport with just the information that needs to remain together, and a second subreport for the information that can exceed the one page. But without seeing REAL data and REAL reports, that's just a potential thought to explore.

לא הבנתי
הבנתי חלקית
הסבירו שוב וקראו בבקשה את ההודעה שלי

@love_life 

Sorry, but I don't know what you wrote. It would help to use English, the language in which this forum is supported.