Home » Developer & Programmer » Reports & Discoverer » Matrix Report
Matrix Report [message #671499] Sun, 02 September 2018 09:09 Go to next message
shahzad-ul-hasan
Messages: 561
Registered: August 2002
Senior Member
Respected Sir,
i want to create a report that's show the present and absent of student (Rollcall). if an employee forgot to mark the rollcall of the student it should show empty column. i have table of absent and absent1 with master and detail relation. the table structure is attached with this message.
the report of output required is attached here.
Re: Matrix Report [message #671500 is a reply to message #671499] Sun, 02 September 2018 09:10 Go to previous messageGo to next message
shahzad-ul-hasan
Messages: 561
Registered: August 2002
Senior Member
/forum/fa/13910/0/


[EDITED by LF: inserted image into the message body]
  • Attachment: Admin.jpg
    (Size: 63.97KB, Downloaded 1057 times)

[Updated on: Mon, 03 September 2018 05:37] by Moderator

Report message to a moderator

Re: Matrix Report [message #671507 is a reply to message #671499] Mon, 03 September 2018 01:54 Go to previous messageGo to next message
John Watson
Messages: 8085
Registered: January 2010
Location: Global Village
Senior Member
Is this a college homework question? You need to show the SQL you have tried so far, and explain what it is that you are stuck on.
Re: Matrix Report [message #671509 is a reply to message #671507] Mon, 03 September 2018 05:35 Go to previous message
Littlefoot
Messages: 21518
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
John, regarding the fact that Shahzad registered in 2002, I wouldn't say that this is a homework.

As of the question: query should return 3 values for matrix layout:
- row
- column
- cell

Once you manage to do that, follow the Wizard and put everything into its own "place" - the Wizard will do everything for you (create that awful data model, layout ... everything). You'd then just adjust it to look pretty.

[Updated on: Mon, 03 September 2018 05:39]

Report message to a moderator

Previous Topic: run report from menu
Next Topic: null date
Goto Forum:
  


Current Time: Sat Dec 14 17:58:23 CST 2019