[Gambas-user] Re port for Gambas

[Marc Miralles]

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
>
>