How to print or export records from a database using an ASP.NET razor-pages app

Question

0.00/5 (No votes)

See more:

I’m created an ASP.Net Razor-Pages  application that allows users to enter data related to a service call they completed.  A supervisor can logon and have access to calls completed by members of his/her team.  The goal at this time is to, 1) Print the records for the current week, or 2) Export the records for the current week in an Excel or PDF  format.  Each record has eight columns, there will be only a few hundred records.

Can either of these options be done using Visual Studio 2017 only?  If so, suggestion on how to print or export the records will be appreciated.  If additional tools are required, what tools should I consider using?

What I have tried:

During the past week I’ve spent hours trying to find answers to these questions on-line, but I have not been able to find a definitive answer with suggestions (steps) on how to print or export the records from the database using ASP.Net Razor-Pages.  I get the impression that Razor-Pages is still such a new platform that maybe this can’t or hasn’t been done yet.  I am probably looking in the wrong sites or asking the question in the wrong way

Posted 30-Jul-18 13:37pm

Member 8668966

Updated 31-Jul-18 6:14am

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

MadMyche · Answer 1 · 2018-07-31T06:15:00

Simple answer is yes; but is never that simple.

You really should flowchart what the goals are at the high level and then detailing each of them items at the low level. I will do a simple skeleton of this, with the numerics being the high level needs and the alphas being the low level questions you will need to figure out along the way.

1. Data Entry
1A: How will this be stored? SQL, Excel, of some file?

2. Data Retrieval
2A: Dependent upon how data is stored.

3. Data Presentation
3A: Report Preview webpage
3B: Export Methods
3B#1 Export to Excel
3B#2 SSRS Report

You will notice that I did not include PDF as an Export Method. That is because a PDF is just a container to place an already formatted document (~report) into.

And then again.... if you have some Excel hotshot that can generate reports within Excel from another page in the spreadsheet, you could open the Excel file and add the data directly onto that page, and the reports would be atomic(real time)