odhin24
Posts: 2
|
| Posted: 03/06/2014, 7:09 AM |
|
Hi, I writing to you because I'm a rookie at all what a web programming refers (php , html , asp, etc. .. ), I was assigned to modify a project that was already running. I am using Code Charge Studio 5 and the database to which you connect the project is Postgres.
Now I explain my situation, there is a report that accesses the database postgres and extracts certain values of the fields in a table to be displayed in the report, with the option to print the report. To display information used 7 " Report Labels " within a table tag. Now I have to add 22 more fields to display in the report but varying the size of the "Report Footer " which is where the tag table, change depending on whether the record in the field of table database is empty . Ie show only fields with data and resize the form.
Thank you in advance for help with my problem as I have searched the net but only speak using div tags and modify ASP . But little or nothing in PHP or if it can be solved with the same builder.
This copy of a piece of HTML:
<tr class="NoRecords">
<td colspan="3"><strong><font size="2">
<table border="1" cellpadding="2" width="100%">
<tr>
<td style="TEXT-ALIGN: center">{ReportLabel11}<br>
{ReportLabel21}<br>
{ReportLabel22}<br>
{ReportLabel23}<br>
{ReportLabel24}<br>
{ReportLabel25}<br>
{ReportLabel26}</td>
</tr>
</table>
<br>
<img style="WIDTH: 919px; HEIGHT: 50px" id="enca_nuevas_garantias_nue3Report_FooterNoRecords2Image1" alt="" src="asilohacemos.jpg" width="1045" height="128"></font></strong></td>
</tr>
<!-- END Panel NoRecords2 --><!-- END Section Report_Footer -->
</table>
</td>
</tr>
</table>
<!-- END Report enca_nuevas_garantias_nue3 -->{Label1}</td>
</tr>
|
 |
 |
eratech
Posts: 513
|
| Posted: 03/06/2014, 4:36 PM |
|
Hi odhin - I read through your question but I'm still not sure what the HTML snippet is trying to do, especially regarding the 'show only fields with data and resize the form' as the '<br>' tags between the labels will turn up anyway, even if the labels have nothing in them.
And just trying stuff on PHP and ASP sites won't really help, as most of the steps you would do in Codecharge is using the Designer rather than edting the HTML and code directly (although that is useful sometimes) so I suggest:
1) Edit the Report in the Designer, adding the extra rows and labels (you might need to adjust the Report Data source if you are not already retrieveing the extra data columns from Postgres)
2) set the Data source property of each label to the new fields
3) Look at the 'Before Show Row' event of the Report - you can put 'Custom Code' in to check if certain fields have no data, and do something there like hiding that field (fieldname->Visibility = false) (but if there is no record, then it won't show on the report anyway)
Some more info on what you are trying to do would help, and perhaps the entire HTML for the full Report (from "<!-- START Report enca_nuevas_garantias_nue3 -->" to "<!-- END Report enca_nuevas_garantias_nue3 -->")
Thanks
Eric
_________________
CCS 3/4/5 ASP Classic, VB.NET, PHP
Melbourne, Victoria, Australia |
|
|
|
|
