oh happy day, I figured it out! My select statement all along has been;

DBType = d.value('(rd:DBType)[1]','varchar(max)'),

when it should have been;

DbType = d.value('(rd:DbType)[1]','varchar(max)'),

I now get 'String' for all but @Companies which...

Come on, a .txt file isn't allowed? sigh ...

Here is the shared data set;

<?xml version="1.0" encoding="utf-8"?>
<SharedDataSet xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2010/01/shareddatasetdefinition">
  <Description />
  <DataSet Name="dsNaturalAccounts">
   ...

See attachments. A different Shared Data Set with more parameters; I made sure to set some of the values differently so some are true, some are false. Added a default...

yes, I changed x.value to d.value; I'll just have to live with it. thank you for your help Brian.

Brian,

Just tried your @xml variable/cte, and yes, it works, but ...

I have reworked my script, which I use to print out information about many different types of items in ReportServer.dbo.Catalog,...

I guess you can't attach .xml files.  Trying .txt (same content). If this works, you can save it with a .xml extension, then open it with a browser to see...

Brian,

I am running on an earlier server version;

Microsoft SQL Server 2008 R2 (SP3-GDR) (KB4057113) - 10.50.6560.0 (X64) Dec 28 2017 15:03:48 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows...

Brian,

I should have said that I already tried that, and I get NULL for DBType and IsMultiValued;

DataSetParameterName ReadOnly Nullable OmitFromQuery DBType IsMultiValued

@Year false false false NULL NULL

@Months false false false...

No, that doesn't work. Maybe this is a bug. The remaining levels, from level 1 on down, are showing the correct icon, so it's level 0 that is backwards.

thanks

I did not know that there were different versions of the "apparently" same font.

thank you for your help.

Fonts now installed on the server, and were always on my laptop. PDF export now looks good, but Excel still doesn't recognize either font. Not sure if that is the...

I wonder if the plug-ins (maybe the wrong term) used for the various available export formats, are what is to blame. It is odd that Wingdings printed properly to PDF,...

Yes, the first image is the report rendered on the RS server, so that proves the fonts are installed there. The issue is exporting to PDF and Excel.

Update, if anyone is interested.  I could not get SSRS – Passing multiple value parameters in data driven subscriptions to work for my reports; cards on...

I'd seen the first article earlier this week; while it might alleviate some of the issues I've had, the lack of flexibility remains - until/unless MS makes the subscription process...