Pass Guid for SSRS 2008 URL Access Parameter

I'm trying to use URL access to pull some reports from SQL Server 2008 Reporting Services. One of the parameters I need to pass is Guid. When I just insert guid in url like

&LoggerID=CD4869DC-68B8-4513-B3C6-0E6DD9F74380

I get the error: The value or default value for the LoggerID report parameter is not a valid value. (RsInvalidReportParameter)

I tried single quotes and brackets and braces. What am I missing?

+3
source share
5 answers

, " ", URL-. , . GUID, , .

: 2008 - .

+2

, Guid.

SSRS , . , " " , url, , .

, url

&entityIdentifier=75745B11-09B8-4BF6-98EF-F3E8A2ACEC05

,

&entityIdentifier=75745B11-09B8-4BF6-98EF-F3E8A2ACEC05
+3

.

, "LoggerID", URL "guid" . ?

, ( ) URL SSRS . "loggerid =..." URL-, "LoggerID", ( , , , ).

, "String" . SSRS 2005 Guid. ( ), .

+1

, GUID- URL-. , uniqueidentifier varchar (36) Dataset, . , , , GUID URL- .

:

SELECT CAST(MyGuidColumn AS varchar(36)) AS MyGuidColumn, MyLabelColumn
FROM  MyTable
0

, - Guid URL- , .

, Guid .

0

Source: https://habr.com/ru/post/1715129/


All Articles