help needed for report

[princeofdumph]

hi,
i have created a report for salesforce people, where every person's record is shown on separate report page alongwith his eligible allowances. the problem is that the report correctly shows the allowances he is eligible to, but also shows the labels and blank fields for all other allowances that apply to other employees, thus making the page very detailed and lengthy. how can i overcome this problem? tell me about some specific code to write and where to write it, or how should i make any changes to underlying query? thanx

 

[vbaInet]

Your problem isn't clearly explained. Can you show us a screenshot of the problem.

 

[princeofdumph]

hi, dont have a screenshot of it at the moment, but here is how it looks like:

Salary FA1 FA2 FA3 VA1 VA2 VA3
Employee1 2000 40 100 120 150

page break here-------
Employee2 2500 50 60 80

page break here-------
Employee3 3000 100 80 200 40

and so on....
FA stands for 'fixed allowance' and VA stands for 'variable allowance'.

here you will see although each employee is entitled to different allowances, still all other columns appear in everyones' report page. i want only employee-specific allowances to be shown for each emplolyee's report page. cant figure out how to do this, or what kind of query changes i make? i hope this explains.

 

[vbaInet]

That's because your table is not normalized. What is the maximum number of FA and VA possible?

 

[princeofdumph]

they vary from employee to employee. FAs are 25 in total. VAs are 5 in total.

 

[vbaInet]

Do you have an EmployeeID field?

You should have a junction table of FAs and another for VAs where each employees FA and VA is record as individual records and not in a columnar fashion like you have it. If the VA is related to the FA then you can have one junction table with EmployeeID, FA and VA linked to the Employees table via EmployeeID and FA and VA.

 

[princeofdumph]

can we discuss in detail about my database. as you are the expert, i would appreciate if we have a proper one-to-one session via online chat. because both of us are posting here small bits of questions and replies. not a better approach, i think. if you feel appropriate, skype or msn messenger will do. thanks

 

[vbaInet]

The essence behind a (free) forum is to get help from lots of different people and share knowledge. Having a one-to-one discussion will defeat this purpose and besides that I just won't have the time to have a one-to-one plus I don't give out my contact details

We can carry on on here.

If you need help on normalization then you need to post a new thread in the Tables section or in the Theory & Practice section of the forum and someone will be able to advise.

 

[marthacasting]

hi,
i have created a report for salesforce people, where every person's record is shown on separate report page alongwith his eligible allowances. the problem is that the report correctly shows the allowances he is eligible to, but also shows the labels and blank fields for all other allowances that apply to other employees, thus making the page very detailed and lengthy. how can i overcome this problem? tell me about some specific code to write and where to write it, or how should i make any changes to underlying query? thanx

I am wondering how you got each person's record on a separate page and were able to make it lenghty & detailed! I need to create a report that has one page of information per person (each person is a record), with about 50 fields per person/record!!

 

[vbaInet]

The following link should give you some pointers:

http://office.microsoft.com/en-us/access-help/create-a-grouped-or-summary-report-HA010006894.aspx

Also, look into the Force New Page property of a Group Footer's section.