Active TopicsMemberlistSearchHelpRegisterLogin

Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Extended Description in MAS 4.4 Post Reply Post New Topic
Author Message
AEGTINC1
Newbie
Newbie


Joined: 23 Nov 2011
Location: United States
Online Status: Offline
Posts: 3
Quote AEGTINC1 Replybullet Topic: Extended Description in MAS 4.4
    Posted: 23 Nov 2011 at 8:48am
Hi all,
 
I am having trouble in a price list report Created in Crystal X1 with MAS 4.4. I am using the formula:
if {CI_Item.ExtendedDescriptionKey}>" " then {CI_ExtendedDescription.ExtendedDescriptionText} else {CI_Item.ItemCodeDesc}.
This does print the extended descriptions and i am able to suppress the short Description in CI_ItemCodeDesc.
The main problem i am having (very serious) is that all items without an Extended Description are no longer on the report. All field are properly linked.
I have been fighting with this since we migrated from MAS 4.3 which was not a problem.
Am I overlooking something or is there a bug in Crystal Reports XI or MAS 4.4?
Any help will be greatly appreciated.
 
AEGTINC1
IP IP Logged
kostya1122
Senior Member
Senior Member
Avatar

Joined: 13 Jun 2011
Online Status: Offline
Posts: 475
Quote kostya1122 Replybullet Posted: 23 Nov 2011 at 9:07am
maybe like this
if {CI_Item.ExtendedDescriptionKey} <> " " then {CI_ExtendedDescription.ExtendedDescriptionText} else {CI_Item.ItemCodeDesc}
or
if not(isnull({CI_Item.ExtendedDescriptionKey})) then {CI_ExtendedDescription.ExtendedDescriptionText} else {CI_Item.ItemCodeDesc}
IP IP Logged
AEGTINC1
Newbie
Newbie


Joined: 23 Nov 2011
Location: United States
Online Status: Offline
Posts: 3
Quote AEGTINC1 Replybullet Posted: 23 Nov 2011 at 9:20am
kostya1122,
 
I had tried both of those formulas before with the same results, all items without an extended description are removed from the report. These formulas do print out the extended description also, that part of it is not an issue, the issue is the disapearing items with a short description -  CI_ItemCodeDesc.
 
AEGTINC1
IP IP Logged
kostya1122
Senior Member
Senior Member
Avatar

Joined: 13 Jun 2011
Online Status: Offline
Posts: 475
Quote kostya1122 Replybullet Posted: 23 Nov 2011 at 9:36am
i dont think formula can cause items to disappear unless you putting it into select expert.
most likely it has something to do with table linking( something like instead of inner join use left outer) or it could be some sort of bug(i personally never had any bugs when we migrated from ODBC connection(ezcap 5.1) to OLE connection(ezcap 6X) Just had to update the data-source location in each table.)
IP IP Logged
AEGTINC1
Newbie
Newbie


Joined: 23 Nov 2011
Location: United States
Online Status: Offline
Posts: 3
Quote AEGTINC1 Replybullet Posted: 23 Nov 2011 at 10:22am
kostya1122
 
Thank you that was the problem with the linking. I needed to do a left join to make it function properly. I had completely ignored the link options.
 
AEGTINC1
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump 		You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.