ActiveReports for .NET 2.0 Support

Started by blaggard at 12-08-2005 12:05 PM. Topic has 26 replies.

Print Search Rate
Sort Posts:    
   12-08-2005, 12:05 PM
blaggard is not online. Last active: 4/29/2008 5:24:34 PM blaggard

Top 50 Posts
Joined on 10-02-2003
Posts 211
Need help with Columns and a SubReport
Hi,

I have an  rpx that is a subreport of another rpx.

On the subreport rpx, i have 2 datafields in the detail section and i have set the report to have 2 columns.

I added a subreport control to the parent rpx file and set the subreport controls source to the subreport rpx.

I set the subreport control to cangrow=false.

When i preview the parent report, the contents of the subreport does not continue on the 2nd column, it just gets cropped off the bottm of the first column.

How can i get this to work, if at all?

Thanks in advance.

   Report 
   12-09-2005, 1:15 PM
brandon is not online. Last active: 9/19/2007 6:26:25 PM brandon

Top 10 Posts
Joined on 06-24-2003
Posts 3,671
Re: Need help with Columns and a SubReport
You'll need to set the subreport's page height to the height of the subreport control on the main report. This, coupled with zero margins for the subreport, will cause the next detail section to render in the next column. Use the subreport's ReportStart event to set this.Document.Printer.PrinterName = ""; and the other page settings.
brandon.
webmaster. -DD
   Report 
   12-14-2005, 6:06 AM
blaggard is not online. Last active: 4/29/2008 5:24:34 PM blaggard

Top 50 Posts
Joined on 10-02-2003
Posts 211
Re: Need help with Columns and a SubReport

I set the following script in the subreport:

public void ActiveReport_ReportStart(){

rpt.Document.Printer.PrinterName = "";

rpt.PageSettings.Gutter = 0.0f;

rpt.PageSettings.Margins.Bottom = 0.0f;

rpt.PageSettings.Margins.Left = 0.0f;

rpt.PageSettings.Margins.Right = 0.0f;

rpt.PageSettings.Margins.Top = 0.0f;

rpt.PageSettings.PaperHeight = 3.0f;

rpt.PageSettings.PaperWidth = 6f;

}

 

but it appeared to have no effect.

can you give me any help with this?


   Report 
   12-16-2005, 6:42 AM
blaggard is not online. Last active: 4/29/2008 5:24:34 PM blaggard

Top 50 Posts
Joined on 10-02-2003
Posts 211
Re: Need help with Columns and a SubReport

Is there any chance you could provide me with a sample on how to do this as i am having no joy whatsoever.

thanks.


   Report 
   12-19-2005, 1:33 PM
brandon is not online. Last active: 9/19/2007 6:26:25 PM brandon

Top 10 Posts
Joined on 06-24-2003
Posts 3,671
Re: Need help with Columns and a SubReport
If you post what you have so far, we'll take a look at it. I'm told it may not even be possible.

brandon.
webmaster. -DD
   Report 
   12-21-2005, 11:32 AM
blaggard is not online. Last active: 4/29/2008 5:24:34 PM blaggard

Top 50 Posts
Joined on 10-02-2003
Posts 211
Re: Need help with Columns and a SubReport

I can attach the documents has they contain sensitive information and are highly integrated into our software.

In essence i want the contents of a subreport document to continue on to the next column based on the bounds of the subreport control on the parent report.

For example:

i create an rpx document (subreport) and i set it to have 2 columns. I also set the column direction to be down then across.
When i preview the document i see 10 rows of information on the report (I have 10 records in the data i am pulling from).
Each data row appears beneath each other.
This is fine.

In the parent report, i have put a subreport control on it. I have set the subreport not to grow.
The height of the subreport is such that only 5 rows of data will be visible.
The subreport control is wide enough to allow for another column.

I set the subreport controls source to the the subeport document that i created.

When i preview the parent report, i only see 5 rows of data , where as i want to see 2 columns contin 5 rows of data each.

I have tried adjusting the subreports page size as suggested, but this had no effect.

I am now beginning to think this is not possible, so would it be possible to have a CR created for this?


   Report 
   12-21-2005, 4:08 PM
brandon is not online. Last active: 9/19/2007 6:26:25 PM brandon

Top 10 Posts
Joined on 06-24-2003
Posts 3,671
Re: Need help with Columns and a SubReport
Ok, that makes a little more sense. I thought you had 2 columns on the main report. I see now that your subreport had the columns. In this case, you are correct- the subreport won't move to the next column just because its height is set to less than the height of the data. It will truncate that data since it's greater than the subreport height. I think you'll want to use multiple columns on the main report instead of the subreport.

