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 #7354 is a reply to message #7351]

Tue, 03 September 2019 06:15

htManager
Messages: 415
Registered: May 2014

Senior Member

Exactly what I was looking for. Thank you very much. Replacing the $where string with the right primary key fields led to the right solution. Everything seems to work fine now.

Two more questions:
1. As you can see I want to generate a report with a 'Cross' or 'Pivot' table. Do you have an example where you did deal with this? I have now hard coded the columns but each time I insert a new column I have to change my code.

2. Is there a possibility to output the 1 in a boolean field as a check mark?

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: Thu Apr 25 19:35:10 EDT 2024

Total time taken to generate the page: 0.01167 seconds