Count of String Types

[awise]

This is probably very simple, but I'm having trouble with this. I started using CR 1 week ago

I'm trying to make a report that will show data on Web Reports usage by out-of-office sales people. The fields are Date, UserID, Total Reports Run (count), and then an itemized count of the reports that were run, listed by the report. I've got the First two, but the third criteria formula gives me an error of "Blob field or memo fields not cannot be used in formula." I'm getting a bit confused is all, if someone could point me in the right direction, that would be great. Below is the formula giving me the error:

{exmaster.Col004} = {?UserID} and
not ({exmaster.Col008} in ["/reports/crystal/vvitale/default.htm", "/reports/crystal/tferrero/default.htm", "/reports/crystal/skarroum/default.htm", "/reports/crystal/rsnyder/default.htm", "/reports/crystal/mwatman/default.htm", "/reports/crystal/mwalter/default.htm", "/reports/crystal/jmosko/default.htm", "/reports/crystal/jbiocca/default.htm", "/reports/crystal/llavinson/default.htm", "/reports/crystal/mschmitt/default.htm"]) and
{exmaster.Col001} = {?Date Range} and
not ({@column 008} in ["/forms/Road+Show+REQUEST+FORM.doc", "/forms/Promo-Free+Goods.doc", "/forms/AExpRptE.xls", "/ashtonlogobig.jpg", "/default.aspx", "/files.gif", "/files-c.gif", "/forms/", "/forms/aexprpt.xls", "/mail.gif", "/mail-c.gif", "/reports.gif", "/reports-c.gif"])

Thanks

 

[awise]

BTW - this is the "new guy" at the company writing, not the IT manager!! Don't want to tarnish his reputation!!!

David

 

[Ngolem]

you haven't shown us the formula in question but it sounds to me that you are trying to use a Blob or Memo field in a formula somewhere. This is not allowed as you have a 254 character limit to the size of a string that can be manipulated in a formula....This may have changed in the newest CR report version but definately is the case in version 8 and less Jim Broadbent

 

[Naith]

Ngolem's correct, David. This field: ({exmaster.Col008} is a Blob field, it looks like. You won't be able to use all the *.htm criteria in your formula.

Naith