Reporting Solutions that work with SQLite / VB 2015?

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
9 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Reporting Solutions that work with SQLite / VB 2015?

Craig Bisgeier
Greetings - I am working on a Visual Basic 2015 application that uses SQLite as its database, and I have a need to print several types of reports from the project. I'd originally hoped to use Crystal Reports 2008 but that isn't working out (incompatible with latest version of VB) and so I'm looking for another reporting solution. 
I am wondering if anyone can recommend a free or low-cost reporting solution that will work with SQLite and be compatible with Visual Basic 2015 as an embedded or callable application?  This is a project that will never make a lot of money so cost is an object.  
Thank you Craig Bisgeier


_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Reporting Solutions that work with SQLite / VB 2015?

James K. Lowden
On Fri, 24 Mar 2017 19:29:07 +0000 (UTC)
Craig Bisgeier <[hidden email]> wrote:

> I am wondering if anyone can recommend a free or low-cost reporting
> solution that will work with SQLite and be compatible with Visual
> Basic 2015 as an embedded or callable application?  This is a project
> that will never make a lot of money so cost is an object.  

Although it uses tools rarely seen in VB environments, I recently wrote
a utility to produce simple reports.  

        https://github.com/jklowden/sqlrpt

Numeric columns are aligned on the decimal point and formatted with the
thousands separator consistent with the locale.  Wide text columns are
formatted to fit nicely on the page.

Groff is available as a Windows binary.  As a typesetting system,
it's very different from Crystal Reports.  But it's certainly capable
of producing anything you're likely to need.  

--jkl
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Reporting Solutions that work with SQLite / VB 2015?

Matthias-Christian Ott
In reply to this post by Craig Bisgeier
On 2017-03-24 20:29, Craig Bisgeier wrote:
> Greetings - I am working on a Visual Basic 2015 application that uses SQLite as its database, and I have a need to print several types of reports from the project. I'd originally hoped to use Crystal Reports 2008 but that isn't working out (incompatible with latest version of VB) and so I'm looking for another reporting solution.
> I am wondering if anyone can recommend a free or low-cost reporting solution that will work with SQLite and be compatible with Visual Basic 2015 as an embedded or callable application?  This is a project that will never make a lot of money so cost is an object.  

There are multiple ODBC drivers for SQLite. Reporting software on
Windows usually supports ODBC. There are also JDBC drivers for SQLite
for Java based reporting software.

Perhaps Wikipedia's list of reporting software [1] helps you to choose a
reporting software that meets your requirements.

- Matthias-Christian

[1]
https://en.wikipedia.org/w/index.php?title=List_of_reporting_software&oldid=770153994
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Reporting Solutions that work with SQLite / VB 2015?

Chris Locke-3
In reply to this post by James K. Lowden
Have you tried exporting to Excel? They're are even components (relatively
cheap) to convert to PDF so both bases are covered.
Exporting to excel allows columns to be used so figures line up nicely.
Open source applications open excel files.



Thanks,
Chris

On 24 Mar 2017 8:03 p.m., "James K. Lowden" <[hidden email]>
wrote:

> On Fri, 24 Mar 2017 19:29:07 +0000 (UTC)
> Craig Bisgeier <[hidden email]> wrote:
>
> > I am wondering if anyone can recommend a free or low-cost reporting
> > solution that will work with SQLite and be compatible with Visual
> > Basic 2015 as an embedded or callable application?  This is a project
> > that will never make a lot of money so cost is an object.
>
> Although it uses tools rarely seen in VB environments, I recently wrote
> a utility to produce simple reports.
>
>         https://github.com/jklowden/sqlrpt
>
> Numeric columns are aligned on the decimal point and formatted with the
> thousands separator consistent with the locale.  Wide text columns are
> formatted to fit nicely on the page.
>
> Groff is available as a Windows binary.  As a typesetting system,
> it's very different from Crystal Reports.  But it's certainly capable
> of producing anything you're likely to need.
>
> --jkl
> _______________________________________________
> sqlite-users mailing list
> [hidden email]
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Reporting Solutions that work with SQLite / VB 2015?

Cousin Stanley-3
In reply to this post by James K. Lowden
James K. Lowden wrote:

> I recently wrote a utility to produce simple reports.
>
>   https://github.com/jklowden/sqlrpt
>
> Numeric columns are aligned on the decimal point and formatted
> with the thousands separator consistent with the locale.  
>
> Wide text columns are formatted to fit nicely on the page.

James ....

  I installed your  sqlrpt  program under debian linux
  and managed to successfully run it with an sql query
  from a file ....

    $ sqlrpt -d ../db/test.sql3 -q "`cat stocks_list.sql`" > stocks.out

  and display the output via the  man  command ....

    $ man ./stocks.out

