Home > Archive > Visual Basic Crystal Reports > March 2006 > 2 Patterns for single Crystal Report (rpt) file
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
2 Patterns for single Crystal Report (rpt) file
|
|
| den 2005 2006-03-22, 4:06 am |
| Hi everybody,
Is it possible to display two different pattern of reports and must be on
separate pages? First Page displays a summary, second page displays details
and other info. Having problem doing this placing except for company details
on page header and the rest on the Details part of the report.
Pattern:
First Page:
Company Logo
Company Name
Company Address
Statement of Account
Statement Date: (system date)
Period Covered: (date from filter page) Control Number (data
from db1)
Company: (company name from db2)
Address: (address from db2) Total Balance (data
from db1)
========================================
========================================
======
Statement Summary
Total Deposits (data from db1)
Total Advances (data from db1)
Total Repayments (data from db1)
Transactions for the preiod per Client
(client 1)
(Client 2)
(Client 3)
--------------------------------------------------------------------------------------
Total Balance (data from db1)
========================================
========================================
====
Second Page:
Company Logo
Company Name
Company Address
Company: (data from db2) Control Number (data
from db1)
Period Covered (data from filter page) Account Number (data
from db1)
========================================
========================================
======
Statement Details
--------------------------------------------------------------------------------------
Prepayment Details
Deposits
Date OR No Description Amount
(record 1)
(record 2)
(and so on . . .)
--------------------------------------------------------------------------------------
Total Deposits (sum)
--------------------------------------------------------------------------------------
Advances
Date OR No Description Amount
(record 1)
(record 2)
(and so on . . .)
--------------------------------------------------------------------------------------
Total Advances (sum)
--------------------------------------------------------------------------------------
Total Prepayments (grand
total)
-------------------------------------------------------------------------------------
Transaction Details
(Client 1 from db3):
Date Trans No Status Detail1 No Detail2 No Remarks Amount
(record 1)
(record 2)
(record 3)
(and so on ...)
--------------------------------------------------------------------------------------
Sub-Total (sum)
--------------------------------------------------------------------------------------
(Client 1 from db3):
Date Trans No Status Detail1 No Detail2 No Remarks Amount
(record 1)
(record 2)
(record 3)
(and so on ...)
--------------------------------------------------------------------------------------
Sub-Total (sum)
--------------------------------------------------------------------------------------
(Client 3 from db3):
Date Trans No Status Detail1 No Detail2 No Remarks Amount
(record 1)
(record 2)
(record 3)
(and so on ...)
--------------------------------------------------------------------------------------
Sub-Total (sum)
--------------------------------------------------------------------------------------
Total Transaction For the period (sum of all transaction) (grand
total)
--------------------------------------------------------------------------------------
Thanks...
den2005
--
MCP Year 2005, Philippines
| |
| Terence Tirella 2006-03-22, 8:10 am |
| I think what you will work best for you would be to Statement summary
in a report header section. You can control the page breaks in the
'select expert' so that there's a new page after the summary to keep
the details from showing up on the same page. Use the summary wizard
to create the sums for the beginning of the report. Then in the main
section group on the different clients.
One problem you might run into is grouping in the report summary. You
might be limited in what data you can display in the report header if
it has groups. If this becomes an issue your best bet might be to have
the report summary be a sub-report instead.
| |
| den 2005 2006-03-22, 7:07 pm |
| Thanks for replying, Terence.
I am  with the terms you mentioned. I should summary on Report
header section and then create a subreport? SEUBREPORT? What is that another
crystal report(rpt) where details are included there on second and the
summary on first report?
dennis
--
MCP Year 2005, Philippines
"Terence Tirella" wrote:
> I think what you will work best for you would be to Statement summary
> in a report header section. You can control the page breaks in the
> 'select expert' so that there's a new page after the summary to keep
> the details from showing up on the same page. Use the summary wizard
> to create the sums for the beginning of the report. Then in the main
> section group on the different clients.
>
> One problem you might run into is grouping in the report summary. You
> might be limited in what data you can display in the report header if
> it has groups. If this becomes an issue your best bet might be to have
> the report summary be a sub-report instead.
>
>
| |
| den 2005 2006-03-23, 10:05 pm |
| Hi,
I put contents of first page on report Header section and the subreport
in the details section but when it is viewed the contents of subreport is not
displayed. I have not used data filed values yet (from db). How can I fixed
this??
den2005
--
MCP Year 2005, Philippines
"den 2005" wrote:
[color=darkred]
> Thanks for replying, Terence.
>
> I am with the terms you mentioned. I should summary on Report
> header section and then create a subreport? SEUBREPORT? What is that another
> crystal report(rpt) where details are included there on second and the
> summary on first report?
>
>
> dennis
> --
> MCP Year 2005, Philippines
>
>
> "Terence Tirella" wrote:
>
|
|
|
|
|