Radicore Forum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » RADICORE development » Transaction Patterns » Output2 - SQL
Re: Output2 - SQL [message #7354 is a reply to message #7351] Tue, 03 September 2019 06:15 Go to previous messageGo to previous message
htManager is currently offline  htManager
Messages: 220
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?
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: add5 - Data Area
Next Topic: Output2 - Options / 90° cell rotation
Goto Forum:
  


Current Time: Mon Nov 18 10:24:14 EST 2019

Total time taken to generate the page: 0.01189 seconds