brandon.
webmaster. -DD
   Report 
   01-04-2006, 5:23 AM
blaggard is not online. Last active: 4/29/2008 5:24:34 PM blaggard

Top 50 Posts
Joined on 10-02-2003
Posts 211
Re: Need help with Columns and a SubReport

I dont think your suggestion would work for me.
I have attached a jpg to give an idea of what i am trying to achieve.

Can you let me know if it is possible to do what i have shown in the jpg and if so how would i do it?


   Report 
   01-04-2006, 5:24 AM
blaggard is not online. Last active: 4/29/2008 5:24:34 PM blaggard

Top 50 Posts
Joined on 10-02-2003
Posts 211
Re: Need help with Columns and a SubReport

Attachment: column sample.zip

forgot to zip the jpg.
here it is now.


   Report 
   01-05-2006, 2:15 PM
Peter Power - DD is not online. Last active: 6/27/2006 8:59:38 PM Peter Power - DD

Top 25 Posts
Joined on 08-28-2004
Posts 1,217

DDStaff
Re: Need help with Columns and a SubReport

The simplest solution would be to set the ColumnDirection property to AcrossDown rather than DownAcross. The problem that you are having is that the colmns will wrap based on the subreports paper size. However, the wrap is probably not going to work as you want it to. If the subreport's height was 3" then every 3" the wrap would take place. I would recommend just using the AcrossDown direction.

 


   Report 
   01-09-2006, 4:51 AM
blaggard is not online. Last active: 4/29/2008 5:24:34 PM blaggard

Top 50 Posts
Joined on 10-02-2003
Posts 211
Re: Need help with Columns and a SubReport

AcrossDown is no use for me, i really need to use DownAcross

You say that the columns wrap based on the subreports paper size, but this does not seem to be the case.

I set the subreport paper size to be 3" but this was not reflected on the main report.

The subreports paper size seems to be ignored and the printer default is used.

I have tried with both DownAcross and AcrossDown and both ways do not use the subreports paper size to wrap.

Are you able to get this to work?

 


   Report 
   01-09-2006, 11:38 AM
Peter Power - DD is not online. Last active: 6/27/2006 8:59:38 PM Peter Power - DD

Top 25 Posts
Joined on 08-28-2004
Posts 1,217

DDStaff
Re: Need help with Columns and a SubReport

You are right. After looking at the issue again, the Subreport does not handle columns based on it's own page height. All page breaks and page dimensions are handled from the Main Report; and it appears that the multicolumns of the subreport are also. There is not currently a way to work around this issue, which I am aware of. I have submitted a suggestion to our development team to handle the column break for a multi-column subreport based on either the SubReport control's height or the SubReport's page height. The CR number for this suggestion is 18667. I have attached your e-mail address to the Change Request.

Thanks, 


   Report 
   01-09-2006, 12:04 PM
blaggard is not online. Last active: 4/29/2008 5:24:34 PM blaggard

Top 50 Posts
Joined on 10-02-2003
Posts 211
Re: Need help with Columns and a SubReport

I dont know if you can bump up the priority of CR?
This functionality is required to produce a fund factsheet for one of our client implementations.
I know your not keen on giving timing information, but can you give a some sort of time frame so that i can pass this information onto our client to give them a ball park idea as to when the functionality will be available?

thanks for all your help thus far.


   Report 
   01-10-2006, 9:40 AM
Peter Power - DD is not online. Last active: 6/27/2006 8:59:38 PM Peter Power - DD

Top 25 Posts
Joined on 08-28-2004
Posts 1,217

DDStaff
Re: Need help with Columns and a SubReport

I cannot give an estimated time frame. Ultimately, these decisions are made by our development staff. I will make sure that they are aware that this issue is important to you though.

 


   Report 
   03-02-2006, 1:57 PM
edburdo is not online. Last active: 3/1/2006 11:32:04 PM edburdo

Top 500 Posts
Joined on 03-01-2006
Posts 33
Re: Need help with Columns and a SubReport
Is there any further news on this particular item?


   Report 
  Page 1 of 2 (27 items) 1 2 >
GrapeCity » Product Support » ActiveReports f... » Need help with Columns and a SubReport

Privacy Policy | Copyright © 1997-2012 — GrapeCity, inc.
All trademarks mentioned are the property of their respective owners.