We help IT Professionals succeed at work.

Segate Crystal Reports 6.0 --How to reflect the changes in .ttx file in report

pacchy
pacchy asked
on
I have a .ttx file already mapped for a report. I have to add one more field in the .ttx file. After adding the field in the ttx file and saving it I am not able to see the field in the report for which i mapped the ttx file.
In the insert field option it still shows only previous fields of the ttx file. how do I get the new one added?
Comment
Watch Question

Commented:
If you mean by mapping that you have right clicked on a blank area of the report and then done

Database - - > add Database to report " then selected the new . ttx file and hit open"

then you need to right click again on a blank area and then do

Database - - > log onto server  " then select ACTIVE DATA( FIELD DEFINITIONS ONLY)"

Then it should be working correctly.  Have you tried to add any formulas.  I have had some formulas that have done some odd things.

DandL
Do --

Database --> Verify Database. This should solve your problem.

Narahari

Author

Commented:
I tried all these options but its tossing an error saying memory full...

Commented:
What is your sql like.  If you are doing a cartesian join you can run into these errors.  So if you have two tables that are 1000 rows that kind of join will return 1000000 rows.  This of course would be a memory hog. By the way you can reject the proposed answer it you like.
More to come. . . I think

Commented:
you said. . . .
>In the insert field option it still shows only previous fields of the ttx file. how do I get the new
one added?

First I would try this.
I would make a different .ttx file with the new revisions in it. I would then add that to the database also. You can have more then one .ttx file linked to a single report. See if that will work.

If that does not work you might need to do this.

You might need to right click on the database and say remove database from report.  I know this is not a popular option but it might need to be done. Then readd that modified .ttx file back and see if the changes in the .ttx file show up.

Let me know how that works
DandL

Proposed answer rejected.

trnarahari,

Please suggest your solutions in the form of a Comment, rather than an Answer, unless you are absolutely certain that your suggestion is the one and only correct solution, and you are certain that you have not repeated someone else's suggestion. For more information, please see the Tips at the bottom of the page and http://www.experts-exchange.com/jsp/cmtyHelpDesk.jsp#14.

pacchy,

Some of these questions have been open for some time. Please resolve them appropriately as soon as possible.

http://www.experts-exchange.com/jsp/qShow.jsp?qid=20089066
http://www.experts-exchange.com/jsp/qShow.jsp?qid=20118334
http://www.experts-exchange.com/jsp/qShow.jsp?qid=20226674
http://www.experts-exchange.com/jsp/qShow.jsp?qid=20228288
http://www.experts-exchange.com/jsp/qShow.jsp?qid=20195966

Thanks,

Netminder
Community Support Moderator
Experts Exchange
There has been no activity in this question in quite some time, and it looks like it has been abandoned. As part of our ongoing mission to clean up the topic areas, a Moderator will finalize this question within the next seven (7) days. At that time, either I or one of the other Moderators will force/accept the comment of DandL.

DO NOT ACCEPT THIS COMMENT AS AN ANSWER. If you have further comments on this question or the recommendation, please leave them here.

Netminder
Community Support Moderator
Experts Exchange
Force/accepted by

Netminder
Community Support Moderator
Experts Exchange

Explore More ContentExplore courses, solutions, and other research materials related to this topic.