• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 736
  • Last Modified:

Help with report two column sub report

Hi Experts.

I have this report where I would like to have 3 sub reports.

Please look at the picture and hopefully some one can help me with the setup of the report.

I have made all 3 sub reports and they work exatly as they should.


sample.JPG
0
DCRAPACCESS
Asked:
DCRAPACCESS
  • 3
  • 3
1 Solution
 
MINDSUPERBCommented:
DCRAPACCESS,

"I have made all 3 sub reports and they work exatly as they should."

The following steps would be a good starting point:
1. Drag each subreport into the blank detail section of the main report.
2. Arrange them according to what you like.
3. If necessary do the Master and Child linking of the report.

Sincerely,

Ed
0
 
DCRAPACCESSAuthor Commented:
Hi Ed,

Sorry, that does not do it .-(

The last report only shows one column and not two.

But if i setup my main report to also have two columns, then the last sub report works, but then I can get the two pie chart to stay besides each other :-(

livesample.JPG
0
 
MINDSUPERBCommented:
DCRAPACCESS,

I am sure you can configure it out. Though not really quick but you can make it.
You may take out sensitive information and post here the db with only the source tables/queries and those subreports. Let us see how we can help you.

Sincerely,
Ed
report.JPG
0
Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

 
DCRAPACCESSAuthor Commented:
0
 
DCRAPACCESSAuthor Commented:
so i don't think that it is possible. :-(

Instead i found another way around, i think? But now my problem is that i need to control the pageheader section height on all other pages than the first one.


0
 
MINDSUPERBCommented:
"But now my problem is that i need to control the pageheader section height on all other pages than the first one."

I may suggest to open a new question for this to call the attention of other EEs.
I am glad that you found the solution.

Sincerely,

Ed
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now