engnouna
August 21st, 2007, 05:29 AM
Hi
I want to create a Crystal Report that displays the UserAccess of all Users.Well I have 2 tables Users and UserAccess.
Users has the follwoing fields:
Code,FirstName,LastName
And UsersAccess has the following fields:
Appcode,Code,Type,Allow
An example of the data for user whose code is 4
Users:
4 John Haward
UserAccess:
1 4 read 0
1 4 write 0
1 4 Pay 0
2 4 Check 1
That means that for the Application (1),the user 4 is not allowed to read,write nor Pay,But in the Application 2,the user 4 is allowed to Check
I want to make the report look like:
User(FirstName & LastName) Application1
__________________________________________________
Read X
Write X
Pay X
Check X
User(FirstName & LastName) Application2
__________________________________________________
Read X
Write X
Pay X
Check Y
So For each User I want to show its Access for Application1 and Application2
If the Typ,let's say "Read" does not exist in the row for The specified user and the specified Application or Allow=0 then X is displayed otherwise Y is displayed
So this report will generate n pages(n is the number of distinct(code) in UserAccess) and each page will have 2 parts(one for Application1,the other for Application2) and in each part the same list of typ is displayed with X or Y
Can anyone give me some help?
thanks
I want to create a Crystal Report that displays the UserAccess of all Users.Well I have 2 tables Users and UserAccess.
Users has the follwoing fields:
Code,FirstName,LastName
And UsersAccess has the following fields:
Appcode,Code,Type,Allow
An example of the data for user whose code is 4
Users:
4 John Haward
UserAccess:
1 4 read 0
1 4 write 0
1 4 Pay 0
2 4 Check 1
That means that for the Application (1),the user 4 is not allowed to read,write nor Pay,But in the Application 2,the user 4 is allowed to Check
I want to make the report look like:
User(FirstName & LastName) Application1
__________________________________________________
Read X
Write X
Pay X
Check X
User(FirstName & LastName) Application2
__________________________________________________
Read X
Write X
Pay X
Check Y
So For each User I want to show its Access for Application1 and Application2
If the Typ,let's say "Read" does not exist in the row for The specified user and the specified Application or Allow=0 then X is displayed otherwise Y is displayed
So this report will generate n pages(n is the number of distinct(code) in UserAccess) and each page will have 2 parts(one for Application1,the other for Application2) and in each part the same list of typ is displayed with X or Y
Can anyone give me some help?
thanks