Results 1 to 10 of 10
  1. #1
    Join Date
    Mar 2014
    Posts
    44

    Unanswered: Recording daily report

    HI all,

    I am writing program to record daily progress in our fabrication project. I have initial data and the record changes everyday.

    Can you please give me some suggestion on how to do the method for that kind of program so I can monitor the daily progress and the daily data changes according to the date.

    How do I query those differences as well in PL/SQL.

    some example is like this,
    Attached Thumbnails Attached Thumbnails dbsample.jpg  

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >How do I query those differences as well in PL/SQL.
    PL/SQL can not access data which resides inside any RDBMS.
    only plain SQL can access or manipulate data in the database.

    What should the results look like.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Mar 2014
    Posts
    44
    Quote Originally Posted by anacedent View Post
    >How do I query those differences as well in PL/SQL.
    PL/SQL can not access data which resides inside any RDBMS.
    only plain SQL can access or manipulate data in the database.

    What should the results look like.
    The result is going to be like only the data changes between those two dates, for example

    on 3/20/2014 the data

    ID Cutting Welding Painting
    ME20 1 2 5
    ME30 1 2 5
    ME40 1 2 5
    ME50 2 2 5

    and on 3/21/2014 the data changes will be like

    ID Cutting Welding Painting
    ME20 1 5 5
    ME30 4 2 5
    ME40 4 5 7
    ME50 2 2 7

    I want to show the difference on every cell and present them in some kind of percentage so i can make the analysis

    please advise me

  4. #4
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool

    Quote Originally Posted by chrishutagalung View Post
    . . . E t c . . .
    I want to show the difference on every cell and present them in some kind of percentage so i can make the analysis

    please advise me
    My advice is you put on your "Analyst" hat and do some requirements gathering with the user (client) and find out what they really want and thus avoid "inventing" a report that they have not requested.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  5. #5
    Join Date
    Mar 2014
    Posts
    44
    Quote Originally Posted by LKBrwn_DBA View Post
    My advice is you put on your "Analyst" hat and do some requirements gathering with the user (client) and find out what they really want and thus avoid "inventing" a report that they have not requested.
    Thanks,

    but this is exactly what the client wants.

    Thanks

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >but this is exactly what the client wants.

    if you say so.
    Since you have never posted any actual desired results in this thread.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  7. #7
    Join Date
    Mar 2014
    Posts
    44
    Quote Originally Posted by anacedent View Post
    >but this is exactly what the client wants.

    if you say so.
    Since you have never posted any actual desired results in this thread.
    yes and I am sorry for that. do you have any idea on how to implement this ?

  8. #8
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >do you have any idea on how to implement this ?
    THIS?
    You have never posted any actual desired results here.
    I am not a mind reader.
    I have no idea what "this" looks like.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  9. #9
    Join Date
    Mar 2014
    Posts
    44
    Quote Originally Posted by anacedent View Post
    >do you have any idea on how to implement this ?
    THIS?
    You have never posted any actual desired results here.
    I am not a mind reader.
    I have no idea what "this" looks like.
    OK,
    So lets the the user wants to query the data changes between today and yesterday.
    lets say we want to see the data changes with the ME50. Lets say the painting completed progress increase from 2 pieces(yesterday) to 5 pieces(today). (we have total 7 pieces to be done).

    So the client wants to see that in the report there are 3 finished as for today and there are 2 left to be done.

    So i need some kind of algorithm or function ( I guess) to do this kind of operation in every numeric cells.

  10. #10
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    if you do not know how to produce the desired results manually (on paper using a pencil),
    then you have no reason to even attempt to "automate" the same (but missing) calculation.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Tags for this Thread

Posting Permissions

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