Search results for query: *

Oh i forgot CR ver 10

Hi all, I was wondering how to suppress a default description field that will always have data where there is a alternate longer description available on some of our items than the default one. So on some items it’s like this 1111 default 1111111 extended description but another...

Well actually the state does not a have a place anywhere in the report. I created a grouping off the state field in one of the data sets, but didnt stick state in the report anywhere just let the grouping insert the state abreveation before each group. So my first group has no abreveation just...

thanks for responding it tells me the formula result must be a string and puthe the cursor in front of the word not. Im using version 8.5 if that helps

Hi all i created a report that groups by state the only problem im having is that its reeturning the records with no state in them too. How do i tell it to ignore the customers with no state entered in it when i do the grouping.

worked great thanks a lot

im not quite sure i understand that formula could you expand a little here is what i got so far tonumber(replace{@leftaccount} then im a little lost.

thanks worked great

ok stupid question but do i creat 3 different formulas cause the string is all one field xxxx-xxx-xx.

i love you man heheh thanks a lot

hey im sorry that was for version 9.0 here is a link to a pdf since your on 7.0 http://support.businessobjects.com/communityCS/TechnicalPapers/scr567_datetimefunctions.pdf Sorry about that

Create the following formula: //Replace 1.38 with your number or number field NumberVar nbrTime := 1.38; NumberVar nbrHour := Truncate(nbrTime); NumberVar nbrHold := (nbrTime-nbrHour)*100; nbrHold := (60*nbrHold)/100; NumberVar nbrMinute := Truncate(nbrHold); nbrHold:=...

Good morning all, ok im trying to convert a string to a numerical value. The problem I am having is that the number has 2 dashes in it. Example and this is always the same 0500-010-95. Is there any way i can change this to a number value so i can create a grouping. The first set is the main the...

Thanks for all the help it tells me a string is required here and it puts the cursor right after case and befor the 0

i dont have the cr help file lol it was never installed and out 8.5 disk is missing its so fun

hope this helps To display and group records from the current and previous quarter, complete the following steps: 1) On the 'Insert' menu, click 'Parameter'. Create two numeric parameter and name them 'Quarter' and 'Year'. 2) On the 'Report' menu, click 'Edit Selection Formula', then...

I have a field that return a numerical value 1 thru 12, each number represents a company i.e. 0 = Best Way, 1 = U.S. Transportation. How do i tell C.R. to replace the Number with the text field. The text is not anywhere in the database so i was hoping i could just create a formula and tell it...

make sure i did it right the table that has the customer prices in it is our sales order form it only has some item number and descriptions the other table has all of our item numbers and descriptions so i seleted the link and chose left outer. The table with our prices is the one im trying add in.

I tried that and now when i hit the preview pane it just locks up grrr. But thank you very much

Hi im trying to get two different prices on the same report every time i preview it after ading the second data set all i get is a price of 0.0. the two data sets are linked bt item number and description. One data set has the price the customer pays, and the second has the price we pay...