Data Entry Forms in SSRS 2019

WD2020 21 Reputation points
2020-12-06T17:27:17.993+00:00

I am working to develop few reports in SSRS 2019 and I use SQL SERVER 2019. I have a new request to create a data entry form and I am curious will it be possible to create one using SSRS/Report Builder ? Can I use lists to develop this ? I am attaching a sample template how a form should like. The intension is here, the end the user fills the data in the form and should have the option to save the data and also print it.

If SSRS cannot be used in this case, can power BI tool be more effective for this ? Thanks

45531-image.png

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,782 questions
0 comments No comments
{count} votes

Accepted answer
  1. Joyzhao-MSFT 15,561 Reputation points
    2020-12-07T03:40:24.063+00:00

    Hi @WD2020
    The reports created in SSRS are not what you see is what you get(Table or Martrix). For what you said to fill in the data and print the report, you can edit it by exporting the report in the corresponding format in the report manager.
    PowerBI has more bright spots than SSRS. Power BI has expanded its management in the fields of information network, data conversion, data preparation, information presentation, announcements and dashboards. It can utilize and present intuitive PBIX and scientific XLSX reports that SSRS cannot achieve. You can try to report your issue on the PowerBI forum.
    Regards,
    Joy


    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
    What can I do if my transaction log is full?--- Hot issues November
    How to convert Profiler trace into a SQL Server table -- Hot issues November

    1 person found this answer helpful.
    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. WD2020 21 Reputation points
    2020-12-08T15:38:53.247+00:00

    Thank your response.