Crystal Reports is not showing values for database fields in text objects
I have a text object and in it I dropped some fields from the database explorer and I put also some text in that text object. My problem is that the values for the database fields in the text objects are not shown.
When I created the text object, I did it in the designer, and when previewed it worked.
When I export the report to a rpt file, those fields are not shown. My text object is in the report header.
I use Crystal reports 2008 and a database command for returning my records.
Please help !
crystal-reports
edited Mar 3 '11 at 19:11
MPelletier
11.5k1171118
asked Jan 31 '11 at 12:32
AlexAlex
842416
add a comment |
I have a text object and in it I dropped some fields from the database explorer and I put also some text in that text object. My problem is that the values for the database fields in the text objects are not shown.
When I created the text object, I did it in the designer, and when previewed it worked.
When I export the report to a rpt file, those fields are not shown. My text object is in the report header.
I use Crystal reports 2008 and a database command for returning my records.
Please help !
crystal-reports
edited Mar 3 '11 at 19:11
MPelletier
11.5k1171118
asked Jan 31 '11 at 12:32
AlexAlex
842416
Just so I'm clear: You are exporting this as a different Crystal Report (.rpt). When you open the second Crystal Report, the value of the database field in the text object is not populated. Is that the issue? Do the other database fields in the new report populate? Or is it just the database field in the text box that doesn't?
– Henry
Jan 31 '11 at 12:45
Yes, the value for the database field in the text object is not populated. The other fields in the report are populated.
– Alex
Jan 31 '11 at 12:52
If any of your field is null, wouldn't the entire text object be null as well? I think simplifying by not putting in a text box is sound troubleshooting.
– Sun
Mar 6 '17 at 18:28
add a comment |
I have a text object and in it I dropped some fields from the database explorer and I put also some text in that text object. My problem is that the values for the database fields in the text objects are not shown.
When I created the text object, I did it in the designer, and when previewed it worked.
When I export the report to a rpt file, those fields are not shown. My text object is in the report header.
I use Crystal reports 2008 and a database command for returning my records.
Please help !
crystal-reports
edited Mar 3 '11 at 19:11
MPelletier
11.5k1171118
asked Jan 31 '11 at 12:32
AlexAlex
842416
I have a text object and in it I dropped some fields from the database explorer and I put also some text in that text object. My problem is that the values for the database fields in the text objects are not shown.
When I created the text object, I did it in the designer, and when previewed it worked.
When I export the report to a rpt file, those fields are not shown. My text object is in the report header.
I use Crystal reports 2008 and a database command for returning my records.
Please help !
crystal-reports
crystal-reports
edited Mar 3 '11 at 19:11
MPelletier
11.5k1171118
asked Jan 31 '11 at 12:32
AlexAlex
842416
edited Mar 3 '11 at 19:11
MPelletier
11.5k1171118
asked Jan 31 '11 at 12:32
AlexAlex
842416
edited Mar 3 '11 at 19:11
MPelletier
11.5k1171118
edited Mar 3 '11 at 19:11
MPelletier
11.5k1171118
edited Mar 3 '11 at 19:11
MPelletier
11.5k1171118
11.5k1171118
asked Jan 31 '11 at 12:32
AlexAlex
842416
asked Jan 31 '11 at 12:32
AlexAlex
842416
asked Jan 31 '11 at 12:32
AlexAlex
842416
842416
Just so I'm clear: You are exporting this as a different Crystal Report (.rpt). When you open the second Crystal Report, the value of the database field in the text object is not populated. Is that the issue? Do the other database fields in the new report populate? Or is it just the database field in the text box that doesn't?
– Henry
Jan 31 '11 at 12:45
Yes, the value for the database field in the text object is not populated. The other fields in the report are populated.
– Alex
Jan 31 '11 at 12:52
If any of your field is null, wouldn't the entire text object be null as well? I think simplifying by not putting in a text box is sound troubleshooting.
– Sun
Mar 6 '17 at 18:28
add a comment |
Just so I'm clear: You are exporting this as a different Crystal Report (.rpt). When you open the second Crystal Report, the value of the database field in the text object is not populated. Is that the issue? Do the other database fields in the new report populate? Or is it just the database field in the text box that doesn't?
– Henry
Jan 31 '11 at 12:45
Yes, the value for the database field in the text object is not populated. The other fields in the report are populated.
– Alex
Jan 31 '11 at 12:52
If any of your field is null, wouldn't the entire text object be null as well? I think simplifying by not putting in a text box is sound troubleshooting.
– Sun
Mar 6 '17 at 18:28
Just so I'm clear: You are exporting this as a different Crystal Report (.rpt). When you open the second Crystal Report, the value of the database field in the text object is not populated. Is that the issue? Do the other database fields in the new report populate? Or is it just the database field in the text box that doesn't?
– Henry
Jan 31 '11 at 12:45
Just so I'm clear: You are exporting this as a different Crystal Report (.rpt). When you open the second Crystal Report, the value of the database field in the text object is not populated. Is that the issue? Do the other database fields in the new report populate? Or is it just the database field in the text box that doesn't?
– Henry
Jan 31 '11 at 12:45
Yes, the value for the database field in the text object is not populated. The other fields in the report are populated.
– Alex
Jan 31 '11 at 12:52
Yes, the value for the database field in the text object is not populated. The other fields in the report are populated.
– Alex
Jan 31 '11 at 12:52
If any of your field is null, wouldn't the entire text object be null as well? I think simplifying by not putting in a text box is sound troubleshooting.
– Sun
Mar 6 '17 at 18:28
If any of your field is null, wouldn't the entire text object be null as well? I think simplifying by not putting in a text box is sound troubleshooting.
– Sun
Mar 6 '17 at 18:28
add a comment |
4 Answers
4
active
oldest
votes
Hmmm. I can't duplicate that behavior here. The database field in the text box fills for me when I test it. I'm curious, if you put the same database field in the Report Header outside of a text box, does it have a value when you export the report? What if you move the text box down to the Page Header? To the Detail block? Do any of these things affect whether the database field fills or not? If it never fills, it suggests that whatever conditions produce that value, i.e in the database, or at the report level via parameters, doesn't hold when you open the new .rpt. Unfortunately, since a Crystal Report is such a visual medium, i.e. it's not just a block of code, I can't really "see" what the issues might be to be of much more help.
answered Jan 31 '11 at 15:06
HenryHenry
317516
Well, in Crystal Reports, when I go on the preview tab, it works, but when I export my report it doesn't work. Before the exporting, I change some of the fields in the text object for translation, not the database fields, the fields defined by me that represents the code for translation. Do you think that this could be the problem? Also, when exporting the report, the database fields in the text object are like table.fieldName but in the designer when I create them have only fieldName.
– Alex
Jan 31 '11 at 15:43
Alex, try turning off your translation changes. Do you still have these issues? Also, what about Henry's suggestion to move these fields outside of the text boxes, do you still have issues then?
– PowerUser
Feb 1 '11 at 13:43
add a comment |
what happens if you move the field from the report-header section to the detail section? it is possible that the first record in your result set is blank/null for that field. if you move it (the textobject) to the details section, you can test my assertion.
answered Feb 3 '11 at 23:45
craigcraig
17.1k1778149
add a comment |
It seems that when translating the text objects something is lost. If I lose the translation, it works. Strange.
answered Feb 8 '11 at 10:26
AlexAlex
842416
add a comment |
why you use text object my friend?? you can use formula field exchange of text object and i am sure it can help you.
but if you use code to create your objects, you can use field object exchange of text object. you know text of text objects are constant,there for you cant add data base field in it
answered Oct 29 '13 at 10:51
HamidrezaHamidreza
2,63911114
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%2f4850883%2fcrystal-reports-is-not-showing-values-for-database-fields-in-text-objects%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
4 Answers
4
active
oldest
votes
4 Answers
4
active
oldest
votes
active
oldest
votes
active
oldest
votes
Hmmm. I can't duplicate that behavior here. The database field in the text box fills for me when I test it. I'm curious, if you put the same database field in the Report Header outside of a text box, does it have a value when you export the report? What if you move the text box down to the Page Header? To the Detail block? Do any of these things affect whether the database field fills or not? If it never fills, it suggests that whatever conditions produce that value, i.e in the database, or at the report level via parameters, doesn't hold when you open the new .rpt. Unfortunately, since a Crystal Report is such a visual medium, i.e. it's not just a block of code, I can't really "see" what the issues might be to be of much more help.
answered Jan 31 '11 at 15:06
HenryHenry
317516
Well, in Crystal Reports, when I go on the preview tab, it works, but when I export my report it doesn't work. Before the exporting, I change some of the fields in the text object for translation, not the database fields, the fields defined by me that represents the code for translation. Do you think that this could be the problem? Also, when exporting the report, the database fields in the text object are like table.fieldName but in the designer when I create them have only fieldName.
– Alex
Jan 31 '11 at 15:43
Alex, try turning off your translation changes. Do you still have these issues? Also, what about Henry's suggestion to move these fields outside of the text boxes, do you still have issues then?
– PowerUser
Feb 1 '11 at 13:43
add a comment |
Hmmm. I can't duplicate that behavior here. The database field in the text box fills for me when I test it. I'm curious, if you put the same database field in the Report Header outside of a text box, does it have a value when you export the report? What if you move the text box down to the Page Header? To the Detail block? Do any of these things affect whether the database field fills or not? If it never fills, it suggests that whatever conditions produce that value, i.e in the database, or at the report level via parameters, doesn't hold when you open the new .rpt. Unfortunately, since a Crystal Report is such a visual medium, i.e. it's not just a block of code, I can't really "see" what the issues might be to be of much more help.
answered Jan 31 '11 at 15:06
HenryHenry
317516
Well, in Crystal Reports, when I go on the preview tab, it works, but when I export my report it doesn't work. Before the exporting, I change some of the fields in the text object for translation, not the database fields, the fields defined by me that represents the code for translation. Do you think that this could be the problem? Also, when exporting the report, the database fields in the text object are like table.fieldName but in the designer when I create them have only fieldName.
– Alex
Jan 31 '11 at 15:43
Alex, try turning off your translation changes. Do you still have these issues? Also, what about Henry's suggestion to move these fields outside of the text boxes, do you still have issues then?
– PowerUser
Feb 1 '11 at 13:43
add a comment |
Hmmm. I can't duplicate that behavior here. The database field in the text box fills for me when I test it. I'm curious, if you put the same database field in the Report Header outside of a text box, does it have a value when you export the report? What if you move the text box down to the Page Header? To the Detail block? Do any of these things affect whether the database field fills or not? If it never fills, it suggests that whatever conditions produce that value, i.e in the database, or at the report level via parameters, doesn't hold when you open the new .rpt. Unfortunately, since a Crystal Report is such a visual medium, i.e. it's not just a block of code, I can't really "see" what the issues might be to be of much more help.
answered Jan 31 '11 at 15:06
HenryHenry
317516
Hmmm. I can't duplicate that behavior here. The database field in the text box fills for me when I test it. I'm curious, if you put the same database field in the Report Header outside of a text box, does it have a value when you export the report? What if you move the text box down to the Page Header? To the Detail block? Do any of these things affect whether the database field fills or not? If it never fills, it suggests that whatever conditions produce that value, i.e in the database, or at the report level via parameters, doesn't hold when you open the new .rpt. Unfortunately, since a Crystal Report is such a visual medium, i.e. it's not just a block of code, I can't really "see" what the issues might be to be of much more help.
answered Jan 31 '11 at 15:06
HenryHenry
317516
answered Jan 31 '11 at 15:06
HenryHenry
317516
answered Jan 31 '11 at 15:06
HenryHenry
317516
answered Jan 31 '11 at 15:06
HenryHenry
317516
317516
Well, in Crystal Reports, when I go on the preview tab, it works, but when I export my report it doesn't work. Before the exporting, I change some of the fields in the text object for translation, not the database fields, the fields defined by me that represents the code for translation. Do you think that this could be the problem? Also, when exporting the report, the database fields in the text object are like table.fieldName but in the designer when I create them have only fieldName.
– Alex
Jan 31 '11 at 15:43
Alex, try turning off your translation changes. Do you still have these issues? Also, what about Henry's suggestion to move these fields outside of the text boxes, do you still have issues then?
– PowerUser
Feb 1 '11 at 13:43
add a comment |
Well, in Crystal Reports, when I go on the preview tab, it works, but when I export my report it doesn't work. Before the exporting, I change some of the fields in the text object for translation, not the database fields, the fields defined by me that represents the code for translation. Do you think that this could be the problem? Also, when exporting the report, the database fields in the text object are like table.fieldName but in the designer when I create them have only fieldName.
– Alex
Jan 31 '11 at 15:43
Alex, try turning off your translation changes. Do you still have these issues? Also, what about Henry's suggestion to move these fields outside of the text boxes, do you still have issues then?
– PowerUser
Feb 1 '11 at 13:43
Well, in Crystal Reports, when I go on the preview tab, it works, but when I export my report it doesn't work. Before the exporting, I change some of the fields in the text object for translation, not the database fields, the fields defined by me that represents the code for translation. Do you think that this could be the problem? Also, when exporting the report, the database fields in the text object are like table.fieldName but in the designer when I create them have only fieldName.
– Alex
Jan 31 '11 at 15:43
Well, in Crystal Reports, when I go on the preview tab, it works, but when I export my report it doesn't work. Before the exporting, I change some of the fields in the text object for translation, not the database fields, the fields defined by me that represents the code for translation. Do you think that this could be the problem? Also, when exporting the report, the database fields in the text object are like table.fieldName but in the designer when I create them have only fieldName.
– Alex
Jan 31 '11 at 15:43
Alex, try turning off your translation changes. Do you still have these issues? Also, what about Henry's suggestion to move these fields outside of the text boxes, do you still have issues then?
– PowerUser
Feb 1 '11 at 13:43
Alex, try turning off your translation changes. Do you still have these issues? Also, what about Henry's suggestion to move these fields outside of the text boxes, do you still have issues then?
– PowerUser
Feb 1 '11 at 13:43
add a comment |
what happens if you move the field from the report-header section to the detail section? it is possible that the first record in your result set is blank/null for that field. if you move it (the textobject) to the details section, you can test my assertion.
answered Feb 3 '11 at 23:45
craigcraig
17.1k1778149
add a comment |
what happens if you move the field from the report-header section to the detail section? it is possible that the first record in your result set is blank/null for that field. if you move it (the textobject) to the details section, you can test my assertion.
answered Feb 3 '11 at 23:45
craigcraig
17.1k1778149
add a comment |
what happens if you move the field from the report-header section to the detail section? it is possible that the first record in your result set is blank/null for that field. if you move it (the textobject) to the details section, you can test my assertion.
answered Feb 3 '11 at 23:45
craigcraig
17.1k1778149
what happens if you move the field from the report-header section to the detail section? it is possible that the first record in your result set is blank/null for that field. if you move it (the textobject) to the details section, you can test my assertion.
answered Feb 3 '11 at 23:45
craigcraig
17.1k1778149
answered Feb 3 '11 at 23:45
craigcraig
17.1k1778149
answered Feb 3 '11 at 23:45
craigcraig
17.1k1778149
answered Feb 3 '11 at 23:45
craigcraig
17.1k1778149
17.1k1778149
add a comment |
add a comment |
It seems that when translating the text objects something is lost. If I lose the translation, it works. Strange.
answered Feb 8 '11 at 10:26
AlexAlex
842416
add a comment |
It seems that when translating the text objects something is lost. If I lose the translation, it works. Strange.
answered Feb 8 '11 at 10:26
AlexAlex
842416
add a comment |
It seems that when translating the text objects something is lost. If I lose the translation, it works. Strange.
answered Feb 8 '11 at 10:26
AlexAlex
842416
It seems that when translating the text objects something is lost. If I lose the translation, it works. Strange.
answered Feb 8 '11 at 10:26
AlexAlex
842416
answered Feb 8 '11 at 10:26
AlexAlex
842416
answered Feb 8 '11 at 10:26
AlexAlex
842416
answered Feb 8 '11 at 10:26
AlexAlex
842416
842416
add a comment |
add a comment |
why you use text object my friend?? you can use formula field exchange of text object and i am sure it can help you.
but if you use code to create your objects, you can use field object exchange of text object. you know text of text objects are constant,there for you cant add data base field in it
answered Oct 29 '13 at 10:51
HamidrezaHamidreza
2,63911114
add a comment |
why you use text object my friend?? you can use formula field exchange of text object and i am sure it can help you.
but if you use code to create your objects, you can use field object exchange of text object. you know text of text objects are constant,there for you cant add data base field in it
answered Oct 29 '13 at 10:51
HamidrezaHamidreza
2,63911114
add a comment |
why you use text object my friend?? you can use formula field exchange of text object and i am sure it can help you.
but if you use code to create your objects, you can use field object exchange of text object. you know text of text objects are constant,there for you cant add data base field in it
answered Oct 29 '13 at 10:51
HamidrezaHamidreza
2,63911114
why you use text object my friend?? you can use formula field exchange of text object and i am sure it can help you.
but if you use code to create your objects, you can use field object exchange of text object. you know text of text objects are constant,there for you cant add data base field in it
answered Oct 29 '13 at 10:51
HamidrezaHamidreza
2,63911114
answered Oct 29 '13 at 10:51
HamidrezaHamidreza
2,63911114
answered Oct 29 '13 at 10:51
HamidrezaHamidreza
2,63911114
answered Oct 29 '13 at 10:51
HamidrezaHamidreza
2,63911114
2,63911114
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%2f4850883%2fcrystal-reports-is-not-showing-values-for-database-fields-in-text-objects%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
Just so I'm clear: You are exporting this as a different Crystal Report (.rpt). When you open the second Crystal Report, the value of the database field in the text object is not populated. Is that the issue? Do the other database fields in the new report populate? Or is it just the database field in the text box that doesn't?
– Henry
Jan 31 '11 at 12:45
Yes, the value for the database field in the text object is not populated. The other fields in the report are populated.
– Alex
Jan 31 '11 at 12:52
If any of your field is null, wouldn't the entire text object be null as well? I think simplifying by not putting in a text box is sound troubleshooting.
– Sun
Mar 6 '17 at 18:28