CodeCharge Studio
search Register Login  

Web Reporting

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

YesSoftware Forums -> CodeCharge Studio -> PHP

 Help Me!

Print topic Send  topic

Author Message
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>
View profile  Send private message
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
View profile  Send private message

Add new topic Subscribe to topic   


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

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.

CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


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