Forum

HomeHomeCoreCoreGeneralGeneralGrid outputGrid output
Previous
 
Next
New Post
11/30/2014 8:20 AM
 

Is there a way to output the data in a grid.  Rec1 then Rec2 to the right of it, new Row ...

New Post
12/4/2014 6:03 AM
 

Can you use detail and alternate detail output records with one as style="clear:both;float:left" and the other as style="float:right" ?


Or there's this http://www.openwebstudio.com/Communit...

New Post
12/4/2014 6:52 AM
 
We have had success using SQL and the nested header/footers to present multiple records in one html row.

See the attached image for a general layout of the templates in OWS.  Forget it, upload isn't working. Link to twitter: https://twitter.com/SysAdmnDrew/statu...

Summary: Header[0] and Footer[0] serve to open and close the table.  Header[1] and Footer[1] serve as the <tr> and </tr>, respectively.  The detail template serves as the <td>......stuff.....</td>.



Example SQL to present records 6 across in each row:


DECLARE @ROWWIDTH INT = 7 --SET TO 1 HIGHER THAN YOUR DESIRED RECORD ROW WIDTH


WITH T1 AS (
SELECT ADDRID
, NAME
, ADDRESS
, PHONENUM
, EMAIL
FROM ADDRESSTABLE
)


SELECT (ROW_NUMBER() OVER(ORDER BY ADDRID))/@ROWWIDTH AS RC
, T1.*
FROM T1
ORDER BY T1.ADDRID
New Post
12/5/2014 12:06 AM
 

Ooh, I like that.  Thanks very much for this, every day's a school day!


New Post
12/5/2014 4:45 AM
 

No problem, glad to help!

Previous
 
Next
HomeHomeCoreCoreGeneralGeneralGrid outputGrid output


 

New York, NY • Baltimore, MD • Vienna, VA • St. Louis, MO • Seattle, WA • info@openwebstudio.com

Bookmark & Share Bookmark and Share