How to generate manual report

Pavel yannara Mirochnitchenko 11,586 Reputation points
2021-03-09T14:24:42.04+00:00

We have a need to create a customer report to be mostly friendly for HR and take it to the Reporting Server web site. I remember doing this 5 years ago by executing query, looking at specific log file where the query is translated to SQL language, copying it to the Report Builder and publishing new report item behind a custom folder. I did that by following some blog article but now I can't find it anymore.

What would be the best method to archive this today? I have 0 experience in PowerBI and 0,1 experience in SQL Report Builder :D

Microsoft Configuration Manager
0 comments No comments
{count} votes

4 additional answers

Sort by: Most helpful
  1. Garth Jones 2,071 Reputation points
    2021-03-09T15:39:46.76+00:00

    You you are looking for a step by step with end of chapter examples. Here is the book that I wrote on the subject. https://www.informit.com/store/system-center-configuration-manager-reporting-unleashed-9780134466811

    Even though it is writing for MECM you can use all of the idea for any database.

    2 people found this answer helpful.
    0 comments No comments

  2. Youssef Saad 3,401 Reputation points
    2021-03-09T15:06:22.837+00:00

    Hi @Pavel yannara Mirochnitchenko ,

    Have you seen the following blog?

    Regards,


    Youssef Saad | Blog: https://youssef-saad.blogspot.com
    Please remember to ** “Accept answer” ** or upvote for useful answers, thank you!

    1 person found this answer helpful.
    0 comments No comments

  3. Garth Jones 2,071 Reputation points
    2021-03-09T15:40:57.07+00:00

    Also I should way that my blog has lots of tips and tricks for reporting. https://www.enhansoft.com/author/garth/

    0 comments No comments

  4. Pavel yannara Mirochnitchenko 11,586 Reputation points
    2022-12-05T15:48:22.023+00:00

    @Sandra Aldana why you edit this after a year? This pop-ups unnessarry then on the top listing now.