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

Dynamic Subreport Size

I have a report with a sub report, and the subreport could have anywhere
from 0 to 4 records in it (most will have zero) I would like to have the
report formatted so there is not a big space between each record if there is
no sub report data for that record. Is there a way (VBA or otherwise) that
I can format the report so that there is just enough space under each record
in the master report to show the associated sub report records, and no extra
space if there are no subreport records for that item?

Thanks.

Steve
Nov 12 '05 #1
1 5545
Set the sub report's Can Shrink property to yes.
"Steve Edwards" <ra***********@hotmail.com> wrote in message
news:vp************@corp.supernews.com...
I have a report with a sub report, and the subreport could have anywhere
from 0 to 4 records in it (most will have zero) I would like to have the
report formatted so there is not a big space between each record if there is no sub report data for that record. Is there a way (VBA or otherwise) that I can format the report so that there is just enough space under each record in the master report to show the associated sub report records, and no extra space if there are no subreport records for that item?

Thanks.

Steve

Nov 12 '05 #2

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

Similar topics

3
by: CSDunn | last post by:
Hello, I have a situation with MS Access 2000 in which I need to display report data in spreadsheet orientation (much like a datasheet view for a form). If you think of the report in terms of what...
0
by: Penguin | last post by:
How can you prevent a space under a subreport? In my particular case, I can't use can grow because I need to force the subreport to go to the next column at a certain point to show several headings...
10
by: sara | last post by:
I am STUCK! I have an Access2000 report; main report and subreport. The sub report is 2 columns, with a footer controlled by a value in a field. The Report Footer should have SUM of values in...
0
by: Jaap | last post by:
Hi, Situation is as follows: - A report has a subreport - The subreport has records of which two will fit on a page - When the complete report is printed, the last record in the subreport...
3
by: deejayquai | last post by:
Hi I've created a crosstab query and displayed it as a sub-report in my main report. This is fine until the data changes and the column names become incorrect. I know I have to create a...
1
by: cantonarv | last post by:
Just trying to do a basic crystal report and viewing it with dynamic sql server database but dont no what i'm doing wrong? I am using integrated security. Dim myRpt As crpt1 = New crpt1 ...
4
by: MLH | last post by:
I have a report and on it, a subreport control Main Report Name: rptInvoiceMain Sub Report Name: rptInvoiceSubReport SubReport Control Name: rptInvoiceSubReportCtl The...
0
by: hodgesp | last post by:
I have a c# web application. I have created a crystal report and report view er. I can get the report to display by itself but when I add a subreport I eithe r get a logon error or object not...
0
by: =?Utf-8?B?bWFmYW5kb24=?= | last post by:
I have a tractor fed pre-formatted paper that I run a report on. It fills in the fields perfect, until my subreport has less or more rows than what's typical. The rest of the report either moves...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
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
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...

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.