┌───────────────────────────────────────────────────────────────────────────────┐
│date         trans   name               qty          price       amount        │
├───────────────────────────────────────────────────────────────────────────────┤
│2011‐06‐04   BUY     Bank of America     30.000000   11.280000      338.400000 │
│2011‐06‐04   BUY     Citigroup          500.000000   39.850000   19,925.000000 │
│2011‐06‐04   BUY     Ford Motor         300.000000   14.010000    4,203.000000 │
│2011‐06‐04   BUY     General Electric   100.000000   18.820000    1,882.000000 │
│2011‐06‐04   BUY     Jp Morgan Chase    500.000000   41.570000   20,785.000000 │
│2011‐06‐04   BUY     Nokia               50.000000    6.660000      333.000000 │
│2011‐06‐04   BUY     Pfizer             100.000000   20.840000    2,084.000000 │
│2006‐01‐05   BUY     Red Hat            100.000000   35.130000    3,513.000000 │
│2011‐06‐04   BUY     Sprint Nextel      200.000000    5.670000    1,134.000000 │
│2011‐06‐04   BUY     Wells Fargo        300.000000   26.860000    8,058.000000 │
└───────────────────────────────────────────────────────────────────────────────┘

  The question is ....

    Can the floating point numbers be formatted
    for example .... ah la .... %8.4f

  I have seen the width option under the format column specifiers
  in  man tbl  but haven't tried using it with the sqlrpt -f option ....


 
--
Stanley C. Kitching
Human Being
Phoenix, Arizona

_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Reporting Solutions that work with SQLite / VB 2015?

James K. Lowden
On Sat, 25 Mar 2017 22:32:49 -0700
Cousin Stanley <[hidden email]> wrote:

> James K. Lowden wrote:
> >   https://github.com/jklowden/sqlrpt
>
>   I installed your  sqlrpt  program under debian linux
>   and managed to successfully run it with an sql query
>   from a file ....
>
>     $ sqlrpt -d ../db/test.sql3 -q "`cat stocks_list.sql`" >
> stocks.out
...
>     Can the floating point numbers be formatted
>     for example .... ah la .... %8.4f

Cousin Stanley,

Indeed you now can.  I added a -p option, documented in the man page.
You supply the column name & printf format string you want to use for
it.  It works for numbers only: integers and floating point.  Strings
continue to be formatted by tbl & troff.

$ ./sqlrpt -p "Value,%'6.2f" -d db  -q "select Value  from T limit 4" |
nroff -t | cat -s
+-------+
|Value  |
+-------+
|  0.94 |
|  0.96 |
|  0.95 |
|  0.93 |
+-------+


--jkl
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Reporting Solutions that work with SQLite / VB 2015?

Ron Barnes
All,

Pardon me for interjecting.

Are there any reporting solutions that work with VB 2015?

-Ron

-----Original Message-----
From: sqlite-users [mailto:[hidden email]] On Behalf Of James K. Lowden
Sent: Saturday, April 1, 2017 8:11 PM
To: [hidden email]
Subject: Re: [sqlite] Reporting Solutions that work with SQLite / VB 2015?

On Sat, 25 Mar 2017 22:32:49 -0700
Cousin Stanley <[hidden email]> wrote:

> James K. Lowden wrote:
> >   https://github.com/jklowden/sqlrpt
>
>   I installed your  sqlrpt  program under debian linux
>   and managed to successfully run it with an sql query
>   from a file ....
>
>     $ sqlrpt -d ../db/test.sql3 -q "`cat stocks_list.sql`" >
> stocks.out
...
>     Can the floating point numbers be formatted
>     for example .... ah la .... %8.4f

Cousin Stanley,

Indeed you now can.  I added a -p option, documented in the man page.
You supply the column name & printf format string you want to use for it.  It works for numbers only: integers and floating point.  Strings continue to be formatted by tbl & troff.

$ ./sqlrpt -p "Value,%'6.2f" -d db  -q "select Value  from T limit 4" | nroff -t | cat -s
+-------+
|Value  |
+-------+
|  0.94 |
|  0.96 |
|  0.95 |
|  0.93 |
+-------+


--jkl
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Reporting Solutions that work with SQLite / VB 2015?

Cousin Stanley-3
In reply to this post by James K. Lowden
Cousin Stanley wrote:

>> regarding your  sqlrpt  program ....
>>
>> Can the floating point numbers be formatted
>> for example .... ah la .... %8.4f

James K. Lowden wrote:
 

> Cousin Stanley,
>
> Indeed you now can.  
>
> I added a -p option, documented in the man page.
>
> You supply the column name & printf format string
> you want to use for it.  
>
> It works for numbers only: integers and floating point.  
>
> Strings continue to be formatted by tbl & troff.

  James ....

    Thanks for providing the  sqlrpt  program  
    and adding the  format  option.

    I very much appreciate your time and effort.
   
    However, I'm not sure I have installed the newer version
    correctly as I don't speak  Makefile  and couldn't manage
    the  make  step until lines 13, 15, and 19 from the Makefile
    were commented out ....

      e.g. lines with .....  <<<<  ======  >>>>  

    Using  make  then  make install  in this manner
    did provide a working  sqlrpt  executable
    that worked as you describe to format
    a  single  numeric column from an sql query ....

      $ sqlrpt .... -p "Value,%'8.2f" ....

    I haven't tried repeating  -p  options  yet
    for formatting multiple columns ....
 

--
Stanley C. Kitching
Human Being
Phoenix, Arizona


_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Reporting Solutions that work with SQLite / VB 2015?

James K. Lowden
On Mon, 03 Apr 2017 06:26:35 -0700
Cousin Stanley <[hidden email]> wrote:

>       e.g. lines with .....  <<<<  ======  >>>>  

My mistake, sorry.   A little git hiccup.  

You found the correct fix.  And the repository now holds a correct
version.  

--jkl
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Loading...