Dec 5th, 2017, 05:59 PM
#1
Thread Starter
Lively Member
[RESOLVED] VB6 + ActiveReports 2.0 Merging Cells
Hi experts,
How can I merge two cells or fields in Activereports 2.0? I use VB6 and MS Access as Database. Using SQL and ADO to connect to Activereport and fill the Fields.
Dec 6th, 2017, 11:16 AM
#2
Re: VB6 + ActiveReports 2.0 Merging Cells
Not really sure what you mean and can't make out the image.
As far as I know you can't really merge cells but you can use grouping or you can use code to alter the display at runtime.
Dec 6th, 2017, 05:00 PM
#3
Addicted Member
Re: VB6 + ActiveReports 2.0 Merging Cells
Use 'Distinct Row' or 'Inner Join' with more than one table.
P.S: I got what you mean by noticing the duplicate rows/records displayed in the report if I am not mistaken!
Last edited by labmany; Dec 6th, 2017 at 05:10 PM .
Dec 6th, 2017, 09:13 PM
#4
Thread Starter
Lively Member
Re: VB6 + ActiveReports 2.0 Merging Cells
Originally Posted by
labmany
Use 'Distinct Row' or 'Inner Join' with more than one table.
P.S: I got what you mean by noticing the duplicate rows/records displayed in the report if I am not mistaken!
Sorry if my picture make you misunderstanding. My activereport produces this:
I would like to make the table look like this.
Last edited by mdtam; Dec 6th, 2017 at 09:18 PM .
Dec 7th, 2017, 01:02 AM
#5
Addicted Member
Re: VB6 + ActiveReports 2.0 Merging Cells
This is a completely different screenshot than the first, anyway and like DataMiser said, use Grouping!
I made a small project for you, hope it helps!
Attached Files
Dec 7th, 2017, 03:04 AM
#6
Thread Starter
Lively Member
Re: VB6 + ActiveReports 2.0 Merging Cells
Originally Posted by
labmany
This is a completely different screenshot than the first, anyway and like DataMiser said, use Grouping!
I made a small project for you, hope it helps!
PERFECT! Thanks for the sample labmany. It's work like charm! Thanks to DataMiser too.
Posting Permissions
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
Forum Rules
Click Here to Expand Forum to Full Width