Mixing
SSRS not recognizing dataset in expression for barcode
Whenever I use this code
=IIf(JPCI_RPT_ReceiptStatusHeaderBLW.RECEIPT_ID_TYPE = "Trailer ID",
Code.StringToBarcode({JPCI_RPT_ReceiptStatusHeaderBLW.trailer_id}),
Code.StringToBarcode({JPCI_RPT_ReceiptStatusHeaderBLW.receipt_id_type}) & chr(10) &
Code.StringToBarcode({JPCI_RPT_ReceiptStatusDetailsBLW.item})
I get the following error...
Name 'JPCI_RPT_ReceiptStatusHeaderBLW' is not declared.
It's checking for dataset right? If not, how do I declare it?
reporting-services ssrs-2012
edited Jan 2 at 22:01
Dale Burrell
3,39952655
asked Jan 2 at 21:55
JasonJason
596
add a comment |
Whenever I use this code
=IIf(JPCI_RPT_ReceiptStatusHeaderBLW.RECEIPT_ID_TYPE = "Trailer ID",
Code.StringToBarcode({JPCI_RPT_ReceiptStatusHeaderBLW.trailer_id}),
Code.StringToBarcode({JPCI_RPT_ReceiptStatusHeaderBLW.receipt_id_type}) & chr(10) &
Code.StringToBarcode({JPCI_RPT_ReceiptStatusDetailsBLW.item})
I get the following error...
Name 'JPCI_RPT_ReceiptStatusHeaderBLW' is not declared.
It's checking for dataset right? If not, how do I declare it?
reporting-services ssrs-2012
edited Jan 2 at 22:01
Dale Burrell
3,39952655
asked Jan 2 at 21:55
JasonJason
596
Where in your report are you using this code? The expression builder will help you pick fields or parameters... this isn't a format I've ever seen before.
– Dale Burrell
Jan 2 at 22:02
Where I set the value for the expression
– Jason
Jan 2 at 22:03
Sorry I don't understand your comment. We need more information about your report structure and where you are using this expression to be able to assist.
– Dale Burrell
Jan 2 at 22:04
You may want to refer to this guide for how to build expressions docs.microsoft.com/en-us/sql/reporting-services/report-design/…
– Dale Burrell
Jan 2 at 22:06
I notice you asked another similar question earlier... and based on that I think you are showing Crystal Report code, not SSRS code. You need to convert it as per your other question.
– Dale Burrell
Jan 3 at 2:42
add a comment |
Whenever I use this code
=IIf(JPCI_RPT_ReceiptStatusHeaderBLW.RECEIPT_ID_TYPE = "Trailer ID",
Code.StringToBarcode({JPCI_RPT_ReceiptStatusHeaderBLW.trailer_id}),
Code.StringToBarcode({JPCI_RPT_ReceiptStatusHeaderBLW.receipt_id_type}) & chr(10) &
Code.StringToBarcode({JPCI_RPT_ReceiptStatusDetailsBLW.item})
I get the following error...
Name 'JPCI_RPT_ReceiptStatusHeaderBLW' is not declared.
It's checking for dataset right? If not, how do I declare it?
reporting-services ssrs-2012
edited Jan 2 at 22:01
Dale Burrell
3,39952655
asked Jan 2 at 21:55
JasonJason
596
Whenever I use this code
=IIf(JPCI_RPT_ReceiptStatusHeaderBLW.RECEIPT_ID_TYPE = "Trailer ID",
Code.StringToBarcode({JPCI_RPT_ReceiptStatusHeaderBLW.trailer_id}),
Code.StringToBarcode({JPCI_RPT_ReceiptStatusHeaderBLW.receipt_id_type}) & chr(10) &
Code.StringToBarcode({JPCI_RPT_ReceiptStatusDetailsBLW.item})
I get the following error...
Name 'JPCI_RPT_ReceiptStatusHeaderBLW' is not declared.
It's checking for dataset right? If not, how do I declare it?
reporting-services ssrs-2012
reporting-services ssrs-2012
edited Jan 2 at 22:01
Dale Burrell
3,39952655
asked Jan 2 at 21:55
JasonJason
596
edited Jan 2 at 22:01
Dale Burrell
3,39952655
asked Jan 2 at 21:55
JasonJason
596
edited Jan 2 at 22:01
Dale Burrell
3,39952655
edited Jan 2 at 22:01
Dale Burrell
3,39952655
edited Jan 2 at 22:01
Dale Burrell
3,39952655
3,39952655
asked Jan 2 at 21:55
JasonJason
596
asked Jan 2 at 21:55
JasonJason
596
asked Jan 2 at 21:55
JasonJason
596
596
Where in your report are you using this code? The expression builder will help you pick fields or parameters... this isn't a format I've ever seen before.
– Dale Burrell
Jan 2 at 22:02
Where I set the value for the expression
– Jason
Jan 2 at 22:03
Sorry I don't understand your comment. We need more information about your report structure and where you are using this expression to be able to assist.
– Dale Burrell
Jan 2 at 22:04
You may want to refer to this guide for how to build expressions docs.microsoft.com/en-us/sql/reporting-services/report-design/…
– Dale Burrell
Jan 2 at 22:06
I notice you asked another similar question earlier... and based on that I think you are showing Crystal Report code, not SSRS code. You need to convert it as per your other question.
– Dale Burrell
Jan 3 at 2:42
add a comment |
Where in your report are you using this code? The expression builder will help you pick fields or parameters... this isn't a format I've ever seen before.
– Dale Burrell
Jan 2 at 22:02
Where I set the value for the expression
– Jason
Jan 2 at 22:03
Sorry I don't understand your comment. We need more information about your report structure and where you are using this expression to be able to assist.
– Dale Burrell
Jan 2 at 22:04
You may want to refer to this guide for how to build expressions docs.microsoft.com/en-us/sql/reporting-services/report-design/…
– Dale Burrell
Jan 2 at 22:06
I notice you asked another similar question earlier... and based on that I think you are showing Crystal Report code, not SSRS code. You need to convert it as per your other question.
– Dale Burrell
Jan 3 at 2:42
Where in your report are you using this code? The expression builder will help you pick fields or parameters... this isn't a format I've ever seen before.
– Dale Burrell
Jan 2 at 22:02
Where in your report are you using this code? The expression builder will help you pick fields or parameters... this isn't a format I've ever seen before.
– Dale Burrell
Jan 2 at 22:02
Where I set the value for the expression
– Jason
Jan 2 at 22:03
Where I set the value for the expression
– Jason
Jan 2 at 22:03
Sorry I don't understand your comment. We need more information about your report structure and where you are using this expression to be able to assist.
– Dale Burrell
Jan 2 at 22:04
Sorry I don't understand your comment. We need more information about your report structure and where you are using this expression to be able to assist.
– Dale Burrell
Jan 2 at 22:04
You may want to refer to this guide for how to build expressions docs.microsoft.com/en-us/sql/reporting-services/report-design/…
– Dale Burrell
Jan 2 at 22:06
You may want to refer to this guide for how to build expressions docs.microsoft.com/en-us/sql/reporting-services/report-design/…
– Dale Burrell
Jan 2 at 22:06
I notice you asked another similar question earlier... and based on that I think you are showing Crystal Report code, not SSRS code. You need to convert it as per your other question.
– Dale Burrell
Jan 3 at 2:42
I notice you asked another similar question earlier... and based on that I think you are showing Crystal Report code, not SSRS code. You need to convert it as per your other question.
– Dale Burrell
Jan 3 at 2:42
add a comment |
1 Answer
1
active
oldest
votes
The expression is looking for a field name and you're converting something like Crystal Reports to SSRS. In SSRS you refer to a field value with Fields!FieldName.Value.
Assumeing that you have a dataset with necessary fields, your expression would be something like:
=IIF(Fields!RECEIPT_ID_TYPE.Value = "Trailer ID",
Code.StringToBarcode(Fields!trailer_id.Value),
Code.StringToBarcode(Fields!receipt_id_type.Value) & chr(10) &
Code.StringToBarcode(Fields!item.Value) )
You had missed a closing parenthesis as well, but the error check didn't get that far.
answered Jan 2 at 23:54
Hannover FistHannover Fist
5,9851825
add a comment |
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',
autoActivateHeartbeat: false,
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
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54013673%2fssrs-not-recognizing-dataset-in-expression-for-barcode%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
The expression is looking for a field name and you're converting something like Crystal Reports to SSRS. In SSRS you refer to a field value with Fields!FieldName.Value.
Assumeing that you have a dataset with necessary fields, your expression would be something like:
=IIF(Fields!RECEIPT_ID_TYPE.Value = "Trailer ID",
Code.StringToBarcode(Fields!trailer_id.Value),
Code.StringToBarcode(Fields!receipt_id_type.Value) & chr(10) &
Code.StringToBarcode(Fields!item.Value) )
You had missed a closing parenthesis as well, but the error check didn't get that far.
answered Jan 2 at 23:54
Hannover FistHannover Fist
5,9851825
add a comment |
The expression is looking for a field name and you're converting something like Crystal Reports to SSRS. In SSRS you refer to a field value with Fields!FieldName.Value.
Assumeing that you have a dataset with necessary fields, your expression would be something like:
=IIF(Fields!RECEIPT_ID_TYPE.Value = "Trailer ID",
Code.StringToBarcode(Fields!trailer_id.Value),
Code.StringToBarcode(Fields!receipt_id_type.Value) & chr(10) &
Code.StringToBarcode(Fields!item.Value) )
You had missed a closing parenthesis as well, but the error check didn't get that far.
answered Jan 2 at 23:54
Hannover FistHannover Fist
5,9851825
add a comment |
The expression is looking for a field name and you're converting something like Crystal Reports to SSRS. In SSRS you refer to a field value with Fields!FieldName.Value.
Assumeing that you have a dataset with necessary fields, your expression would be something like:
=IIF(Fields!RECEIPT_ID_TYPE.Value = "Trailer ID",
Code.StringToBarcode(Fields!trailer_id.Value),
Code.StringToBarcode(Fields!receipt_id_type.Value) & chr(10) &
Code.StringToBarcode(Fields!item.Value) )
You had missed a closing parenthesis as well, but the error check didn't get that far.
answered Jan 2 at 23:54
Hannover FistHannover Fist
5,9851825
The expression is looking for a field name and you're converting something like Crystal Reports to SSRS. In SSRS you refer to a field value with Fields!FieldName.Value.
Assumeing that you have a dataset with necessary fields, your expression would be something like:
=IIF(Fields!RECEIPT_ID_TYPE.Value = "Trailer ID",
Code.StringToBarcode(Fields!trailer_id.Value),
Code.StringToBarcode(Fields!receipt_id_type.Value) & chr(10) &
Code.StringToBarcode(Fields!item.Value) )
You had missed a closing parenthesis as well, but the error check didn't get that far.
answered Jan 2 at 23:54
Hannover FistHannover Fist
5,9851825
answered Jan 2 at 23:54
Hannover FistHannover Fist
5,9851825
answered Jan 2 at 23:54
Hannover FistHannover Fist
5,9851825
answered Jan 2 at 23:54
Hannover FistHannover Fist
5,9851825
5,9851825
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54013673%2fssrs-not-recognizing-dataset-in-expression-for-barcode%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Where in your report are you using this code? The expression builder will help you pick fields or parameters... this isn't a format I've ever seen before.
– Dale Burrell
Jan 2 at 22:02
Where I set the value for the expression
– Jason
Jan 2 at 22:03
Sorry I don't understand your comment. We need more information about your report structure and where you are using this expression to be able to assist.
– Dale Burrell
Jan 2 at 22:04
You may want to refer to this guide for how to build expressions docs.microsoft.com/en-us/sql/reporting-services/report-design/…
– Dale Burrell
Jan 2 at 22:06
I notice you asked another similar question earlier... and based on that I think you are showing Crystal Report code, not SSRS code. You need to convert it as per your other question.
– Dale Burrell
Jan 3 at 2:42