Mulitple rows for a record 1

[Crystalguru]

Hello,

I am writing a report in version 8.5 and need help with the following.

The report is for Apartments.
Bld# Unit# Unit Type Rent$ Amenities

Pretty simple, except that an apartment can have multiple amenities. Which comes out looking like this:
Bld# Unit# Unit Type Rent$ Amenities
1 101 A1 500.00 B
1 101 A1 500.00 G
1 101 A1 500.00 Y

So far this is what i have done:
Grouped by Unit Type: A1
Grouped by Unit #: 101
500.00 B
500.00 G
500.00 Y
But I still get a repeat of Rent$ and Amenities. Some apartments can have over 10+ amenities.

Is there anyway to get all the amenities on one line in the report?

thanks

 

[Crystalguru]

Naith,

Are you out there? I need your help...

 

[Naith]

Yeah, I'm here. What's the prob?

 

[Crystalguru]

Trying to get residents and applicants to show on same row (similar to amenities) with no luck.
Here's what I am trying:

Unit # Resident current rent applicant quoted rent
101 Carrie 500.00 Naith 600.00 (hee hee)

My problem is they both come from the resident table. The only differences is some selection criteria that makes them a resident or applicant.

Can this be done?

If your interested...

My last resort is to create a subreport for the applicants.

What do you think?

Thanks for coming back!

 

[Naith]

I'm going to answer this despite the fact that you're evidently prepared to rob me.

I suppose there's two or three ways you might think about trying to achieve this. I haven't tested any of them.

The subreport idea you've already happened on yourself. Because all this information is going to be at a detail or regular group level, it'd mean that the subreport would have to execute a lot of times. Believe me when I tell you that you don't want that. Your report performance'll go right down the tubes. That aside, I'm not convinced a subreport's even necessary at this juncture.

Now, I don't remember your report very well at the moment, but I believe that you were displaying your information at a group level, rather than at a detail level.

You could group by Unit, and in your detail section, you could use variables like:

WhilePrintingRecords;
StringVar Resident;
StringVar Applicant;
NumberVar Rent;
NumberVar Quoted;

If Not IsNull({Table.Applicant})
Then Applicant := {Table.Applicant}
Else Applicant;

//Repeat for Resident
//Repeat for Rent
//Repeat for Quoted

Then in the Unit group footer, display all the variables, which should give you the output you mention in your earlier post.

Off the top of my head, the latter suggestion is probably the simplest method to achieve what you're asking for. The way you're getting Amenities to show on the same row isn't really condusive to this kind of thing.

All the best,

Naith

 

[Crystalguru]

Thanks Naith! Your help is greatly appreciated. Sometimes, two brains are better than one. I did try the subreport idea, works great until you run a large apartment community, then your waiting... I will try your suggestion and tweak it accordingly.

Thanks again for all your help. I truley hope you don't feel "mugged".

later