Report Framework

Got a LiveCode personal license? Are you a beginner, hobbyist or educator that's new to LiveCode? This forum is the place to go for help getting started. Welcome!

Moderators: heatherlaine, Klaus, FourthWorld, kevinmiller

Post Reply
joseggarza
Posts: 16
Joined: Thu Jul 24, 2014 8:55 pm

Report Framework

Post by joseggarza » Wed May 25, 2016 11:29 pm

I am trying to make a few reports and while researching I found http://users.telenet.be/quartam/reports/ but it looks dead, I could not buy it. I tried to contact them without any luck. Any of you have information about this software developer? or any other options available?

Thanks
JG

Lagi Pittas
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 307
Joined: Mon Jun 10, 2013 1:32 pm

Re: Report Framework

Post by Lagi Pittas » Thu May 26, 2016 2:44 pm

Hi


Same her - 4 emails over the space of a year and no answer.
It looked good because it works like the Foxpro Report write I have used for years.

Now this would be a good third party app to have for the indy or business version if LC Towers is listening.
Most non business use (games and utils) wouldn't need it so you would have something that desktop developers would find useful.

Regards Lagi

FourthWorld
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 6154
Joined: Sat Apr 08, 2006 7:05 am
Location: Los Angeles
Contact:

Re: Report Framework

Post by FourthWorld » Thu May 26, 2016 3:09 pm

Perhaps we need a new report tool. What sorts of reports are you looking to make?
Richard Gaskin
Community volunteer LiveCode Community Liaison

LiveCode development, training, and consulting services: Fourth World Systems: http://FourthWorld.com
LiveCode User Group on Facebook : http://FaceBook.com/groups/LiveCodeUsers/

Lagi Pittas
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 307
Joined: Mon Jun 10, 2013 1:32 pm

Re: Report Framework

Post by Lagi Pittas » Thu May 26, 2016 3:36 pm

I can do all the reports I need at the moment using the built in commands but it's nice when you have comfortable shoes and report writers are a way that business developers (ex Foxpro, Access, Delphi, Clipper people) might see as a reason for jumping in.

Seems to me we are gonna be wrapping Crystal Reports and Jasper reports as widgets - but a native report writer would be better.

Lagi

FourthWorld
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 6154
Joined: Sat Apr 08, 2006 7:05 am
Location: Los Angeles
Contact:

Re: Report Framework

Post by FourthWorld » Thu May 26, 2016 4:25 pm

I agree, which is why I'm asking about specifics. Reporting can take on so many forms that it would be daunting to attempt to cover everything at once, but with some guidance on which formats and features are most immediately useful perhaps we can get a team to do this or I might do it myself.
Richard Gaskin
Community volunteer LiveCode Community Liaison

LiveCode development, training, and consulting services: Fourth World Systems: http://FourthWorld.com
LiveCode User Group on Facebook : http://FaceBook.com/groups/LiveCodeUsers/

mimu
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 40
Joined: Tue Mar 05, 2013 7:00 pm
Location: Berlin
Contact:

Re: Report Framework

Post by mimu » Thu May 26, 2016 5:36 pm

Yesterday evening i had a very promising phone call with Jan Schenkel of QuartamRepots.

At the moment he is involved in a very time consuming project using livecode server.
But the project deadline is close.

He told me that he will release a bugfix release for the current version during the next 2 month,
Version 2 for LC8 will hopefully be available before the end of this year.

So lets stay tuned.

joseggarza
Posts: 16
Joined: Thu Jul 24, 2014 8:55 pm

Re: Report Framework

Post by joseggarza » Thu May 26, 2016 6:13 pm

I am very new to LC and I could not find any tutorials on how to create report in terms of pagination. I Guess, I can just make some queries and insert the data in a Card, but I don't know how to make different pages based on tons of data and grouping, just like any other Report system. I am trying to figure how to do this with what is in LC but it is taking me lots of time and I have not been able to a do it at all. I am getting to a point of just getting crystal or jasper or even Access to do it, but I don't want to get another system just for reporting, so I though of asking in this forum for advice before taking this decision.

JG

Mikey
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 631
Joined: Fri Jun 27, 2008 9:00 pm

Re: Report Framework

Post by Mikey » Fri May 27, 2016 2:44 pm

Jan told me, a year ago, that QR was going OSS, but repeated badgering has resulted in silence, so I'm not holding my breath.

In the meantime, you can use Valentina, which is being actively developed, and has native hooks into LC.

MaxV
Posts: 1539
Joined: Tue May 28, 2013 2:20 pm
Location: Italy
Contact:

Re: Report Framework

Post by MaxV » Wed Jun 08, 2016 4:25 pm

joseggarza wrote:I am very new to LC and I could not find any tutorials on how to create report in terms of pagination. I Guess, I can just make some queries and insert the data in a Card, but I don't know how to make different pages based on tons of data and grouping, just like any other Report system. I am trying to figure how to do this with what is in LC but it is taking me lots of time and I have not been able to a do it at all. I am getting to a point of just getting crystal or jasper or even Access to do it, but I don't want to get another system just for reporting, so I though of asking in this forum for advice before taking this decision.

JG
The easy and short way for reports:
  1. create a substack as template for reports
  2. put all fields needed
  3. extract data from you database
  4. line after line fill the fields of the template
  5. after filling the last field, use this command:

    Code: Select all

    clone this card
  6. repeat points 4 and 5 to the end of your data
  7. now you can print/export in PDF your report with:

    Code: Select all

    go to card 1
    set the formatForPrinting of this stack to true 
    open printing to pdf "./myprint.pdf"
    print this stack   
    close printing
    
  8. now delete cards n down to 2 and empty fields of card 1 for future reuse of the template.
You need about 15 minutes of coding to do this. :P
Last edited by MaxV on Mon Aug 22, 2016 11:48 am, edited 1 time in total.
Livecode Wiki: http://livecode.wikia.com
My blog: http://livecodeitalia.blogspot.it
To post code use this: http://tinyurl.com/ogp6d5w

joseggarza
Posts: 16
Joined: Thu Jul 24, 2014 8:55 pm

Re: Report Framework

Post by joseggarza » Mon Aug 15, 2016 6:51 pm

MaxV,

Thanks for your solutions,

I will try it. I think is the best an cheapest solution. Valentina is just out of my budget right now.

Best Regards,

gagsoft
Posts: 115
Joined: Sat Jun 29, 2013 7:56 pm

Re: Report Framework

Post by gagsoft » Sun May 13, 2018 11:17 am

Hi Guys
Any news on the wrapping Crystal Reports in LC.
This would be could news to me.
Used it in previous Delphi projects a while back and the results were really impressive.

Would like to here if there are any efforts regarding wrapping Crystal Reports in LC

Peter G

FourthWorld
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 6154
Joined: Sat Apr 08, 2006 7:05 am
Location: Los Angeles
Contact:

Re: Report Framework

Post by FourthWorld » Sun May 13, 2018 3:39 pm

IIRC Crystal Reports is available for only one platform, and most folks use LC for multiplatform apps. So I don't think we'd see much attraction for Crystal Reports in this audience. Using it would be great for Windows, but then you'd still need to write everything it does from scratch anyway for every other OS.
Richard Gaskin
Community volunteer LiveCode Community Liaison

LiveCode development, training, and consulting services: Fourth World Systems: http://FourthWorld.com
LiveCode User Group on Facebook : http://FaceBook.com/groups/LiveCodeUsers/

Post Reply

Return to “Getting Started with LiveCode - Complete Beginners”