SSRS Hyperlink dual parameters errors

up vote
0
down vote

favorite

I am trying to pass a hyperlink in SSRS to open a new SSRS report (in pdf) from a text box. It is currently set up and works passing a single parameter :

="http://servername/ReportServer_REPORTS16/Pages/ReportViewer.aspx?%2fdummy%2fDocuments%2fCertificate+of+Insurance+Issued&rs:Command=Render&PolicyNo="
& Parameters!PolicyNo.Value &"&rs:Format=PDF"

However when I add in the second parameter :

="http://servername/ReportServer_REPORTS16/Pages/ReportViewer.aspx?%2fdummy%2fDocuments%2fCertificate+of+Insurance+Issued&rs:Command=Render&PolicyNo="
& Parameters!PolicyNo.Value &"&
Entitled="&Parameters!Entitled.Value &"&rs:Format=PDF"

I get an error message :

The ActionInfo.Action.Hyperlink expression for the text box
‘Textbox48’ contains an error: [BC30277] Type character '&' does not
match declared data type 'Object'.

I've gone through every similar error I've found on google but cant work out where im going wrong.

asked 2 days ago

XDSA5286

416

It might be that there is a space inside your string between your ampersand and Entitled - &"& Entitled="& should be & "&Entitled="&. It's trying to resolve the link up to the space.
– Hannover Fist
yesterday

add a comment |

up vote
0
down vote

favorite

I am trying to pass a hyperlink in SSRS to open a new SSRS report (in pdf) from a text box. It is currently set up and works passing a single parameter :

="http://servername/ReportServer_REPORTS16/Pages/ReportViewer.aspx?%2fdummy%2fDocuments%2fCertificate+of+Insurance+Issued&rs:Command=Render&PolicyNo="
& Parameters!PolicyNo.Value &"&rs:Format=PDF"

However when I add in the second parameter :

="http://servername/ReportServer_REPORTS16/Pages/ReportViewer.aspx?%2fdummy%2fDocuments%2fCertificate+of+Insurance+Issued&rs:Command=Render&PolicyNo="
& Parameters!PolicyNo.Value &"&
Entitled="&Parameters!Entitled.Value &"&rs:Format=PDF"

I get an error message :

The ActionInfo.Action.Hyperlink expression for the text box
‘Textbox48’ contains an error: [BC30277] Type character '&' does not
match declared data type 'Object'.

I've gone through every similar error I've found on google but cant work out where im going wrong.

asked 2 days ago

XDSA5286

416

It might be that there is a space inside your string between your ampersand and Entitled - &"& Entitled="& should be & "&Entitled="&. It's trying to resolve the link up to the space.
– Hannover Fist
yesterday

add a comment |

up vote
0
down vote

favorite

I am trying to pass a hyperlink in SSRS to open a new SSRS report (in pdf) from a text box. It is currently set up and works passing a single parameter :

="http://servername/ReportServer_REPORTS16/Pages/ReportViewer.aspx?%2fdummy%2fDocuments%2fCertificate+of+Insurance+Issued&rs:Command=Render&PolicyNo="
& Parameters!PolicyNo.Value &"&rs:Format=PDF"

However when I add in the second parameter :

="http://servername/ReportServer_REPORTS16/Pages/ReportViewer.aspx?%2fdummy%2fDocuments%2fCertificate+of+Insurance+Issued&rs:Command=Render&PolicyNo="
& Parameters!PolicyNo.Value &"&
Entitled="&Parameters!Entitled.Value &"&rs:Format=PDF"

I get an error message :

The ActionInfo.Action.Hyperlink expression for the text box
‘Textbox48’ contains an error: [BC30277] Type character '&' does not
match declared data type 'Object'.

I've gone through every similar error I've found on google but cant work out where im going wrong.

asked 2 days ago

XDSA5286

416

I am trying to pass a hyperlink in SSRS to open a new SSRS report (in pdf) from a text box. It is currently set up and works passing a single parameter :

="http://servername/ReportServer_REPORTS16/Pages/ReportViewer.aspx?%2fdummy%2fDocuments%2fCertificate+of+Insurance+Issued&rs:Command=Render&PolicyNo="
& Parameters!PolicyNo.Value &"&rs:Format=PDF"

However when I add in the second parameter :

