| Author | Message | ||
     Andhrawala Legend Username: Andhrawala Post Number: 34878 Registered: 03-2008 Posted From: 71.65.224.202 Rating: N/A |
Nultiple formulas. supress if null. allow grow etc No Signature | ||
| Rajin Side Hero Username: Rajin Post Number: 6060 Registered: 05-2012 Posted From: 63.250.254.2 Rating: N/A |
ayithe kastam  | ||
| Coolmac Megastar Username: Coolmac Post Number: 28968 Registered: 05-2007 Posted From: 65.170.103.234 Rating: N/A |
adhi kuda oka limit varake cheyyagalam kadha... like oka 20 chunks anukunte 20X 4000 = 80000 characters can be covered..What if there is more than that? adhi maa damager kossen  | ||
| Andhrawala Legend Username: Andhrawala Post Number: 34868 Registered: 03-2008 Posted From: 152.51.56.1 Rating: N/A |
chunks laaga cut sesi oka formula field lo concatenate seyalemaaaa. or else one week kastapadi idhe solution ani SAP vaadu annaadu ani seppedhii No Signature | ||
| Coolmac Megastar Username: Coolmac Post Number: 28967 Registered: 05-2007 Posted From: 65.170.103.234 Rating: N/A |
maadhi Federal employees santha... ee vayasulo vunna vaallani educate chesinaa waste ani naa vuddesam... deeniki thodu maa damager is IIT desi gadu... pratidhi perfect kavali antaadu...chunks ga cutting ki oppukovatam ledhu..find an efficient way antunnadu eedi mam parri | ||
| Rajin Side Hero Username: Rajin Post Number: 6059 Registered: 05-2012 Posted From: 63.250.254.2 Rating: N/A |
ade mari educate/train the USERs ani resume keyword vuntaadi kada manakeee... | ||
| Coolmac Megastar Username: Coolmac Post Number: 28966 Registered: 05-2007 Posted From: 65.170.103.234 Rating: N/A |
ardham ayyindhi... solution ledhu for now... chunks ga cut chesi malli concatinate cheskovalisndhe...or write a script to keep on cutting it to chunks till the last character in clob. ayinaa intha pedda text clob lo ettukune badhulu , okka phone chesi cheppukunte ayipodhi kadha vaallaki asale unlimited talk and text plans vunnai ippudu | ||
| Rajin Side Hero Username: Rajin Post Number: 6056 Registered: 05-2012 Posted From: 63.250.254.2 Rating: N/A |
Nope annadu, break that into multiple clobs of no more than 4000 character each annadu. that is database limitation not crystal annadu , less than 4000 vunte direct drop chesthe will be memo field it will take care annad.. mekemmanna ardam ayyndhaaa... | ||
| Coolmac Megastar Username: Coolmac Post Number: 28965 Registered: 05-2007 Posted From: 65.170.103.234 Rating: N/A |
ippudu vunnada? | ||
| Rajin Side Hero Username: Rajin Post Number: 6055 Registered: 05-2012 Posted From: 63.250.254.2 Rating: N/A |
same edi esthe adi nerchuni cheyytame alage chesaa appudu chinna fixes.. almost kastame antunnaru even 2011 because of 32bit antaa ade VS ayithe 64bit from 2010 onwards need to settle with workaround and educate dataentries.. http://h30499.www3.hp.com/t5/HP-Service-Manager-Service/Conv erting-BLOB-CLOB-ServiceCenter-data-for-reporting/td-p/45089 75#.VFvSR_nF-ug oka expert gaadu vunnadu appudappudu visiting chesthadu vaadini adugutaa veelaithe | ||
| Andhrawala Legend Username: Andhrawala Post Number: 34866 Registered: 03-2008 Posted From: 152.51.56.1 Rating: N/A |
yes It cant cross certain number of lines No Signature | ||
| Coolmac Megastar Username: Coolmac Post Number: 28964 Registered: 05-2007 Posted From: 65.170.103.234 Rating: N/A |
CR XI vaaduthunnam..chala paatha version I guess.. we dont need it much,, eppudo edho report kosam matrame idhi | ||
| Rajin Side Hero Username: Rajin Post Number: 6054 Registered: 05-2012 Posted From: 63.250.254.2 Rating: N/A |
mmeru vaadedi CR 2011 or thru Visual studio? | ||
| Rajin Side Hero Username: Rajin Post Number: 6053 Registered: 05-2012 Posted From: 63.250.254.2 Rating: N/A |
correct nenu choosthunnaa , edo 10 reports varaku chesaa, me searching if found let u know... | ||
| Coolmac Megastar Username: Coolmac Post Number: 28963 Registered: 05-2007 Posted From: 65.170.103.234 Rating: N/A |
This is just a patch-up solution, temporary... If the data is 100000 characters, we have to split it to many more parts and join... we cannot assume data will be less.. Have to prepare for something which a Clob can take, that is 2Gb. | ||
| Rajin Side Hero Username: Rajin Post Number: 6052 Registered: 05-2012 Posted From: 63.250.254.2 Rating: N/A |
kindaa meeru cheppina daani batti more than 4000 characters ante Split cheyaali anukuntaa eedu echhindhi emanna work avuthadaa never used CLOB in my reports.. http://www.tek-tips.com/viewthread.cfm?qid=1690005 | ||
| Coolmac Megastar Username: Coolmac Post Number: 28962 Registered: 05-2007 Posted From: 65.170.103.234 Rating: N/A |
CR lo Memo field ante?? is it a text object? | ||
| Andhrawala Legend Username: Andhrawala Post Number: 34865 Registered: 03-2008 Posted From: 152.51.56.1 Rating: N/A |
There is 64KB limitation on each field so u have to use Stored proc and split into multiple fields and display if the field is too big I can't say if it's an Oracle issue but for CR the Kbase article indicates: Symptom When retrieving data from a CLOB field in an Oracle database, after generating approximately 28 pages, the data gets truncated. Cause When a CLOB field is mapped in to Crystal Reports, it is treated as a Memo field. Memo fields have a 64 KB size limit. If the field contains more data, the remaining data will not be displayed in Crystal Reports. Resolution To work around this issue, use a stored procedure to split the field into 64KB segments. So it may be a Command Object limitation due to SQL buffering within CR SQL query engine. If you want this looked at by the developers then log a case on line, if it is a bug then you'll get a refund. http://scn.sap.com/thread/1798095 No Signature | ||
| Coolmac Megastar Username: Coolmac Post Number: 28961 Registered: 05-2007 Posted From: 65.170.103.234 Rating: N/A |
naadhi basic requirement: DB lo oka CLOB field vundhi... daanni techi Crystal report meedha soopinchaali... crystal template meedha ki aa clob vunna table import cheste vastondhi...but clob cannot be placed on the template... | ||
| Coolmac Megastar Username: Coolmac Post Number: 28960 Registered: 05-2007 Posted From: 65.170.103.234 Rating: N/A |
varchar can take upto only 4000char only... my clob is more than that. Either I have to split it to 4000char each...even then Clob takes upto 2GB... thousands of mukkal cheyyali varchar ithe... and mee link lo answer kanipistaledhu... | ||
| Rajin Side Hero Username: Rajin Post Number: 6051 Registered: 05-2012 Posted From: 63.250.254.2 Rating: N/A |
already vesesaraaa... ideally it should work... | ||
| Rajin Side Hero Username: Rajin Post Number: 6050 Registered: 05-2012 Posted From: 63.250.254.2 Rating: N/A |
varchar try chesaavaa, nenu DB2 ki connect chesi chesaa crystal eppudu kavalana env open chesthaaa.. nee Req correct gaa cheppu annai... asala command ee add avvatam ledu ee field vallanaa after connection | ||
| Andhrawala Legend Username: Andhrawala Post Number: 34864 Registered: 03-2008 Posted From: 152.51.56.1 Rating: N/A |
see this http://www.experts-exchange.com/Database/Oracle/Q_28205198.h tml convert those to varchar No Signature | ||
| Lax Side Hero Username: Lax Post Number: 7208 Registered: 11-2013 Posted From: 164.144.252.27 Rating: N/A |
SAP BW Bex paina create chesa crystal reports..oracle DB paina eppudu create cheyale Karimnagar Pawan Fan | ||
| Coolmac Megastar Username: Coolmac Post Number: 28958 Registered: 05-2007 Posted From: 65.170.103.234 Rating: N/A |
I hava CLOB field on Oracle 11g and need to display it on a crystal report.. Its not allowing me to drop this field directly on to the report. Do we have to convert it to something else in order to use it for display? I tried to_char in the command but failed due to the length of clob is more than 4000char. Any suggestions? |
