Re: Field size with ADO.NET (XML)

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: John (jkraeck_at_NOprincetonSPAM.edu)
Date: 08/06/04 

Date: Fri, 6 Aug 2004 09:00:28 -0400

Well, the problem is in the Crystal KB
(http://support.businessobjects.com/library/kbase/articles/c2010386.asp) and
the tracking number is ADAPT00049953.

I do not suppose that it is likely that "Business Objects/Crystal Decisions"
is going to fix this any time soon since the article was created 2001/11/26
and published 2002/01/17. Way to go Crystal, good customer support there.

Pity, since the use of datasets for reports is such a fundamental use for
the tool. I will be recommending that our third party developer use a
different reporting engine.

Regards,
     John

"John" <jkraeck@NOprincetonSPAM.edu> wrote in message
news:OHdaqTmdEHA.1652@TK2MSFTNGP09.phx.gbl...
> We have a third-party application that is using ADO.NET (XML) datasets
with
> crystal reports, that is consistently running out of memory when we run
> reports on datasets of any reasonable size. The reason, apparently is that
> Crystal reserves 65534 bytes for every attribute typed xs:string...I
thought
> that this could be resolved by adding simple types based on xs:string with
a
> length facet to the xsd file, but that does not stop the behaviour. The
> fieldsize is still 65534 in crystal.
>
> If you figure 10 fields or so, and 1000+ records, then it is pretty much a
> forgone conclusion the application is going to throw an out of memory
> exception. WTF, I thought Crystal is supposed to be an enterprise
solution.
> What rocket scientists thought up this default?
>
> The dataset is created from various sources, not all of which are
databases,
> so we really do not have an alternate method.
>
> Has anyone else run into this one, and if so, is there a solution.
>
> Thanks,
> John
>
>

Relevant Pages

  • Re: Saving Word Documents to Network Drive
    ... Thanks John - I guess it's just our rotten luck. ... I would expect to be swamped with reports in here if everyone was getting ... Word 2004 with all latest software updates ... McGhie Information Engineering Pty Ltdhttp://jgmcghie.fastmail.com.au/ ...
    (microsoft.public.mac.office.word)
  • Re: RoomCap Antenna
    ... 20:10 DJ6YF, 59+10, Hans, Bielefeld ... 20:17 G4KHM, 57, John, nr. ... 21:11 SP8TDV, 57, Adam, Lublin, Poland ... The reports are pretty lackluster I'd say... ...
    (rec.radio.amateur.antenna)
  • Re: John and his dares
    ... I am not aware of John allegedly doinig "just about any dare." ... time when the Beatles were known as 4 cute loveable mop tops. ... read the book (which I think is in German) but it is a book of Bruno's ... He reports in his book that of all the entertainers he dealt ...
    (rec.music.beatles)
  • =?Utf-8?Q?Re:_Determining_control=E2=80=99s_positi?= =?Utf-8?Q?on_on_a_report?=
    ... Thank you so much John, this is exactly what I was needing. ... the simplest way to determine the page number is to use the reports ... If there are a LOT of controls, you can loop through ALL the controls and move ... the sub reports, in a group footer, I have the remainder of the letter and in ...
    (microsoft.public.access.reports)
  • Re: RoomCap Antenna
    ... Yes but after we shoot the bull the barbecue is so much fun! ... 20:17 G4KHM, 57, John, nr. ... 21:11 SP8TDV, 57, Adam, Lublin, Poland ... The reports are pretty lackluster I'd say... ...
    (rec.radio.amateur.antenna)