Report only showing the first record on a subreport :(

John Sheppard

Hello there,

I have a report with a subreport on it. The subreport is meant to show
multiple child record for each master record. But it only shows the first
record.

When I open the subreport by itself it shows all the records, but when on
the main report it will only show the first.

The link master/child fiends are set correctly.
Im not sure where else to look for problems :( I was wondering if anyone
could give me any tips?

Thanks heaps for any ideas
John

Nov 18 '07 #1

Subscribe Post Reply

8074

bobh

HI,
You do have the subform set up as a continuous form correct? and you
have the detail section properity 'can grow' set to Yes.
bobh.

On Nov 18, 6:13 pm, "John Sheppard" <s...@nospam.comwrote:

Hello there,

I have a report with a subreport on it. The subreport is meant to show
multiple child record for each master record. But it only shows the first
record.

When I open the subreport by itself it shows all the records, but when on
the main report it will only show the first.

The link master/child fiends are set correctly.
Im not sure where else to look for problems :( I was wondering if anyone
could give me any tips?

Thanks heaps for any ideas
John

Nov 19 '07 #2

John Sheppard

Thanks Bobh,

I think I have those set...Although now I noticed the footer set to
cangrow=false...but there is nothing in the footer so I dont think that
matters...

I cannot find where the section for continuous forms in reports is, I will
keep looking!

This gives me stuff to look for in either case!
Thanks heaps Bobh..

"bobh" <vu******@yahoo.comwrote in message
news:72**********************************@b15g2000 hsa.googlegroups.com...

HI,
You do have the subform set up as a continuous form correct? and you
have the detail section properity 'can grow' set to Yes.
bobh.

On Nov 18, 6:13 pm, "John Sheppard" <s...@nospam.comwrote:
>Hello there,

I have a report with a subreport on it. The subreport is meant to show
multiple child record for each master record. But it only shows the first
record.

When I open the subreport by itself it shows all the records, but when on
the main report it will only show the first.

The link master/child fiends are set correctly.
Im not sure where else to look for problems :( I was wondering if anyone
could give me any tips?

Thanks heaps for any ideas
John

Nov 20 '07 #3

Similar topics

Visibility of controls in a Sub-Report

by: Dom | last post by:

Hi, I have a werid problem with a subreport. If someone can help me out I'd be very grateful! Based on results from a query, the visibility of textboxes and labels in a subreport are set to...

Microsoft Access / VBA

Format event of a report's section

by: Melissa | last post by:

What specifically causes the Format event of a report's section to fire? Thanks! Melissa

Microsoft Access / VBA

Formatting subreport "report" headings

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...

Microsoft Access / VBA

Report with subreport - one-to-many relationship

by: lorirobn | last post by:

Hello, I have a report which uses a subreport. When I run the report, I get "Enter Parameter Value" error message for "tblGuestRoom". I click ok and the report seems to work fine. I...

Microsoft Access / VBA

Filtering report and subreport from form

by: | last post by:

hi, i have a form on which a user can choose specific criteria such as dates etc, in order to filter the report that is called from the form. i do this by using the Where section of the...

Microsoft Access / VBA

Crystal Report - with parms - .Export error

by: Timmy Jones | last post by:

Hey all, I am trying to try get a crytal report running properly. A "Hello World" report that does not add criteria to the record selection formula of the report (either in the development tool,...

Visual Basic .NET

Sub-report starts on new page

by: ysh8o1 | last post by:

Hi I have a report containing two sub-reports in the details section. The first of these contains a list of records, and appears as a full width blank rectangle, thick enough to contain at...

Microsoft Access / VBA

Speed up report performance

by: Jana | last post by:

Hi! I have an Access 97 report based on tables linked to an SQL back end. The report has 5 subreports in it (unfortunately unavoidable due to the nature of the report) and performance is quite...

Microsoft Access / VBA

Subreport Grand total not showing as part of the main report

by: eogyamfi | last post by:

i have subreport within the main report. The grand total for the main report is showing on the report. The grandtotal for the subreport is not showing even though on the subreport itself it shows...

Microsoft Access / VBA

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

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...

Data Management

Migrating Website to Cloud - Emmanuel Katto

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

General

Navigating the Data Structures and Algorithms (DSA)

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...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

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...

C / C++

Changing the language in Windows 10

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...

Windows Server

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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...

Online Marketing