In 2008R2 the Indicator was added to the toolbox

Add this to your report

Select symbols with the tick for the Indicator type

Set the value to NULL for no display, 0...

Does your procedure output the sequence in the dataset or via an OUTPUT parameter?

As Luis pointed out it rather depends on the front end software that is using ODBC.

SQLRNNR (2/13/2014)

David Burrows (2/13/2014)

It is to move the...

It is to move the minus sign to...

You could add two images to the report (one a ticked box the other unticked) and use IIF in an expression to decide which image to show.

Are you using 2008...

+1 🙂

How about 2 passes, first to sort out address similarities and then second to dedupe including Organisation

You need to go back to Manage the report and choose Data Sources.

Provide the necessary credentials to run the report, (ie it cannot be set to Credentials supplied by the...

;WITH result (Master_ID,MatchRuleID) AS (

SELECTmr.Master_ID,MIN(r.MatchRuleID)

FROMMatchRules r

JOIN MatchResults mr

ON mr.Name_Score <= ISNULL(r.NameScore, 5)

AND mr.OrgName_Score <= ISNULL(r.CompanyScore, 5)

AND mr.Premise_Score <= ISNULL(r.PremiseScore, 5)

AND mr.Address_Score >= ISNULL(r.AddressScore, 0)

AND mr.Postcode_Score <= ISNULL(r.PostcodeScore, 5)...

OK my bad, not actually on the server itself.

Use browser to connect to reporting services, ie http://servername/Reports/Pages/Folder.aspx

Select folder containing report

Open Menu (click on down arrow in yellow box)

Click on Manage...

Why only one row from Milk Products but two rows from Dhal Products?

Where is the sales value from?

A CTE with ROW_NUMBER() looks the likely answer.

Change the report language to en-GB

or

Change the expression to

String.Format("Report Generation Date: {0:dd/MM/yyyy}",Today)

Add a subscription to the report on the Reporting Services server

Using the following table definition

CREATE TABLE myTable99 (

F1 char(7),

F2 char(60),

F3 char(2),

F4 char(4),

F5 char(2),

F6 char(24),

F7 char(1),

F8 char(12),

F9 char(12),

F10 char(12),

F11 char(12),

F12 char(12),

F13 char(14),

F14 char(7)

)

using this format file

10.0

14

1 ...

When you open a csv file in Excel, Excel loads it as a sheet in...