473,414 Members | 1,628 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,414 software developers and data experts.

How to fix subreport?

GB
Hello:
I created a report as a perent report
with subreport in the middle of detail
section of the perent report.
The subreport has a query as the recordsource,
which can return different number of records
depends on input parameter.
My problem is the following:
Depends on the number of records are showing by the subreport
the position of controls on the bottom part of my parent report
is changing every time.
Could you give me a hint how can I make the position of
the bottom part of my report independant
on the number of records in subreport?

Thanks,
GB

Nov 13 '05 #1
2 1654
GB wrote:
Hello:
I created a report as a perent report
with subreport in the middle of detail
section of the perent report.
The subreport has a query as the recordsource,
which can return different number of records
depends on input parameter.
My problem is the following:
Depends on the number of records are showing by the subreport
the position of controls on the bottom part of my parent report
is changing every time.
Could you give me a hint how can I make the position of
the bottom part of my report independant
on the number of records in subreport?

Thanks,
GB

Check the CanGrow property on the band (dbl-click on the bar for detail)
and also the CanGrow property of the fields if necessary. See if it's
set to False. Change to True
Nov 13 '05 #2
GB
It doesn't work for me.
"Salad" <oi*@vinegar.com> wrote in message
news:Ab****************@newsread2.news.pas.earthli nk.net...
GB wrote:
Hello:
I created a report as a perent report
with subreport in the middle of detail
section of the perent report.
The subreport has a query as the recordsource,
which can return different number of records
depends on input parameter.
My problem is the following:
Depends on the number of records are showing by the subreport
the position of controls on the bottom part of my parent report
is changing every time.
Could you give me a hint how can I make the position of
the bottom part of my report independant
on the number of records in subreport?

Thanks,
GB

Check the CanGrow property on the band (dbl-click on the bar for detail)
and also the CanGrow property of the fields if necessary. See if it's
set to False. Change to True

Nov 13 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Steve Edwards | last post by:
I am trying to use an existing report as a subreport in another report. I have the subreport added to the main report, but the only thing that shows up where the subreport should be is the name of...
8
by: dixie | last post by:
I have a report with a subreport. The source object for this subreport varies according to the value of a field in a table. I am trying to programmatically set the object source for the subreport...
9
by: Downstreamer | last post by:
Design is as follows: A form for the user to input criteria to be used as the where part of the report's recordsource. This includes a multiselect list box as part of the criteria selection. ...
7
by: Ellen Manning | last post by:
I've got an A2K report showing students and their costs. Student info is in the main report and costs are in a subreport for each student. The user inputs the program desired then only those...
6
by: Steve Jorgensen | last post by:
I tried to fix a problem for a client today in which report sections and even individual text controls in some of their reports are being split across page boundaries. Of course, I was thinking...
1
by: shaqattack1992-newsgroups | last post by:
I know this is kind of a weird question, but is there anyway to give a subreport control of a main report? I posted my situation earlier about having drawings print out after a group. I have a...
5
by: Tom | last post by:
I have a subreport that can contain one or two pictures per page. The subreport is similar to an appendix to the main report. The recordsource contains a field "IncludeInReport" (Yes/No) for each...
0
by: C | last post by:
Hi, I have a main Report which has a SubReport. This SubReport also has a SubReport. I set the data of my main Report and Subreport through code DataSet dsMainReport =...
11
by: Simon | last post by:
Dear reader, The syntax for the VBA code to change the RowSource of a Master Report is: Me.RowSource = "TableOrQueryName"
3
by: Simon | last post by:
Dear reader, The syntax for the VBA code to change the RecordSource of a Master Report is: Me.RecordSource = "TableOrQueryName"
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

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.