Search results for query: *

The following formula will remove the last two digits and dash from the Material Code which will allow you to compare it to the ID //{@MaterialCode} Mid({Part.Material_Code},1,(length({Part.Material_Code}-3))

This formula should remove all blank spaces and remove the last two characters. //Replace {Table.PostCode} with your field. Mid(Replace({Table.PostCode}, " ", ""), 1, Length(Replace({Table.Postcode}, " ", ""))-2)

Check out thread 767-1012607 titled Easy Grouping Question http://www.tek-tips.com/viewthread.cfm?qid=1012607 It explains grouping in clusters by creating a formula like: if {VP_PERSON.HOMELABORACCOUNT} in ["536","456"] then 1 else if {VP_PERSON.HOMELABORACCOUNT} in ["444","577"] then 2 else...

You will need to use the &nbsp; character for spaces to be recognized by HTML. This will add 4 spaces after bold "REnumber" "<b>RENumber</b>&nbsp;&nbsp;&nbsp;&nbsp;"

Take a look at: thread767-1025199 Format text in formula??? http://www.tek-tips.com/viewthread.cfm?qid=1025199 You can use HTML tags in your formula for bold text: "<b>RENumber</b>" Then you have to format the formula->format field->paragraph formatting->text interpretation->HTML text.

RobNauticus, Here is another option if you do not have a table containing all dates. Take a look at lbass's post in thread767-526332 stamped 20 Jul 03 17:46 Thread title: A real puzzler - displaying database 'gaps'...... thread767-526332 http://www.tek-tips.com/viewthread.cfm?qid=526332 It...

I was reviewing the new features of Crystal 11 and saw "Dynamic Image Location" which looks like it could be what you are looking for to be able to insert different company logos on the same report. http://support.businessobjects.com/library/docfiles/cps10/downloads/en/crxi_WhatsNew_en.pdf

Of course you would need to remove the surpression formula if you move the running total to the region group footer.

knerve1, You could move the running total field down to the region group footer. You would then only see the subtotal count for each region. Would this be OK, or does it have to be in the detail section?

Knerve1, Right click the running total field and go to Format Field, Common Tab / Surpress. Click X-2 and insert formula: not onlastrecord

Take a look at FAQ 767-4532 "Creating data for dates not in the data set with SQL Server SQL to create a Periods Table" faq767-4532 http://www.tek-tips.com/faqs.cfm?fid=4532

-k The loop works great! Much better than replace. Thanks

Create a formula using "Replace" to get rid of unwanted characters. The sample below will get rid of slashes dashes and blank spaces: Replace (Replace (Replace (Replace({Table.LIC_NUMBER}, "/", ""), "\", ""), " ", ""), "-", "")

There is a sample report on the Business Objects web site called "How to Display a Proper Check Box". Differnet options are shown with the WingDing char# to use. Found this very helpful. http://support.businessobjects.com/communityCS/FilesAndUpdates/cr_formattext_samples.zip.asp File Name...

Yes there is a hotfix that needs to be applied to update the excel export dll. Knowledge Base article: c2015942 Cannot set options when exporting to Microsoft Excel in the DHTML viewer http://support.businessobjects.com/library/kbase/articles/c2015942.asp

Try using this combination of the two. It should do it. ToNumber ({@Actual})< ToNumber ({@Forecast})then crred else crblack

Try this in the Font Color formula box: if @Actual < @Forecast then crred else crblack

Tom, Go to the Section Expert for the Details section. Click the X-2 for Surpression and insert this formula. This should surpress any name that has more than one detail line. next({CLIENT.ID}) = {CLIENT.ID) or previous({CLIENT.ID}) = {CLIENT.ID}

Here is a link I saved that describes what you are trying to do. I haven't had a chance to try it. http://www.ml-crystal.com/articles/calendar.htm Create a calendar-style report Need a report that looks like a calendar or month planner? Crystal can do it. By Linda Bass

Sorry. Mispelled it first time. Should be "Startswith