CodeCharge Studio
search Register Login  

Visual PHP Web Development

Visually Create Internationalized Web Applications, Web Reports, Calendars, and more.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> General/Other

 Report Formatting

Print topic Send  topic

Author Message
Peter K
Posted: 01/11/2004, 1:39 PM


After some experimentation, I successfully created a report using the grid builder. It took a while but I was able to successfully do it.

Basically I ran the Grid Builder to generate the fields I wanted on the report. I selected a source and selected the columns I wanted to display. Select No Sorting and No Page Navigation. I used 10000 records per page (or however many you might want to display). That's all I did for the grid generation.

Now the hard part. I deleted the heading rows and just started moving the text fields and database fields around the grid as I wanted them displayed. I added additional rows to the grid as the report got longer.

When I ran it, I noticed that the data in the first row was not repeating. The Grid Builder identifies the first row as like a master row and would not display it again. After looking at the HTML code, I move the <!-- BEGIN Row --> marker above the first row in the grid. When I published the report, the first row was now displaying throught the entire report.

I figured I would post this in case someone else spent several hours trying to figure out how to create a report in CCS. I am using php and mysql.
RogerR

Posts: 21
Posted: 01/13/2004, 5:06 AM

Quote Peter K:

I am using php and mysql.

Peter, CCS is a fantastic program and I am not criticizing it in the least when I say that there are a lot better ways of creating reports in PHP than using CCS' grid builder. I use an ap called Report Manager, it is open source and you can find it at:

http://reportman.sourceforge.net/

It does a fantastic job of creating very professional looking reports. There is a bit of a learning curve but if you can learn CCS you can learn Report Manager without any trouble.

Also PHP has a PDF library that allows you to create on the fly PDF reports. This took me a little bit longer to get the hang of as opposed to Report Manager but it was well worth the time spent learning it. This is also Open Source and if memory serves it comes built into the later versions of PHP. However if I'm wrong about that it can be found on the SourceForge site. I don't have the URL handy and the site is down at this time for maintenance so I can't give you an address I apologize for that.

If your doing anything beyond the most elementry of reports I hope these solutions may prove to be of some help. However if you are infact happy with creating reports using the grid builder but would like to be able to set your page breaks where you want them then you might find this helpful:

Just place this tag at the place where you would like the page to break:
 <p style="page-break-before: always">

Here is some sample code to play with using this tag:

  
<html>  
<body>  
  
This is the text for page #1.  
  
<p style="page-break-before: always">  
  
Page #2...  
  
<p style="page-break-before: always">  
  
Page #3...  
  
</body>  
</html>  

I hope that something here is of some help to you or to someone else that might read this.

Roger R.
_________________
***********************************************************
The best antivirus a windose user can get - LINUX!
***********************************************************
View profile  Send private message
Peter K
Posted: 01/14/2004, 3:00 AM

:-{}
Awesome advice, thanks. That was the biggest hurdle is how to get page breaks. I'll try your suggestions.

I also took a look at the link you provided. I will definately download it and try it.

I spent hours trying to find a program like that. All I could come up with is Jasper Reports. Not the easiest thing to use however.

Thanks again for the information.
Peter K
Posted: 01/14/2004, 3:10 AM

Roger R. - can you send me your email address tokrawetzky1@earthlink.net? I would like to find out how you installed Report Manager. It's a little confusing.

thanks!
Steve_Ebbrell

Posts: 11
Posted: 01/14/2004, 7:13 AM

Another free report tool is Agata http://agata.codigolivre.org.br/index.php

Steve...
_________________
Ambition is the last refuge of the failure. - Oscar Wilde
View profile  Send private message
Edd


Posts: 547
Posted: 01/14/2004, 11:17 PM

Steve,
You must have been hunting as long as I have for Web reporting tools - As an ASP developer I thought I had found them all - thanks for the references.

Another royalty free distribution Report Writer is available at:
http://www.polarreports.com


_________________
Accepting and instigating change are life's challenges.

http://www.syntech.com.au
View profile  Send private message
Peter K
Posted: 01/16/2004, 3:12 AM

:-/ RogerR - I installed what I thought was the components required for Report Manager on the Windows 98 workstation and the server but I can't seem to get it working. The installation instructions are not very explicit to say the least.

