Mimic excel report in SSRS using VS 2019
Hi All, I have a user who wants the SSRS report to look exactly the same as the current excel sheet. I have done my best, but I am stuck at the tail end. Hope I get some advice. The first screen shot is my SSRS Report using Matrix table (mimicking excel ). Until now I am good , now I need to add a calculated field Total=(casecount+casecount1), which should look like the second screen shot. Here the "Total" needs to be next 2024, Facility should be empty , the rest will be the same. I tried adding total to row group, column group and many more things nothing worked. Any advice? Thanks
SSRS Report Server View Hidden Shared Data Source Folder
I would like to know if I could view the data source or connection string for those reports. Specifically, I am looking for information such as which databases and tables these reports are generated from, or the connection string itself. I can go to Report Manager and navigate to the report I want, then go to the Manage section. However, all I see is this: Is there another place where I can view or amend this data source/connection string? Could someone advise me on this, please? Thanks
general design of a multi invoice report
Hi, i have a requirement to produce the report you see below in ssrs. Its basically 1 to n invoices based on a range (from and to) of invoice #'s that will be input as 2 parameters. The stuff hilighted in yellow is static info. everything you see from line 1 to line 23 should be repeated on each page for the same invoice. And a new invoice should start on a new page. Except for page number, all non heading info on lines 1 thru 20 represents header info that for a given invoice will be REPEATED on every row of the dataset. See the 2nd image for a rough draft of the dataset layout. Header info shows once on every page. Am i looking at a matrix with a report perhaps in the 1st cell? How would i ensure that each invoice starts on a new page? Is there a link to a "how to" to a similar requirement?