="http://servername/ReportServer_REPORTS16/Pages/ReportViewer.aspx?%2fdummy%2fDocuments%2fCertificate+of+Insurance+Issued&rs:Command=Render&PolicyNo="
& Parameters!PolicyNo.Value &"&
Entitled="&Parameters!Entitled.Value &"&rs:Format=PDF"

I get an error message :

The ActionInfo.Action.Hyperlink expression for the text box
‘Textbox48’ contains an error: [BC30277] Type character '&' does not
match declared data type 'Object'.

I've gone through every similar error I've found on google but cant work out where im going wrong.

reporting-services ssrs-2012

asked 2 days ago

XDSA5286

416

asked 2 days ago

XDSA5286

416

asked 2 days ago

XDSA5286

416

asked 2 days ago

XDSA5286

416

asked 2 days ago

XDSA5286

416

It might be that there is a space inside your string between your ampersand and Entitled - &"& Entitled="& should be & "&Entitled="&. It's trying to resolve the link up to the space.
– Hannover Fist
yesterday

add a comment |

It might be that there is a space inside your string between your ampersand and Entitled - &"& Entitled="& should be & "&Entitled="&. It's trying to resolve the link up to the space.
– Hannover Fist
yesterday

It might be that there is a space inside your string between your ampersand and Entitled - &"& Entitled="& should be & "&Entitled="&. It's trying to resolve the link up to the space.
– Hannover Fist
yesterday

add a comment |

1 Answer
1

active

oldest

votes

up vote
0
down vote

You need to convert all your values to strings then use the + operator....

Here'a an exmaple from one of my reports that does the same thing.

=IIF(Fields!PackSizeDesc.Value = Nothing, Nothing, 

"http://MyServername/ReportServer?/Brand+Value/_sub+SKU+Price+Details" 

 + "&CountryID=" + cStr(Fields!CountryID.Value)

 + "&CategoryID=" + cStr(Fields!CategoryID.Value)

 + "&RecordedPeriodID=" + cStr(Parameters!PeriodID.Value)

 + "&TMB=" + cStr(Fields!TrademarkBrandID.Value)

 + "&PriceStage=" + cStr(IIF(Fields!IsActualprice.Value = 1, 10, 11))

 + "&pm=" + cStr(Fields!PackMaterialID.Value)

 + "&pt=" + cStr(Fields!PackTypeID.Value)

 + "&ps=" + cStr(Fields!PackSizeID.Value)

 + "&psu=" + cStr(Fields!PackSizeUnitID.Value)

 + "&upp=" + cStr(Fields!UnitsPerPack.Value)

 + "&rc:Parameters=Collapsed")

Note: The first line just disables the link if there is now value in a particular column. This does not render to PDF but that's not part of your issue.

answered 2 days ago

Alan Schofield

5,68711019

add a comment |

Your Answer

StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});

}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53203530%2fssrs-hyperlink-dual-parameters-errors%23new-answer', 'question_page');
}
);

Post as a guest

Name

1 Answer
1

active

oldest

votes

1 Answer
1

active

oldest

votes

up vote
0
down vote

You need to convert all your values to strings then use the + operator....

Here'a an exmaple from one of my reports that does the same thing.

=IIF(Fields!PackSizeDesc.Value = Nothing, Nothing, 

"http://MyServername/ReportServer?/Brand+Value/_sub+SKU+Price+Details" 

 + "&CountryID=" + cStr(Fields!CountryID.Value)

 + "&CategoryID=" + cStr(Fields!CategoryID.Value)

 + "&RecordedPeriodID=" + cStr(Parameters!PeriodID.Value)

 + "&TMB=" + cStr(Fields!TrademarkBrandID.Value)

 + "&PriceStage=" + cStr(IIF(Fields!IsActualprice.Value = 1, 10, 11))

 + "&pm=" + cStr(Fields!PackMaterialID.Value)

 + "&pt=" + cStr(Fields!PackTypeID.Value)

 + "&ps=" + cStr(Fields!PackSizeID.Value)

 + "&psu=" + cStr(Fields!PackSizeUnitID.Value)

 + "&upp=" + cStr(Fields!UnitsPerPack.Value)

 + "&rc:Parameters=Collapsed")

Note: The first line just disables the link if there is now value in a particular column. This does not render to PDF but that's not part of your issue.

answered 2 days ago

