+ Post New Thread
Results 1 to 8 of 8
General Chat Thread, Creating a report in OpenOffice for PyKota in General; I'd like to make a pretty report in OpenOffice to shame staff that print ridiculous amounts and other reports to ...
  1. #1

    Ric_'s Avatar
    Join Date
    Jun 2005
    Location
    London
    Posts
    7,590
    Thank Post
    109
    Thanked 762 Times in 593 Posts
    Rep Power
    180

    Creating a report in OpenOffice for PyKota

    I'd like to make a pretty report in OpenOffice to shame staff that print ridiculous amounts and other reports to show other things.

    I think that I can figure out the report business and I have created a DSN to connect to the PyKota database. My problem is that I only want to look at staff so I need to create a clever query.

    I need to select only the rows where the username does not begin with a digit. How do I do this (either in Design view or SQL view)???

  2. #2

    Ric_'s Avatar
    Join Date
    Jun 2005
    Location
    London
    Posts
    7,590
    Thank Post
    109
    Thanked 762 Times in 593 Posts
    Rep Power
    180

    Re: Creating a report in OpenOffice for PyKota

    ^^ NUDGE!!! :P

  3. #3
    ChrisH's Avatar
    Join Date
    Jun 2005
    Location
    East Lancs
    Posts
    4,998
    Thank Post
    120
    Thanked 280 Times in 258 Posts
    Rep Power
    106

    Re: Creating a report in OpenOffice for PyKota

    Hmm something like

    Select * from usernames where username not like '%0'

    Assuming all the user names you dont want begin with a 0.

  4. #4

    Ric_'s Avatar
    Join Date
    Jun 2005
    Location
    London
    Posts
    7,590
    Thank Post
    109
    Thanked 762 Times in 593 Posts
    Rep Power
    180

    Re: Creating a report in OpenOffice for PyKota

    Quote Originally Posted by ChrisH
    Hmm something like

    Select * from usernames where username not like '%0'

    Assuming all the user names you dont want begin with a 0.
    Some start with a 6 :P

  5. #5

    Ric_'s Avatar
    Join Date
    Jun 2005
    Location
    London
    Posts
    7,590
    Thank Post
    109
    Thanked 762 Times in 593 Posts
    Rep Power
    180

    Re: Creating a report in OpenOffice for PyKota

    Code:
    SELECT "username", "balance" FROM "public"."users" WHERE ( ( "username" NOT LIKE '0%' AND "username" NOT LIKE '6%' ) ) ORDER BY "username" ASC
    That was what I wanted

  6. #6
    ChrisH's Avatar
    Join Date
    Jun 2005
    Location
    East Lancs
    Posts
    4,998
    Thank Post
    120
    Thanked 280 Times in 258 Posts
    Rep Power
    106

    Re: Creating a report in OpenOffice for PyKota

    I was close enough tbh

  7. #7

    Ric_'s Avatar
    Join Date
    Jun 2005
    Location
    London
    Posts
    7,590
    Thank Post
    109
    Thanked 762 Times in 593 Posts
    Rep Power
    180

    Re: Creating a report in OpenOffice for PyKota

    Quote Originally Posted by ChrisH
    I was close enough tbh
    Except the % was in the wrong place

  8. #8
    ChrisH's Avatar
    Join Date
    Jun 2005
    Location
    East Lancs
    Posts
    4,998
    Thank Post
    120
    Thanked 280 Times in 258 Posts
    Rep Power
    106

    Re: Creating a report in OpenOffice for PyKota

    Quote Originally Posted by Ric_
    Quote Originally Posted by ChrisH
    I was close enough tbh
    Except the % was in the wrong place
    Pfft details tbpfhomgkthanksbye

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 70
    Last Post: 13th November 2009, 01:51 PM
  2. OpenOffice 2.2 released
    By CyberNerd in forum Educational Software
    Replies: 7
    Last Post: 12th April 2007, 09:45 AM
  3. Pykota chat wanted
    By Ric_ in forum *nix
    Replies: 5
    Last Post: 8th March 2007, 10:06 AM
  4. PyKota v1.25 Released
    By Geoff in forum *nix
    Replies: 5
    Last Post: 28th January 2007, 06:00 PM
  5. OpenOffice 2.1 Released
    By CyberNerd in forum Educational Software
    Replies: 1
    Last Post: 13th December 2006, 11:28 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •