Search results for query: *

Hi All, I'm trying to trim/replace a column down to 40 characters. I can use =REPLACE(B1,41,50,"") Which gives me exactly what i want, but it is reliant on the origional data still being available. I need some kind of way to trim/replace down to a maximum of 40 characters either with the...

Hi Folks, I have some users on Vista that are getting an error in Windows Photo Gallery when opening pictures. "Photo Gallery can't open this picture or video. The file appears to be damaged or corrupted" These pictures are deffinately not corrupt. They get the same error if opening from a...

Hi Everybody, I am currently creating a simple word 2007 template with form fields and protection on the rest of the document. I have created this but it will not work in office 2003. I have tried saving in compatability mode (As a 2003 document) without any luck. I have been doing some...

Hi All, I am trying to conditionally show a title (Taste Guide) conditionally if the taste guide field is not null on that particular page. i have tried adapting a variable count i got in a previous post. Here is what im doing currently. Page Header - @Taste guide text whileprintingrecords...

Hi All, As the title sais, is their a formulae so a running total will reset on every page? I have tried a few different things but have been unable to get this to work. Any help regarding this matter would be greatly appreciated. Many Thanks, AR CR2008 - SQL server 2005 New CR User

I have some item descriptions that have an Alcoholic volume at the end of the description. I need to supress the volume as this is being shown elsewhere on my report. But note, not all descriptions have the volume at the end so simply cutting the last 3 digits wont work. e.g. CARLING 4.0 But...

Hi Folks, Im trying to take the start of a description and put in a different field e.g. 75cl CHATEAUNEUF DU PAPE NALYS 05/06 all the descriptions have the size of the item at the beggining but i want to effectively Cut these from the desciption so i can place elsewhere on my report. The...

Hey Folks, Should be a fairly simple one here but cant get my head around it, in my head its logical :S . Here is my current record selection formulae: {Sales.DayName} = "Saturday" and ( {Sales.ItemName_P} startswith "11'" or {Sales.ItemName_P} startswith "9's" or...

Hey folks, I am currently having some trouble getting a group count. I am unsure of the best way to explain my issue, so here goes. Product Group Last Sold Count Customer A 1 a Y 2 a Null...

Hi folks, I am having trouble getting my selection formulae to show both nulls and delivery dates over 90 days for a specific product. I am using CR2008. My formulae currently looks like: {LastSold.CustomerNo} startswith "T" and (UPPERCASE(LEFT({LastSold.CustomerName}, 6)) <> 'CLOSED') and...