Number of records shows correctly except column 'New Computed Start Date' shows all '######' format when date...
In disco and ssrs Number of records shows correctly except column 'New Computed Start Date' shows all '######' format when date is pretty old date, example: 01-DEC-1184 but when export data from ssrs .
when export data from ssrs 
data in ssrs before exporting
sql ssrs-2008
edited Nov 22 '18 at 9:22
Sanal Sunny
6628
asked Nov 22 '18 at 6:26
yamuna yamuna
61
add a comment |
In disco and ssrs Number of records shows correctly except column 'New Computed Start Date' shows all '######' format when date is pretty old date, example: 01-DEC-1184 but when export data from ssrs .
when export data from ssrs
data in ssrs before exporting
sql ssrs-2008
edited Nov 22 '18 at 9:22
Sanal Sunny
6628
asked Nov 22 '18 at 6:26
yamuna yamuna
61
add a comment |
In disco and ssrs Number of records shows correctly except column 'New Computed Start Date' shows all '######' format when date is pretty old date, example: 01-DEC-1184 but when export data from ssrs .
when export data from ssrs
data in ssrs before exporting
sql ssrs-2008
edited Nov 22 '18 at 9:22
Sanal Sunny
6628
asked Nov 22 '18 at 6:26
yamuna yamuna
61
In disco and ssrs Number of records shows correctly except column 'New Computed Start Date' shows all '######' format when date is pretty old date, example: 01-DEC-1184 but when export data from ssrs .
when export data from ssrs
data in ssrs before exporting
sql ssrs-2008
sql ssrs-2008
edited Nov 22 '18 at 9:22
Sanal Sunny
6628
asked Nov 22 '18 at 6:26
yamuna yamuna
61
edited Nov 22 '18 at 9:22
Sanal Sunny
6628
asked Nov 22 '18 at 6:26
yamuna yamuna
61
edited Nov 22 '18 at 9:22
Sanal Sunny
6628
edited Nov 22 '18 at 9:22
Sanal Sunny
6628
edited Nov 22 '18 at 9:22
Sanal Sunny
6628
6628
asked Nov 22 '18 at 6:26
yamuna yamuna
61
asked Nov 22 '18 at 6:26
yamuna yamuna
61
asked Nov 22 '18 at 6:26
yamuna yamuna
61
61
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
If you open an excel and input several dates in cells, any date before 01-01-1900 won't be parsed as date (if you set cell formatting to date for those cells). You can check this link for more details: http://www.exceluser.com/formulas/earlydates.htm
Same should apply for your data in the SSRS report.
I would format that column as text in SSRS instead as date.
answered Nov 22 '18 at 16:34
Nemanja TodorovicNemanja Todorovic
501413
add a comment |
Apply this 3 steps to display the date correctly and transfer it correctly to Excel:
- Go to your general report settings and set the language (this value cant be empty)
- Go to your textbox properties and set the
Numberformat toDate
- Go to your textbox expression and add a
CDate()around your field=CDate(Fields!YourDate.Value)
This way the date gets displayed and exported correctly.
answered Nov 26 '18 at 5:30
StrawberryshrubStrawberryshrub
1,2212416
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',
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%2f53425010%2fnumber-of-records-shows-correctly-except-column-new-computed-start-date-shows%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
If you open an excel and input several dates in cells, any date before 01-01-1900 won't be parsed as date (if you set cell formatting to date for those cells). You can check this link for more details: http://www.exceluser.com/formulas/earlydates.htm
Same should apply for your data in the SSRS report.
I would format that column as text in SSRS instead as date.
answered Nov 22 '18 at 16:34
Nemanja TodorovicNemanja Todorovic
501413
add a comment |
If you open an excel and input several dates in cells, any date before 01-01-1900 won't be parsed as date (if you set cell formatting to date for those cells). You can check this link for more details: http://www.exceluser.com/formulas/earlydates.htm
Same should apply for your data in the SSRS report.
I would format that column as text in SSRS instead as date.
answered Nov 22 '18 at 16:34
Nemanja TodorovicNemanja Todorovic
501413
add a comment |
If you open an excel and input several dates in cells, any date before 01-01-1900 won't be parsed as date (if you set cell formatting to date for those cells). You can check this link for more details: http://www.exceluser.com/formulas/earlydates.htm
Same should apply for your data in the SSRS report.
I would format that column as text in SSRS instead as date.
answered Nov 22 '18 at 16:34
Nemanja TodorovicNemanja Todorovic
501413
If you open an excel and input several dates in cells, any date before 01-01-1900 won't be parsed as date (if you set cell formatting to date for those cells). You can check this link for more details: http://www.exceluser.com/formulas/earlydates.htm
Same should apply for your data in the SSRS report.
I would format that column as text in SSRS instead as date.
answered Nov 22 '18 at 16:34
Nemanja TodorovicNemanja Todorovic
501413
answered Nov 22 '18 at 16:34
Nemanja TodorovicNemanja Todorovic
501413
answered Nov 22 '18 at 16:34
Nemanja TodorovicNemanja Todorovic
501413
answered Nov 22 '18 at 16:34
Nemanja TodorovicNemanja Todorovic
501413
501413
add a comment |
add a comment |
Apply this 3 steps to display the date correctly and transfer it correctly to Excel:
- Go to your general report settings and set the language (this value cant be empty)
- Go to your textbox properties and set the
Numberformat toDate
- Go to your textbox expression and add a
CDate()around your field=CDate(Fields!YourDate.Value)
This way the date gets displayed and exported correctly.
answered Nov 26 '18 at 5:30
StrawberryshrubStrawberryshrub
1,2212416
add a comment |
Apply this 3 steps to display the date correctly and transfer it correctly to Excel:
- Go to your general report settings and set the language (this value cant be empty)
- Go to your textbox properties and set the
Numberformat toDate
- Go to your textbox expression and add a
CDate()around your field=CDate(Fields!YourDate.Value)
This way the date gets displayed and exported correctly.
answered Nov 26 '18 at 5:30
StrawberryshrubStrawberryshrub
1,2212416
add a comment |
Apply this 3 steps to display the date correctly and transfer it correctly to Excel:
- Go to your general report settings and set the language (this value cant be empty)
- Go to your textbox properties and set the
Numberformat toDate
- Go to your textbox expression and add a
CDate()around your field=CDate(Fields!YourDate.Value)
This way the date gets displayed and exported correctly.
answered Nov 26 '18 at 5:30
StrawberryshrubStrawberryshrub
1,2212416
Apply this 3 steps to display the date correctly and transfer it correctly to Excel:
- Go to your general report settings and set the language (this value cant be empty)
- Go to your textbox properties and set the
Numberformat toDate
- Go to your textbox expression and add a
CDate()around your field=CDate(Fields!YourDate.Value)
This way the date gets displayed and exported correctly.
answered Nov 26 '18 at 5:30
StrawberryshrubStrawberryshrub
1,2212416
answered Nov 26 '18 at 5:30
StrawberryshrubStrawberryshrub
1,2212416
answered Nov 26 '18 at 5:30
StrawberryshrubStrawberryshrub
1,2212416
answered Nov 26 '18 at 5:30
StrawberryshrubStrawberryshrub
1,2212416
1,2212416
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%2f53425010%2fnumber-of-records-shows-correctly-except-column-new-computed-start-date-shows%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
