473,288 Members | 1,704 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,288 software developers and data experts.

a way to change "can grow" to force new page in subreport/detail?

Hi, since last time I have still note been able to solve this one, im starting to get frustrated, does anyone know if there is a way to force a page break on a sub report instead of the can grow function.

I mean, when it grows, the detail looses some information [it has an embebed sub form on it] of the detail section, I’ve tried, repeat section, creating a new image frame… kind of lost here thanks in advance
Aug 2 '10 #1
2 1800
jimatqsi
1,271 Expert 1GB
I'm not sure what the condition is you are wanting to use to decide to page break or not. But, you can put a page break control in the place you want it to occur and then make it visible or not visible with a piece of vb code in the format section of the detail of either the main report or the subreport.

me!pagebreakcontrolname.visible = (true or false)

Jim
Aug 3 '10 #2
solved by creating a new column with the page number... not clasy but working

basically inside de sub form made it so that there can not be mote than N columns and making on the value on new column to number page and created a Child master and sorting and grupoing through that value
Aug 13 '10 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

5
by: Armand Karlsen | last post by:
On this page of my website: http://www.zen62775.zen.co.uk/rigs.html the W3C html validator claims that there are some bytes it cannot interpret in line 49 of the html source as UTF-8. If I force...
2
by: John Baker | last post by:
Hi: I have a report that contains a remarks field which is a "memo" format field. I have that field on a single line in the report, and have it given a property of "Can Shrink", in the hope that...
4
by: Mal | last post by:
I have an ACC 2000 database that has a strange behaviour I have a small table, with just a few fields... My report has very simple grouping and sorting, no code bar a NODATA event. I have a...
2
by: Michael S. Montoya | last post by:
I have a report which has 3 sub-reports in the detail section. Everything (subforms, detail section) is set to Can Grow and Can Shrink as True. I have one record in which one of the subforms has...
13
by: baumann.Pan | last post by:
when define char *p = " can not modify"; p ='b' ;is not allowed, but if you declare p as char p = "can modify"; p = 'b'; is ok? why?
2
by: Gustavo De la Espriella | last post by:
Hi, I know this is not a Crystal Reports group, but news.cogniza.com recieves like one question per week. Does anyone know how to push fields following a textbox when it grows with the "Can...
1
by: welles.lo | last post by:
Hi all, I found that the default "can grow" in Crystal Reports 10 is different from the one in Crystal Report 9. In version 9, when "can grow" is disable, the words in the field are chopped...
2
by: steve456 | last post by:
Is it possible in a form while entering data in a text field to get the field to drop down so as to see all of what you're typing. I know this option is available in a Report but haven't come...
2
by: Seanw | last post by:
i created a report in access. the output look like spreedsheet(every field has solid border) there is one colunm have some fields have very long content. so i set all colunms to "can grow" but in...
7
by: TriAdmin | last post by:
I am working with a system that allow me to add custom fields but I can not add OnChange() language to the custom fields. So I want to have a function in the header that recognizes when fieldx is...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: marcoviolo | last post by:
Dear all, I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.