CodeCharge Studio
search Register Login  

Visual Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Archive -> GotoCode Archive

 2 rows per record

Print topic Send  topic

Author Message
Fonnie Reagan
Posted: 08/26/2002, 8:58 AM

I have several columns of data, so to make it look better I would like to add a second row for each record in the grid. The obvious solution of just adding the row and fields doesn't seem to work. Suggestions?
Ken Hardwick
Posted: 08/26/2002, 12:17 PM

Fonnie,
You didn't indicate your programming language...I have written some ASP functions that put the one field over another...basically...
end results is like...

PrtField = fldField1 & "<br>" & fldField2

If you are using ASP and would like a sample, send email token@kenhardwick.com
Superkikim
Posted: 08/26/2002, 12:18 PM

I don't understand what you expect ! Are you using CCS or CC ?
Can you give an example ? Is this something like this you want ?

First Last Dpt Phone
Job email


Fonnie Reagan
Posted: 08/26/2002, 12:23 PM

Sorry, still getting used to this.
Using CCS, ASP3.0 with Templates, IIS and MS SQL.

What I was trying for was:

Name Date1 Date2 Date3 Cost1 Cost2
SystemNotes

I didn't want to put 2 fields in the same cell because the SystemNotes field has a lot of characters, the reason to put it on a separate line.

Superkikim
Posted: 08/27/2002, 12:26 AM

Fonnie.
Creat two rows in your table. In the 1st row, put all fields you want.
Then on the second, put your "SystemNotes" field. If it doesn't work correctly, go to the "HTML" tab, search for {SystemNotes}

"Begin grid" says to CCS where your grid begin, and End, where it ends.. ;-)

Then, "Begin Row" says where you each record begin. It initiates the record loop and "End Row" init.

In the example below, it will appears wrongly (only last record on the page will show Systemnotes). To correct it, you should move the "End Row" table below the next "</TR>" tag. And it will show this field for each record


<!-- Begin Grid blabla -->
<table>
<tr>
<td>Name</td><td>Date1</td><td>Date2</td><td>Date3</td><td>Cost1</td><td>Cost2</td>
</tr>
<!-- Begin Row -->
<tr>
<td>{Name}</td><td>{Date1}</td><td>{Date2}</td><td>{Date3}</td><td>{Cost1}</td><td>{Cost2}</td>
</tr>
<!-- End Row -->
<tr>
<td colspan="6">{SystemNotes}</td>
</tr>
<!-- Begin NoRecord -->
<tr>
<td colspan="6"></td>
</tr>
<!-- End Norecord -->
</table>
Fonnie Reagan
Posted: 08/27/2002, 9:38 AM

Thanks for the help. I thought that I had checked the HTML but obviously I hadn't. The row was added to the table in the No Records section, so it never showed. Couple that with new field names and everything works now.
Again, thanks for the help.

   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

PHP Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.