Instead of a join you might be able to get a larger record complex and then filter down on those items being equal. Depending on other factors (overall size of complex, number of tables, reducing complex size via a key) performance might be really poor but then RB could handle the rest without resizing in DB. Might be worth trying if you already have an RB report close to what you want and see how performance is using filtering.
-Todd C.
-----Original Message-----
From: kmailloux1959 [mailto:kmailloux1959@...]
Sent: Monday, July 28, 2003 1:14 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: ODBC and Character01
May have to resize then. Tried using RB but one of the joins I need
uses a floating point numeric to an integer numeric. RB does not like
this at all but Crystal (ODBC) is more forgiving.
Anybody else got an idea?
-Todd C.
-----Original Message-----
From: kmailloux1959 [mailto:kmailloux1959@...]
Sent: Monday, July 28, 2003 1:14 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: ODBC and Character01
May have to resize then. Tried using RB but one of the joins I need
uses a floating point numeric to an integer numeric. RB does not like
this at all but Crystal (ODBC) is more forgiving.
Anybody else got an idea?
--- In vantage@yahoogroups.com, Sue Howard <sueh@i...> wrote:
> The two options we have used are:
>
> 1.) Change the size of the field in the database to less than 256.
(Epicor
> can give you the instructions). However, if you re-index it will
reset to
> the original size so you'll have to remember to change it again.
>
> 2.) Write the report in Report Builder. It seems to be able to
handle the
> memo/blob fields.
>
> Sue Howard
> Information Specialist
> Image National, Inc.
> (208) 287-1904
> sueh@i...
>
> -----Original Message-----
> From: kmailloux1959 [mailto:kmailloux1959@y...]
> Sent: Monday, July 28, 2003 10:51 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] ODBC and Character01
>
>
> I need to filter on a Character01 field in Crystal (APInv). I can
add
> the field to a report but when I try to create a filter or formula
> field using Character01 it is not available for selection. I
realize
> it has to do with the format/length of the field. I remember using
a
> workaround for this but can't seem to remember what it was. Getting
> old is a bear......
>
> Any help would be appreciated.
>
> Thanks
>
> Keith
>
>
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://rd.yahoo.com/M=244522.3512152.4794593.1261774/D=egroupweb/S=1705007183:HM/A=1595056/R=0/SIG=124bf4lrb/*http://ashnin.com/clk/muryutaitakenattogyo?YH=3512152&yhad=1595056> Click Here!
<http://us.adserver.yahoo.com/l?M=244522.3512152.4794593.1261774/D=egroupmail/S=:HM/A=1595056/rand=978224706>
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]