Alan Schofield

5,68711019

add a comment |

up vote
0
down vote

You need to convert all your values to strings then use the + operator....

Here'a an exmaple from one of my reports that does the same thing.

=IIF(Fields!PackSizeDesc.Value = Nothing, Nothing, 

"http://MyServername/ReportServer?/Brand+Value/_sub+SKU+Price+Details" 

 + "&CountryID=" + cStr(Fields!CountryID.Value)

 + "&CategoryID=" + cStr(Fields!CategoryID.Value)

 + "&RecordedPeriodID=" + cStr(Parameters!PeriodID.Value)

 + "&TMB=" + cStr(Fields!TrademarkBrandID.Value)

 + "&PriceStage=" + cStr(IIF(Fields!IsActualprice.Value = 1, 10, 11))

 + "&pm=" + cStr(Fields!PackMaterialID.Value)

 + "&pt=" + cStr(Fields!PackTypeID.Value)

 + "&ps=" + cStr(Fields!PackSizeID.Value)

 + "&psu=" + cStr(Fields!PackSizeUnitID.Value)

 + "&upp=" + cStr(Fields!UnitsPerPack.Value)

 + "&rc:Parameters=Collapsed")

Note: The first line just disables the link if there is now value in a particular column. This does not render to PDF but that's not part of your issue.

answered 2 days ago

Alan Schofield

5,68711019

add a comment |

up vote
0
down vote

You need to convert all your values to strings then use the + operator....

Here'a an exmaple from one of my reports that does the same thing.

=IIF(Fields!PackSizeDesc.Value = Nothing, Nothing, 

"http://MyServername/ReportServer?/Brand+Value/_sub+SKU+Price+Details" 

 + "&CountryID=" + cStr(Fields!CountryID.Value)

 + "&CategoryID=" + cStr(Fields!CategoryID.Value)

 + "&RecordedPeriodID=" + cStr(Parameters!PeriodID.Value)

 + "&TMB=" + cStr(Fields!TrademarkBrandID.Value)

 + "&PriceStage=" + cStr(IIF(Fields!IsActualprice.Value = 1, 10, 11))

 + "&pm=" + cStr(Fields!PackMaterialID.Value)

 + "&pt=" + cStr(Fields!PackTypeID.Value)

 + "&ps=" + cStr(Fields!PackSizeID.Value)

 + "&psu=" + cStr(Fields!PackSizeUnitID.Value)

 + "&upp=" + cStr(Fields!UnitsPerPack.Value)

 + "&rc:Parameters=Collapsed")

Note: The first line just disables the link if there is now value in a particular column. This does not render to PDF but that's not part of your issue.

answered 2 days ago

Alan Schofield

5,68711019

You need to convert all your values to strings then use the + operator....

Here'a an exmaple from one of my reports that does the same thing.

=IIF(Fields!PackSizeDesc.Value = Nothing, Nothing, 

"http://MyServername/ReportServer?/Brand+Value/_sub+SKU+Price+Details" 

 + "&CountryID=" + cStr(Fields!CountryID.Value)

 + "&CategoryID=" + cStr(Fields!CategoryID.Value)

 + "&RecordedPeriodID=" + cStr(Parameters!PeriodID.Value)

 + "&TMB=" + cStr(Fields!TrademarkBrandID.Value)

 + "&PriceStage=" + cStr(IIF(Fields!IsActualprice.Value = 1, 10, 11))

 + "&pm=" + cStr(Fields!PackMaterialID.Value)

 + "&pt=" + cStr(Fields!PackTypeID.Value)

 + "&ps=" + cStr(Fields!PackSizeID.Value)

 + "&psu=" + cStr(Fields!PackSizeUnitID.Value)

 + "&upp=" + cStr(Fields!UnitsPerPack.Value)

 + "&rc:Parameters=Collapsed")

Note: The first line just disables the link if there is now value in a particular column. This does not render to PDF but that's not part of your issue.

answered 2 days ago

Alan Schofield

5,68711019

answered 2 days ago

Alan Schofield

5,68711019

answered 2 days ago

Alan Schofield

5,68711019

answered 2 days ago

Alan Schofield

5,68711019

add a comment |

draft saved

draft discarded

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Name

This page is only for reference, If you need detailed information, please check here

搜尋此網誌

Xtykutl