Do you have instruction on how to install this stuff and get it working correctly?
Steve_Ebbrell

Posts: 11
Posted: 01/16/2004, 6:40 AM

Quote Edd:
Steve,
You must have been hunting as long as I have for Web reporting tools - As an ASP developer I thought I had found them all - thanks for the references.

Another royalty free distribution Report Writer is available at:
http://www.polarreports.com

Edd,
Thanks for that one, if I find any others I will mention them on the forum.



_________________
Ambition is the last refuge of the failure. - Oscar Wilde
View profile  Send private message
Peter K
Posted: 01/16/2004, 7:17 AM

:-X I don't want to pay $300. Yes, call me cheap. That's why we have open source. Thanks for the info!
RogerR

Posts: 21
Posted: 01/18/2004, 5:48 AM

Peter;

I tried emailing you but EarthLinks spam blocker bounced me.

What kind of server are you trying to install on, Linux or Windows?

Roger R.
_________________
***********************************************************
The best antivirus a windose user can get - LINUX!
***********************************************************
View profile  Send private message
Peter K
Posted: 01/18/2004, 8:10 AM

:( Sorry about that Roger. I am moving my email addresses from a cablemodem account to a DSL account. My email address is listed above.

Here is the configuration I would like to have instructions for:
Windows 98/XP client to a Red Hat Linux 8 running apache & mysql
Windows 98/XP to the same Windows machine running apache
& mysql

The software that I am developing can run on both configurations.
Peter K
Posted: 01/18/2004, 8:11 AM

I thought it would appear in the message. Anyway my email address iskrawetzkyjunk@sbcglobal.net
fred
Posted: 01/18/2004, 9:25 AM

Here are two more reporting tools:

this is a .net based tool, very easy:
http://www.colareport.com/colareport/

this is an entire reporting ide, very powerful:
http://www.epsilon-logic.net/ELSScript.asp
Peter K
Posted: 01/19/2004, 10:19 AM

Lets try my email address one more time. It'sjunkkrawetzky@sbcglobal.net
RogerR

Posts: 21
Posted: 01/19/2004, 11:47 AM

Again I try to email you and again it bounces.

Failed to deliver to 'krawetzkyjunk@sbcglobal.net'
SMTP module(domain sbcglobal.net) reports:
host vmb-ext.prodigy.net says:
553 5.3.0 <krawetzkyjunk@sbcglobal.net>... Addressee unknown, relay=[65.217.249.232]

Roger R.
_________________
***********************************************************
The best antivirus a windose user can get - LINUX!
***********************************************************
View profile  Send private message
Edd


Posts: 547
Posted: 01/21/2004, 5:25 AM

F.Y.I.

To add / ease to the dilemma of reporting for those who have MS SQL as their backend - see Microsoft's New Reporting Services which wil come bundled with SQL 2000 and is free to licenced customers.

http://www.microsoft.com/sql/reporting/default.asp

My contacts inside of MS (and these are harsh critics of MS products) who have played with it say it is VERY VERY impressive - a real CRYSTAL killer.

For us MS SQL devotees - it is g:-D:-Dd news.


_________________
Accepting and instigating change are life's challenges.

http://www.syntech.com.au
View profile  Send private message
Peter K
Posted: 01/21/2004, 10:23 AM

O:) I heard that Microsft was going to give Crystal a run for their money. I would really like to get Report Manager working but still have trouble getting the client workstation to connect to the server. Guess I will uninstall everything again and reinstall to see if I missed something.
Rao
Posted: 08/05/2004, 3:57 AM

Hi Roger
I have Oracle 8.1.7 and Oracle 9 running on Windows NT, 2000, XP and AIX5.1.

If I want to use Report Manager, what else do I need. After I download, could you please give some advice for the steps that I need to make this work.
Does this tool allow selection from multiple tables of desired fields (join)
Thanks very much, if you could email me.
Regards
Rao
Rao
Posted: 08/05/2004, 3:58 AM

Hi Roger R
sorry, my email id is
vrbhogaraju@yahoo.com

Thanks
Rao
Fola
Posted: 09/23/2004, 4:35 AM

Roger R. - can you send me your email address to
foyediran@gimmehelp.com? I would like to find out how you installed Report Manager. You sure have lots of fan out here who need this help. Like me:-D

thanks!

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.