Questions tagged [ms-reports]

18 questions
2
votes
0 answers

SSRS Count indicators active

I am writing a report where I have an indicator determined if a person is under a percentage for a certain category of orders. If the person is below threshold, then a big X is displayed by the percentage. Outside of the group I am looking to put a…
centuryfall
  • 400
  • 2
  • 5
  • 13
2
votes
1 answer

SSRS: Passing/Setting parameter to Dataset using Expression

I am using Microsoft SQL Server Report Builder 3.0. I have created a Stored Procedure (stored_procedure1) in the database which has a Parameter (parameter1). Here, stored_procedure1 returns result1. Then, I used stored_procedure1 to create a Dataset…
1
vote
1 answer

Microsoft Reports LocalReport in Azure Function: ReportProcessingException

I created a basic Azure Function (.NET), I have a basic Project which generates a LocalReport (WinForms based). This works within a ASP.NET MVC Application and within Unit Tests, but not in Azure Function. Not quite exactly as this, but you get the…
thmshd
  • 5,729
  • 3
  • 39
  • 67
1
vote
1 answer

How to load data page by page in MS Report Viewer?

How do I load data page by page from the database into the MS Report viewer? now I'm using following code: private void LoadData() { reportDataSource1 = new Microsoft.Reporting.WinForms.ReportDataSource(); merchent =…
Suravi
  • 301
  • 1
  • 7
  • 21
0
votes
0 answers

how do I choose cell what I want? MS Report builder

I want to select only B2 and B6. But now we can just select every cell and calculate it. Is there any way to choose only B2 and B6 to calculate? enter image description here
0
votes
0 answers

How to create a setup with crystal reports, or ms-reports in visual studio for desktop applications

I have created a desktop application in visual studio and sqlserver and when I created a setup, it is working on the development machine but when the setup is installed in the client machine together with crystal reports runtime engine, the…
Seru
  • 29
  • 7
0
votes
1 answer

SSRS alternating 1000 separators with Number Format

I am creating a report in Microsoft Report builder, which to my knowledge uses MS Visual Basic in its expressions, and I am currently stuck with a weird number formatting problem: For some unknown reason, the requirement is to format numbers…
0
votes
1 answer

How to Count per Date in Microsoft Report Builder

I have created a query using MSSQL and used that to create a report Using Report Builder. I have the Dates in column which gives count as 5 Date and Time ------------- 2/11/2021 2/11/2021 2/11/2021 2/11/2021 2/12/2021 --------- 5 I have Used Count…
0
votes
1 answer

What steps in order to implement MS Access Report in such a way that different query defintions take different arguments?

On my work desktop, I have -Microsoft Office Professional Plus 2013 Access I've been tasked to create a MS Access application with an Access DB. I have an MS Access Report within my application The MS Access Report's Record Source is associated…
crazyTech
  • 1,379
  • 3
  • 32
  • 67
0
votes
1 answer

MS Access Link Criteria from Two Sources

I have a report that is opened and a filtered to a specific record by linking to piece of data. (Lot #) Private Sub ServiceRequest_Click() DoCmd.RunCommand acCmdSaveRecord Dim stDocName As String Dim stLinkCriteria As String stDocName =…
NewbieVBA
  • 47
  • 2
  • 7
0
votes
1 answer

MSReport is showing 1 day behind for expiry date, compared to CRM?

Currently when I look at the expiry date section for insurance on my MSReport Builder it is 03/04/2017, but the expiry date section for my insurance in CRM is 04/04/2017 which is the correct and right, however in the report it is 1 day behind,…
user6834478
0
votes
1 answer

How to pass 'Select All' parameter in SSRS report url?

I've been stuck with this problems for 2 days now and I don't know how to corner it. Basicly, I'm building list of report URL's with provided parameters in URL so I can run them without selecting each checkbox. I've found the way how to select most…
0
votes
2 answers

In MS Reporting Services, how do you set a dynamic dataset, based on a selectable Report database parameter

In MS Reporting Services, how do you set a dynamic dataset, based on a selectable Report database parameter? For example, I have one dataset, Insurers, that has a text SQL Query, instead of a stored procedure, and I need to use the database that is…
Bryan
  • 3,629
  • 2
  • 28
  • 27
0
votes
2 answers

Output while rendered in PDF renders in the set Paper Size but not in Word

I use the Microsoft.WebForms.ReportViewer version 10.0.0 to render reports the output rendered is a word document . The rdlc file is set with the PaperSize Orientation with an orientation set to LandScape and a PaperSize to A4 When the output is…
user581157
  • 1,327
  • 4
  • 26
  • 64
0
votes
2 answers

Find the original report of a linked report in SSRS

How to find the original report of a linked report in SSRS. Could anyone let me know how to find the main report of a linked report in the report manager.
1
2