Report Possibilities

[martinwcole]

I have 2 1 to many tables. The 1st needs a group, and the 2nd doesn't. The 1st needs to print first, the 2nd second.

I also need a report footer, which I need to have justify to the bottom of the page.

While I can put the 2nd at the top of the footer, it looks very bad, that way, when justified to the bottom of the page.

Has anyone else ever run into something like this?

[Tom Henkel]

RE: Report Possibilities

Maybe its just too late in the day for me, but I really don't understand exactly what it is you want. I have written many reports in a 1-"many set, all with headers, group footers, reoprt footers, and page footers. Could you explain, a little more clearly, possibly with examples, what it is you are trying to do? I am sure someone has done what you would like to do.

Tom

[martinwcole]

RE: Report Possibilities

Thanks for responding, Tom.

The report has a header, two one to many child tables, and a report footer.

The nature of the report is such that the 1st child table requires a group. And the 2nd table doesn't.

The table with the group needs to print just below the header, and the table without a group needs to print just below this.

And the footer needs to justify to the end of the page.

I have wrestled with this for 2 days - but can't figure out any way to do it.

The closest I have come is to put the 2nd table(with no group) as a sub report in the footer, but then I can't justify to bottom without it appearing badly.

If you scroll down in messages (to next 20) look for report question - I have 2 jpegs there - one in design and one of the report.

[Bill Parker]

RE: Report Possibilities

Martin,

The solution will ultimately be with subreports, but you will need test different options. I often put subreports in a group footer or report footer, but also try putting both of them in the detail section. The 2 subreports would be the only thing in the detail section, with the subreport with a group first, and the other subreport below it.

Then the page footers may work for you.

Bill.

[martinwcole]

RE: Report Possibilities

Thanks Bill. Yes I agree, subreports is the only way to go here.

This is one of those things you think there must be a way around.

If I put both subreports in the detail section, it prints the subreport with the group second, and the group without first. I can drag one above the other, but it still prints in that order.

I tried putting the second in the group footer for the first - but it still prints the same way - like it prints the report groupfooter above the group.

I also tried making 2 groups (even though there would technically be no break with the 2nd group), and putting the second subreport in the second groupfooter - but it prints the same way - with the 2nd subreport before the 1st subreport.

Maybe the report writer cannot handle this kind of scenario.

[JohnZaleski]

RE: Report Possibilities

Once you put filters in a subreport, you can start getting strange results. Sounds like this might also be true with groups. Usually you can play around with them and get things to work.

I've no reason to suggest the following except that it is something additional to try: Create a set just for this report. Try reversing the order of adding child tables to the parent of the set structure and see if it helps.

Assuming A and B are child tables:
SET1 Parent =A =B
change to
SET2 Parent =B =A

[martinwcole]

RE: Report Possibilities

Thanks John,
That was an excellent idea. Unfortunately, it doesn't change anything.

I have the report working, where I put the 2nd subreport in the report footer. Its just that since there is "footer type" stuff also in the footer, if I justify to the bottom, it looks bad, becasue the "detail subreport" is now wayyyy down at the bottom, too.

[martinwcole]

RE: Report Possibilities

Enclosed is a stripped down version
If anyone has time to look
1. When it boots up to the main menu, click on Log In Form
then in that form
click the "Print" button
at the dialog option, select Preview One Only

scroll down to the bottom of the page - the Department/Test Type, etc. is a subreport in the footer
then note the footer type stuff below it.

I've tried everything I can think of, but I cannot put the 2nd subreport anywhere but in the footer, and have it print 2nd, below the first subreport.

[Allen Klimeck]

RE: Report Possibilities

Could you put the group in the sub report?

[martinwcole]

RE: Report Possibilities

I tried that, but didn't work. I deleted the group, put the first subreport in details, and then put a group in the subreport, and the 2nd subreport under it - in theory it should work, but hasn't so far.

[Jim Chapman]

RE: Report Possibilities

Hello Martin,

Check out this example. I call this my "multiple detail" trick :-) By defining a group but making it break at recno() you essentially have another detail section.

I don't know your structure, so you may need to modify this for your real report, but my guess is that something in this neighborhood will work for you.

Also, be cautious of multiple subreports in a single report. I and others have had problems with them not showing record when one of the subreports is empty. Apparently Alpha has been able to duplicate this issue so I'm hoping a fix will be coming soon.

Good luck,
Jim

[martinwcole]

RE: Report Possibilities

Thanks Jim, I really appreciate your time.

Unfortunately, it still prints them in the wrong order; i.e., it prints the

I had also tried a version of your approach - except breaking on Labnum instead of recno() - but I really like the idea of recno().

You would think, that since there are 2 groups and both with a break, it wouldn't care which one prints first.

I suspect there is some sort of hidden rule, like if one of the subreports has 2 columns then print it first, and the others second. E.G., Starting from scratch, if I make a group for the table that would normally have a break, and set its break - it names it group1. But when I make a 2nd group on any other table (or recno()) it makes the new one group1 and renames the first to group2.

I have had good luck with and really like subreports, although I typically have to fiddle with things a bit to get them to work the way I want.

[Jim Chapman]

RE: Report Possibilities

Hello Martin,

""Unfortunately, it still prints them in the wrong order; i.e., it prints the ""

You didn't complete the above. I'm missing something, as the example I sent prints in the order that I thought you were looking for. Can you re-explain to me in what way the order is incorrect in the example I sent you?

Jim

[martinwcole]

RE: Report Possibilities

Sorry, got lobbed off.

The table [Travelerprtnum] that breaks on "partkey" that prints in two columns, is supposed to be above the 2nd table [logintests] that either has no break, or that would break on recno(). Also note that the report is filtered to only print one parent: "labnum=var-"labnum"

[Jim Chapman]

RE: Report Possibilities

Martin,

I hate to be dense, here is what I see when I preview your travelers report.

""The table [Travelerprtnum] that breaks on "partkey" that prints in two columns, is supposed to be above the 2nd table [logintests]""

It appears Travelerprtnum is first, and I don't see 'two columns'. Could you mark up this jpeg so I can figure out what you are wanting?

Thanks,
Jim