Radicore Forum: Transaction Patterns » Output2

Home » RADICORE development » Transaction Patterns » Output2 - SQL

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: Output2 - SQL [message #7356 is a reply to message #7355]

Wed, 04 September 2019 06:25

htManager
Messages: 433
Registered: May 2014

Senior Member

No, that's not what I am looking for. I want to sum how many times a person was out (wasn't available), grouped by the reason. But the reasons are listed in a different table and the number can change. For your understanding what I mean:

Person - reason 1 - reason 2 - reason 3 - ....
1 - 3 - 0 - 2 - ....
2 - 1 - 2 - 0 - ....
3 - 5 - 3 - 1 - ....

I hope I could explain what I mean.

Report message to a moderator

[Message index]

		Output2 - SQL By: htManager on Wed, 21 August 2019 17:11
		Re: Output2 - SQL By: AJM on Thu, 22 August 2019 04:07
		Re: Output2 - SQL By: htManager on Fri, 23 August 2019 05:24
		Re: Output2 - SQL By: AJM on Sat, 24 August 2019 04:27
		Re: Output2 - SQL By: htManager on Sun, 25 August 2019 13:30
		Re: Output2 - SQL By: AJM on Mon, 26 August 2019 04:42
		Re: Output2 - SQL By: htManager on Mon, 26 August 2019 09:36
		Re: Output2 - SQL By: AJM on Tue, 27 August 2019 04:46
		Re: Output2 - SQL By: htManager on Tue, 27 August 2019 09:13
		Re: Output2 - SQL By: AJM on Wed, 28 August 2019 05:15
		Re: Output2 - SQL By: htManager on Wed, 28 August 2019 06:56
		Re: Output2 - SQL By: AJM on Thu, 29 August 2019 03:49
		Re: Output2 - SQL By: htManager on Fri, 30 August 2019 10:00
		Re: Output2 - SQL By: AJM on Sat, 31 August 2019 04:41
		Re: Output2 - SQL By: htManager on Tue, 03 September 2019 06:15
		Re: Output2 - SQL By: AJM on Wed, 04 September 2019 04:41
		Re: Output2 - SQL By: htManager on Wed, 04 September 2019 06:25
		Re: Output2 - SQL By: AJM on Thu, 05 September 2019 04:14

Previous Topic:	add5 - Data Area
Next Topic:	Output2 - Options / 90° cell rotation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Fri Nov 22 18:11:45 EST 2024

Total time taken to generate the page: 0.01116 seconds