Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 09-20-2019, 02:32 AM   #1
michal.r.1024
Newly Registered User
 
Join Date: Sep 2019
Posts: 6
Thanks: 4
Thanked 2 Times in 1 Post
michal.r.1024 is on a distinguished road
Report with subreport excel export alignment problem

Hi guys,

I have an Access report containing its own "table" part and two additional subreports under with similar content. I tried my best to make the additional reports aligned right under the first one in Access report view. However, as soon as I export it to Excel, the first report is aligned properly (begins in left upper corner), but the two other subreports are placed under the right down corner of the first report (see my professional diagram drawing attachment). Could you please provide me some advices? I tried many things and nothing worked.


Thanks,
Michal
Attached Images
File Type: png Untitled.png (6.0 KB, 25 views)

michal.r.1024 is offline   Reply With Quote
Old 09-20-2019, 02:47 AM   #2
JHB
Have been here a while
 
Join Date: Jun 2012
Location: In the south of Denmark (Jutland), near the German border.
Posts: 7,720
Thanks: 3
Thanked 2,082 Times in 2,037 Posts
JHB has a spectacular aura about JHB has a spectacular aura about
Re: Report with subreport excel export alignment problem

How do you export it to Excel?
Is it possible for you to post your database with some sample data, (zip it because you haven't post 10 post yet!)?
__________________
If the above post has helped you, why not take the time to say thank you, by pressing the "Thumbs up."
JHB is offline   Reply With Quote
The Following User Says Thank You to JHB For This Useful Post:
michal.r.1024 (09-20-2019)
Old 09-20-2019, 02:48 AM   #3
CJ_London
Super Moderator
 
Join Date: Feb 2013
Location: UK
Posts: 11,400
Thanks: 40
Thanked 3,689 Times in 3,553 Posts
CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light
Re: Report with subreport excel export alignment problem

crossposted here https://www.accessforums.net/showthread.php?t=78336

@michal - please take a look at this link about the etiquette of cross posting.http://www.excelguru.ca/content.php?184
It's not wrong to crosspost, but is wrong not to say you are doing it and provide the link(s)

__________________
CJ_London
_______________________
A little thanks goes a long way. If you have found this post useful, please tick the thanks button
CJ_London is offline   Reply With Quote
The Following User Says Thank You to CJ_London For This Useful Post:
michal.r.1024 (09-20-2019)
Old 09-20-2019, 04:46 AM   #4
michal.r.1024
Newly Registered User
 
Join Date: Sep 2019
Posts: 6
Thanks: 4
Thanked 2 Times in 1 Post
michal.r.1024 is on a distinguished road
Re: Report with subreport excel export alignment problem

Quote:
Originally Posted by CJ_London View Post
crossposted here
@michal - please take a look at this link about the etiquette of cross posting.
It's not wrong to crosspost, but is wrong not to say you are doing it and provide the link(s)

My apologies for that. I really did not have a clue about that this is a problem, I will know next time, thanks.


Quote:
Originally Posted by JHB View Post
How do you export it to Excel?
Is it possible for you to post your database with some sample data, (zip it because you haven't post 10 post yet!)?

I export it via External data -> Excel. Im going to create sample data DB and post it here in a while.
michal.r.1024 is offline   Reply With Quote
Old 09-20-2019, 05:43 AM   #5
michal.r.1024
Newly Registered User
 
Join Date: Sep 2019
Posts: 6
Thanks: 4
Thanked 2 Times in 1 Post
michal.r.1024 is on a distinguished road
Re: Report with subreport excel export alignment problem

Quote:
Originally Posted by JHB View Post
How do you export it to Excel?
Is it possible for you to post your database with some sample data, (zip it because you haven't post 10 post yet!)?

Here I created sample access DB with report that has been created exactly with the same pattern like my original one. The attached export behaves exactly as well.
Attached Files
File Type: zip files.zip (31.5 KB, 17 views)
michal.r.1024 is offline   Reply With Quote
Old 09-20-2019, 10:35 PM   #6
JHB
Have been here a while
 
Join Date: Jun 2012
Location: In the south of Denmark (Jutland), near the German border.
Posts: 7,720
Thanks: 3
Thanked 2,082 Times in 2,037 Posts
JHB has a spectacular aura about JHB has a spectacular aura about
Re: Report with subreport excel export alignment problem

Don't think you will be able to succeed because there is no way to influence how the data is inserted into Excel. But another thing is why do you want to export the report to Excel?
Only option as I see it right now is that you control where and how the data is inserted using VBA.
__________________
If the above post has helped you, why not take the time to say thank you, by pressing the "Thumbs up."
JHB is offline   Reply With Quote
The Following User Says Thank You to JHB For This Useful Post:
michal.r.1024 (09-21-2019)
Old 09-21-2019, 01:23 AM   #7
michal.r.1024
Newly Registered User
 
Join Date: Sep 2019
Posts: 6
Thanks: 4
Thanked 2 Times in 1 Post
michal.r.1024 is on a distinguished road
Re: Report with subreport excel export alignment problem

Quote:
Originally Posted by JHB View Post
Don't think you will be able to succeed because there is no way to influence how the data is inserted into Excel. But another thing is why do you want to export the report to Excel?
Only option as I see it right now is that you control where and how the data is inserted using VBA.
Hmm I am not happy to read that but I understand. And could you please give me a example of what are you advicing? Or some hint how to be able to affect the way the data are expoted via VBA?

Thanks

michal.r.1024 is offline   Reply With Quote
Old 09-21-2019, 01:44 AM   #8
JHB
Have been here a while
 
Join Date: Jun 2012
Location: In the south of Denmark (Jutland), near the German border.
Posts: 7,720
Thanks: 3
Thanked 2,082 Times in 2,037 Posts
JHB has a spectacular aura about JHB has a spectacular aura about
Re: Report with subreport excel export alignment problem

Could tell me why you want to export the report to Excel?
__________________
If the above post has helped you, why not take the time to say thank you, by pressing the "Thumbs up."
JHB is offline   Reply With Quote
The Following User Says Thank You to JHB For This Useful Post:
michal.r.1024 (09-23-2019)
Old 09-23-2019, 12:25 PM   #9
michal.r.1024
Newly Registered User
 
Join Date: Sep 2019
Posts: 6
Thanks: 4
Thanked 2 Times in 1 Post
michal.r.1024 is on a distinguished road
Re: Report with subreport excel export alignment problem

Quote:
Originally Posted by JHB View Post
Could tell me why you want to export the report to Excel?
If I would decide, I would not do it that way for sure, but my colleagues are used to use Excel so they export this report into excel as well as it fits their needs. I find it also quite weird but I can't do anything with it. I just need to make it optimalized for export to Excel somehow.

Could you please provide me some advice? (I did my best creating the report, I've put part of my soul inside it and I hope it could be fixed )
michal.r.1024 is offline   Reply With Quote
Old 09-24-2019, 01:42 AM   #10
michal.r.1024
Newly Registered User
 
Join Date: Sep 2019
Posts: 6
Thanks: 4
Thanked 2 Times in 1 Post
michal.r.1024 is on a distinguished road
Re: Report with subreport excel export alignment problem

Hi there, I found solution for this. The problem was that former report layout was original report access "sheet" with additional 2 subreports and the subreports were shifted. But when I changed it to "blank sheet" with 3 subreports, it is fixed. So the problem is solved, thanks for your assistance.

michal.r.1024 is offline   Reply With Quote
The Following 2 Users Say Thank You to michal.r.1024 For This Useful Post:
arnelgp (09-24-2019), JHB (09-24-2019)
Reply

Tags
alignment , excel , export , report , subreport

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] Report/Subreport problem CosmaL Reports 11 09-06-2018 02:00 AM
Report export to excel , layout problem Leo_Polla_Psemata Reports 8 06-03-2015 01:07 PM
export subreport to excel Jaye7 Modules & VBA 3 04-15-2015 01:43 PM
[SOLVED] Problem with Decimal alignment in report Richard M Reports 2 03-06-2014 08:53 PM
Crystal report Alignment problem - Export to excel data only anita Crystal Reports 2 11-19-2008 11:51 AM




All times are GMT -8. The time now is 07:33 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World