Results 1 to 10 of 10

Thread: Eporting reports to be viewed online

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Sep 2015
    Posts
    225

    Eporting reports to be viewed online

    I have an old application which stores patients medical results in a MDB file. I want to upload these results online so patients can use their IDs and a given password to view their results online.

    I thought the best way is to have a MySQL database where I upload all the needed data to it and use PHP to do the following :
    1. Ask for user name and password.
    2. Display all visits dates for the patient in a combo box or whatever.
    3. Show results using HTML formatting.

    I am starting my Web Application Development and I started the following thread :

    http://www.vbforums.com/showthread.p...eb-development

    I do appreciate if anyone can give his 2 cents or anyone who know of a RAD tool to help me achieve what I want as fast as possible till I master what is needed to do it all by myself.

    Thank you very.

  2. #2
    Addicted Member Goggy's Avatar
    Join Date
    Oct 2017
    Posts
    196

    Re: Eporting reports to be viewed online

    If you need PHP help, this is not the place to ask it , in my opinion
    Utterly useless, but always willing to help

    As a finishing touch god created the dutch

  3. #3
    PowerPoster ChrisE's Avatar
    Join Date
    Jun 2017
    Location
    Frankfurt
    Posts
    3,040

    Re: Eporting reports to be viewed online

    Hi Lab,

    use the Datareport and convert it to PDF with PDF-Creator. I think it would be better just
    to upload a Report rather the a whole DB-System.

    but that's up to you

    regards
    Chris
    to hunt a species to extinction is not logical !
    since 2010 the number of Tigers are rising again in 2016 - 3900 were counted. with Baby Callas it's 3901, my wife and I had 2-3 months the privilege of raising a Baby Tiger.

  4. #4

    Thread Starter
    Addicted Member
    Join Date
    Sep 2015
    Posts
    225

    Re: Eporting reports to be viewed online

    Quote Originally Posted by Goggy View Post
    If you need PHP help, this is not the place to ask it , in my opinion
    Thanks!

  5. #5

    Thread Starter
    Addicted Member
    Join Date
    Sep 2015
    Posts
    225

    Re: Eporting reports to be viewed online

    Quote Originally Posted by ChrisE View Post
    Hi Lab,

    use the Datareport and convert it to PDF with PDF-Creator. I think it would be better just
    to upload a Report rather the a whole DB-System.

    but that's up to you

    regards
    Chris
    Thanks Chris but:
    How is that will work for users to log in and see their own specific results?
    Do you suggest storing PDFs on server in a specific way?
    Last edited by labmany; Dec 20th, 2017 at 08:25 AM.

  6. #6
    PowerPoster ChrisE's Avatar
    Join Date
    Jun 2017
    Location
    Frankfurt
    Posts
    3,040

    Re: Eporting reports to be viewed online

    Hi ,
    my wife's a Vet, she recives an Email with a Link to view a Report(Bloodresults etc..).
    She could also request to recive the Report per Email from the Lab., but she didn't want that.

    You can also print out the DataReport in HTML if you want, rather than PDF.
    If you need a sample how to create a Datareport, then let me know.

    regards
    Chris
    to hunt a species to extinction is not logical !
    since 2010 the number of Tigers are rising again in 2016 - 3900 were counted. with Baby Callas it's 3901, my wife and I had 2-3 months the privilege of raising a Baby Tiger.

  7. #7
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,710

    Re: Eporting reports to be viewed online

    Thread moved to Web Dev Forum from Classic VB6 Forum
    VB/Office Guru™ (AKA: Gangsta Yoda®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    Reps & Rating PostsVS.NET on Vista Multiple .NET Framework Versions Office Primary Interop AssembliesVB/Office Guru™ Word SpellChecker™.NETVB/Office Guru™ Word SpellChecker™ VB6VB.NET Attributes Ex.Outlook Global Address ListAPI Viewer utility.NET API Viewer Utility
    System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6

  8. #8

    Thread Starter
    Addicted Member
    Join Date
    Sep 2015
    Posts
    225

    Re: Eporting reports to be viewed online

    Quote Originally Posted by ChrisE View Post
    Hi ,
    my wife's a Vet, she recives an Email with a Link to view a Report(Bloodresults etc..).
    She could also request to recive the Report per Email from the Lab., but she didn't want that.

    You can also print out the DataReport in HTML if you want, rather than PDF.
    If you need a sample how to create a Datareport, then let me know.

    regards
    Chris
    Many thanks Chris for your help.
    The problem is many of my software users do have websites and they need to offer a service to their patients to get their results (present and history results) online anytime they want!

  9. #9
    Freelancer akhileshbc's Avatar
    Join Date
    Jun 2008
    Location
    Trivandrum, Kerala, India
    Posts
    7,652

    Re: Eporting reports to be viewed online

    Quote Originally Posted by labmany View Post
    I have an old application which stores patients medical results in a MDB file. I want to upload these results online so patients can use their IDs and a given password to view their results online.

    I thought the best way is to have a MySQL database where I upload all the needed data to it and use PHP to do the following :
    1. Ask for user name and password.
    2. Display all visits dates for the patient in a combo box or whatever.
    3. Show results using HTML formatting.

    I am starting my Web Application Development and I started the following thread :

    http://www.vbforums.com/showthread.p...eb-development

    I do appreciate if anyone can give his 2 cents or anyone who know of a RAD tool to help me achieve what I want as fast as possible till I master what is needed to do it all by myself.

    Thank you very.
    You are in right path.

    For converting the data from MDB file to MySQL, have a look at the answers listed here: https://stackoverflow.com/questions/...plain-sql-file

    Use PHP or any other serverside language of your choice, and do the coding to validate login, fetch data from the database, etc.

    There are a ton of tutorials out there which will aid you. And if you encounter any issues, we might be able to throw some ideas. But be specific when you ask questions.


    If my post was helpful to you, then express your gratitude using Rate this Post.
    And if your problem is SOLVED, then please Mark the Thread as RESOLVED (see it in action - video)
    My system: AMD FX 6100, Gigabyte Motherboard, 8 GB Crossair Vengance, Cooler Master 450W Thunder PSU, 1.4 TB HDD, 18.5" TFT(Wide), Antec V1 Cabinet

    Social Group: VBForums - Developers from India


    Skills: PHP, MySQL, jQuery, VB.Net, Photoshop, CodeIgniter, Bootstrap,...

  10. #10

    Thread Starter
    Addicted Member
    Join Date
    Sep 2015
    Posts
    225

    Re: Eporting reports to be viewed online

    Quote Originally Posted by akhileshbc View Post
    You are in right path.

    For converting the data from MDB file to MySQL, have a look at the answers listed here: https://stackoverflow.com/questions/...plain-sql-file

    Use PHP or any other serverside language of your choice, and do the coding to validate login, fetch data from the database, etc.

    There are a ton of tutorials out there which will aid you. And if you encounter any issues, we might be able to throw some ideas. But be specific when you ask questions.

    Thank you very much akhileshbc, I will do just that

Posting Permissions

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



Click Here to Expand Forum to Full Width