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!
*********************************************************** |
|
|
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 |
|
|
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 |
|
|
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 |
|
|
Peter K
|
Posted: 01/16/2004, 7:17 AM |
|
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!
*********************************************************** |
|
|
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!
*********************************************************** |
|
|
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 gd news.
_________________
Accepting and instigating change are life's challenges.
http://www.syntech.com.au |
|
|
Peter K
|
Posted: 01/21/2004, 10:23 AM |
|
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
thanks!
|
|
|