[Gambas-user] Re port for Gambas
Sergio A. Hernandez
info.geex at ...626...
Wed May 13 03:53:42 CEST 2009
Kido,
Other nice option is to use the XSLT component.
At the beginning I was thinking in some fancy PInvoke over Kugar, but
after the email from Marc I realize that we need to keep it in the
scope of the simplest solution.
The best thing to do is to convert the mysql output to xml, then
transform to xslt without leaving Gambas. By doing this, you reduce
the need of other dependency, and can modify easily the way the report
looks using some fance css.
I apologize for pointed you guys in the wrong direction.
PS. Recently, I recommend to Ricky (the Doctor) to create directly the
HTML file from some parsed data because at that time I was using to
write some XML example for the Gambas book I'm writing. Honestly, I
must admit that I was not analyzing the issue correctly just because I
wanted to 'kill two birds with one stone'.
On Tue, May 12, 2009 at 6:29 AM, Marc Miralles <marc at ...2075...> wrote:
> yes Sergio, it works perfectly on gambas. I Think at this moment is a
> good solution for make reports in gambas
>
> I test this in gambas 2.12
>
> Here the code in gambas, it's very easy:
>
> PUBLIC FUNCTION kugar
> DIM flname AS String
> DIM hfile AS file
>
> flname = User.home & "/gambas//projectname//reports/test.kdf"
> IF Exist(flname) THEN KILL flname
> OPEN flname FOR WRITE CREATE AS #hFile
> 'Make Kugar file data in XML
> PRINT #hfile, "<?xml version='1.0' encoding='UTF-8'?>"
> PRINT #hfile, ""
> PRINT #hfile, "<!DOCTYPE KugarData ["
> PRINT #hfile, " <!ELEMENT KugarData (Row* )>"
> PRINT #hfile, " <!ATTLIST KugarData"
> PRINT #hfile, " Template CDATA #REQUIRED>"
> PRINT #hfile, ""
> PRINT #hfile, " <!ELEMENT Row EMPTY>"
> PRINT #hfile, " <!ATTLIST Row"
> PRINT #hfile, " level CDATA #REQUIRED"
> PRINT #hfile, " title CDATA #REQUIRED"
> PRINT #hfile, " version CDATA #REQUIRED"
> PRINT #hfile, " platform CDATA #REQUIRED"
> PRINT #hfile, " copies CDATA #REQUIRED>"
> PRINT #hfile, "]>"
> PRINT #hfile, ""
> ' here you can replace next lines for a "for each in...." and
> replace fields with mysq result and add some rows
> PRINT #hfile, "<KugarData Template='test.ktf'>"
> PRINT #hfile, " <Row level= '0' title= 'BRU' version= '15.0'
> platform= 'x86' copies= '1'/>"
> PRINT #hfile, " <Row level= '0' title= 'Caldera Open Linux'
> version= '2.2' platform= 'x86' copies= '3'/>"
> PRINT #hfile, "</KugarData>"
> CLOSE #hFile
> Message.Info("File Created", "OK")
> SHELL "kugar " & flname
> END
>
>
>
> En/na Sergio A. Hernandez ha escrit:
>> Marc,
>> I get confused, I made work Kugar work under C++ QT, but I'm not quite
>> sure I can on Gambas.
>> The best way with Gambas is, just like you said, create a HTML
>> customized report. But is a time consuming project that probably Kido
>> is not going to use anymore.
>> If you can make work Kugar under gambas please let us know.
>>
>> On Fri, May 8, 2009 at 7:36 AM, Marc Miralles <marc at ...2075...> wrote:
>>
>>> Dear Kido Zu
>>>
>>> I think this sample and guide in docs.kde is good for you. In this
>>> moment I haven't a sample in gambas but I think it's a good info for
>>> beginning.
>>>
>>> http://docs.kde.org/kde3/en/koffice/kugar/tutorial.html ( for make
>>> template)
>>> http://docs.kde.org/kde3/en/koffice/kugar/tut-2.html (about how to make
>>> a data file with SQL result)
>>> http://docs.kde.org/kde3/en/koffice/kugar/tut-3.html (how to run report
>>> in any language)
>>>
>>> This night I can test Kugar in gambas I think is similar to make report
>>> in HTML, You can create a XML data file with required format and run
>>> it in gambas with Kugar.
>>>
>>> I think its easy.
>>>
>>> If this night I have time to do it and if I have exit I send sample to
>>> your mail.
>>>
>>>
>>>
>>> En/na Kido Zu ha escrit:
>>>
>>>> thanks Marc..
>>>>
>>>> can you show me or give me an example how to create Kugar report for
>>>> Gambas...with a simple way?:confused:
>>>>
>>>>
>>>>
>>>> Marc Miralles wrote:
>>>>
>>>>
>>>>> Hi Kido zu
>>>>>
>>>>> I test Kugar in gnome, now, in Ubuntu 9.04 and it work fine.
>>>>>
>>>>>
>>>>>
>>>>> En/na Kido zu ha escrit:
>>>>>
>>>>>
>>>>>> Hi...
>>>>>>
>>>>>> what's the best report for Gambas?
>>>>>> i'm using ubuntu and MySQL.
>>>>>> can Kugar run on Gnome?
>>>>>>
>>>>>> thanks...
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> ------------------------------------------------------------------------------
>>>>>> The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
>>>>>> production scanning environment may not be a perfect world - but thanks
>>>>>> to
>>>>>> Kodak, there's a perfect scanner to get the job done! With the NEW KODAK
>>>>>> i700
>>>>>> Series Scanner you'll get full speed at 300 dpi even with all image
>>>>>> processing features enabled. http://p.sf.net/sfu/kodak-com
>>>>>> _______________________________________________
>>>>>> Gambas-user mailing list
>>>>>> Gambas-user at lists.sourceforge.net
>>>>>> https://lists.sourceforge.net/lists/listinfo/gambas-user
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>> ------------------------------------------------------------------------------
>>>>> The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
>>>>> production scanning environment may not be a perfect world - but thanks to
>>>>> Kodak, there's a perfect scanner to get the job done! With the NEW KODAK
>>>>> i700
>>>>> Series Scanner you'll get full speed at 300 dpi even with all image
>>>>> processing features enabled. http://p.sf.net/sfu/kodak-com
>>>>> _______________________________________________
>>>>> Gambas-user mailing list
>>>>> Gambas-user at lists.sourceforge.net
>>>>> https://lists.sourceforge.net/lists/listinfo/gambas-user
>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>> ------------------------------------------------------------------------------
>>> The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
>>> production scanning environment may not be a perfect world - but thanks to
>>> Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700
>>> Series Scanner you'll get full speed at 300 dpi even with all image
>>> processing features enabled. http://p.sf.net/sfu/kodak-com
>>> _______________________________________________
>>> Gambas-user mailing list
>>> Gambas-user at lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/gambas-user
>>>
>>>
>>
>> ------------------------------------------------------------------------------
>> The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
>> production scanning environment may not be a perfect world - but thanks to
>> Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700
>> Series Scanner you'll get full speed at 300 dpi even with all image
>> processing features enabled. http://p.sf.net/sfu/kodak-com
>> _______________________________________________
>> Gambas-user mailing list
>> Gambas-user at lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/gambas-user
>>
>>
>
>
>
> ------------------------------------------------------------------------------
> The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
> production scanning environment may not be a perfect world - but thanks to
> Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700
> Series Scanner you'll get full speed at 300 dpi even with all image
> processing features enabled. http://p.sf.net/sfu/kodak-com
> _______________________________________________
> Gambas-user mailing list
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user
>
More information about the User
mailing list