Run Multiple Reports w/ Name Changes In Report Title 2

[Thuky]

Hi,

I having working on a report but get so stuck. Need help please.

I am working on a crystal report (version 10). The criteria as followed:

1. When a manager runs a report, it should pull out multiple reports on the screen. Let say if the manager has 3 agents, he should see 3 seperate reports for the 3 (1 report from each agent).
2. On the report header, there should be always date funded, Agent Name, and Manager Name.

I am stuck on #2 that I can't make the right agent name and manager name shown on each report header. For example, report 1 should have Agent name as Mary and Manger name as Lary. Report 2 should have Agent name as Lori and Manger name as James, etc.

I try to move the agent name and manager name down to the group header, it works but didn't work for the page header since the page header ABOVE the REPORT header now. I have to have the report title ABOVE the page header.

Here is what I have so far:

Report Header: Funded loans (text label and need to show on every page)
Page Header: Loan Numumber, Loan Amount
Group Header #1: AgentName (field)
Details: LoanNo (field), LoanAmount (field)
Group Footer :#1
Report footer
Page Footer

Thanks for any help since I am in a rush.

 

[Madawc]

Right-click your group, choose Change Group>Options. You'll see check-boxes for keeping a group together, and repeating the group headers on each page. This can serve in place of a page header, which is harder to control.

You may wish to distingish between the first group header and its repetition on other pages. I use the following code:

WhilePrintingRecords;
if Inrepeatedgroupheader then
  "Continued..."
else
  ""

You should be able to adapt it for other purposes, including suppressing unwanted sections. (Right-click on a section and choose Format Section. Then choose the formula icon (x+2 and a pencil) for suppression.)

Madawc Williams (East Anglia, UK)

 

[Thuky]

I made a mistake when I showed you what I have so far, I need the page header to show on every page, not the report header to show on every page. I corrected as below:

Here is what I have so far:

Report Header: Funded loans
Page Header (need to show on every page): Loan Numumber, Loan Amount
Group Header #1: AgentName (field)
Details: LoanNo (field), LoanAmount (field)
Group Footer :#1
Report footer
Page Footer

 

[Madawc]

Report headers can't appear every page, that's why they're report headers. Apart from that, you seem to have just repeated yourself without taking any notice of my suggestions. If it's unclear or unsuitable, it would help to know why.

Madawc Williams (East Anglia, UK)

 

[Thuky]

Hi Madawc,

I am new to Crystal report, so I am slow on it and sorry for a late response. I tried your code, but I am not sure what to write my statement as you stated as "Continued...". The syntax check is asking for a boolean to return. I did try True and even false, but didn't help to make as the way I need.

I am still not sure how to generate multiple reports at the same time for different agents.

 

[lbass]

Please show an example of you how you want your report to look with some sample data and with sections identified. What's confusing in part is that you seem to want to put some detail information in the page header (loan # and amount) when presumably there would be more than one loan# in the group.

I think the solution should be relatively simple, but I'm confused about what you're looking for.

-LB

 

[Thuky]

Hi lbass,

I was working on group headers (as Madawc's hints) and got what I need already. I created 2 group headers for AgentName (1 for report header and 1 for group header).


However for clarification, this my sample for reports for 2 agents generated at the same time right after I click on the GET REPORT button:

first report:
Loans For Agent: Mary Lee
Manager: Steve Smith

Loan Number Loan Amount
123 500000
456 600000


-----------------------------------------------------

second report:
Loans For Agent: Sue Bird
Manager: Ashley McLair

Loan Number Loan Amount
789 700000
356 800000




Report Header: Funded loans
Page Header (need to show on every page): Loan Numumber, Loan Amount
Group Header #1: AgentName (field)
Details: LoanNo (field), LoanAmount (field)
Group Footer :#1
Report footer
Page Footer


Thank you so much for your help and concern, Madawc and lbass!!! I really appreciated.