Run Multiple Reports w/ Names Changes In Report Title 1

[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.

 

[MisterMo]

Hi Thuky

Are all these information stored onto the database? is there some sort of relationship link between manager and agent?

if that is the case then all you need to do is to create group for your manager first and another group for your agent.

Report Header: Funded loans (text label and need to show on every page)

if you want to see this on every page then move the the page header as the report header is only printed once at the beginning of the report

You could then have an input parameter where the manager must put is ID number so that he/she will see only data relating to his/her agents.

Could you give me an idea of the tables that you are using.

Mo

 

[Thuky]

Hi MisterMo,

My tables are stored in SQL server 2000.

Table relationship:

select loanNo, LoanAmount, AgentFName +' '+ agentLName
from Loans left outer join agents on
loans.agentID = Agents.AgentID left outer join Mangers on
loans.MgrID = managers.mgrID


Also, 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 Number, Loan Amount
Group Header #1: AgentName (field)
Details: LoanNo (field), LoanAmount (field)
Group Footer :#1
Report footer
Page Footer

Thanks

 

[Thuky]

Hi MisterMo, I already got what I need. Thanks for your help.