Unattended Server Reports

Posted by: cchristopher on 22 June 2021, 7:41 am EST

  • Posted 22 June 2021, 7:41 am EST

    I’m looking to upgrade from our current solution to a more robust server solution. I need to be able to create a host of custom report templates that would be run every 1 minute of each day from 6:00 AM through 6:00 PM and every 15 minutes outside of those hours.

    I work at a laboratory and this would mainly be used for creating PDF reports of patient lab results that would be saved to a network location with a custom name based on the data in the report. So a filename could possibly be something similar to {Test ID}{Patient FirstName}{Patient Last Name}_{Test Name}.pdf. Some report templates would be very simple but some are going to be extremely complex with hoards of business logic embedded inside of them.

    By that I mean if the test being reported includes 19 toxic chemicals in your blood and 10 were at high levels. We would have custom business logic to display a warning for each of the 10 that were high. We might also include and additional warning because 2 specific chemicals were high and another one was low. Basically these are going to be much more complex than just showing a list of people that were present for a meeting.

    We currently add each patient’s test ID to a queuing table when it needs to have the PDF created. I would need the report server to be able to call a query/view/stored proc/etc against our queuing table in the DB. The resultset returned would be a list of patient test IDs. This list of IDs would need to be run against that custom report template, which would create 1 PDF for each patient test ID in the resultset, not 1 PDF with all of the results on them.

  • Posted 26 February 2023, 7:19 pm EST

    The Mega Pizzaplex is the setting for Freddy Fazbear’s fnaf security breach, a survival horror game. You will play the part of Gregory, a boy who has been stuck in his house all night. When the surprisingly strong Pizzaplex lockout goes into effect, you have to stay alive and look for a way out. Now, let’s take a look at how to play Security Breach.

  • Posted 10 March 2023, 4:22 pm EST

    Hey. Hi my friends. I want to tell you about one music service https://volumo.com/ , which I am sure will become very popular in the near future, as it meets all my expectations. It’s good for people who don’t have money because the music is free. If you don’t believe in my words, just follow this link and check out this service.

  • Posted 22 March 2023, 2:57 pm EST

    Another fast and enjoyable method to spend the time each day is to play football legends with your friends, pretending to be the player you like and having fun while doing so.

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels