Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. campia

    Upload image in a report

    On a folder i store a few logos that i would like to upload in my report depending on the value i select in my parameter field "Company". How can i do it? Thanks. André
  2. campia

    CR2008 - Report properties

    Dear, I try to set some report properties (File-Summary Info) by indicating an Author, Comments or even a Title; however as soon as i export it to a pdf file these values aren't set. Do you have an idea ? thanks André
  3. campia

    cr xi - calculate variance

    Dear, I need to calculate the variance between totals of a same period (i mean months: january, february,march...) but diferent years (2006,2007,2008). How can i do that in cr xi. I tried to use the function "variance" but i do not know really how to use it. can somebody help me please...
  4. campia

    Week number in a graph

    I use the function DatePart("ww", field) to get the week number of my date, but if i put it in a graph, i see the week number in the x axis but in the following format: 1,00 2,00 3,00 how can i skip the ",00" part? i checked the options of the graph and do not find it. André
  5. campia

    ShiftDateTime issue

    Dear, I receive from an external database the registration date GMT+1 and the real date is -1. I tried to change it via the function ShiftDateTime but i get an error. I tried like this: SchiftDateTime({field_date},"GMT+01:00",GMT) example: i get : 09/12/2008 17:00 -> but it must be...
  6. campia

    CR XI - round value issue

    ok you were right it works now... thanks André
  7. campia

    CR XI - round value issue

    amazing... i still have the same problem.. it shows 68,03 and not 68,04 André
  8. campia

    CR XI - round value issue

    i have already tried that and also the roundup function... but i have always the same error André
  9. campia

    CR XI - round value issue

    Hi, I have issue by rounding a value with 2 digits but not with 3 digits after the ".", I show you what I have: 29,375 => 29,38 38,656 => 38,66 ------------------- 68,031 =>68,03 (that's wrong because if you calculate it, the correct total should be 68,04) I tried the 'round' function (...
  10. campia

    cr xi - space issue

    Hi, In my report I have a group footer however some times some data is put on the bottom of the page on the rest (only one extra line) is put at the top of the new page. I have already tried to play with the line spaces but it doesn't work because it depend always on the amount of data...
  11. campia

    SQL installation on a Windows Server

    Hi, I need to install a SQL Server 2000 on a Windows server 2003. However, should I install the SQL server directlly on the WS server or should i install it on a VMWare on the server? Regards. André
  12. campia

    xi - extract sum from a date period

    do you have an email address maybe that i can use to send you the report and then i'd be able to explain the calculation i'm trying to do ?? andré André
  13. campia

    xi - extract sum from a date period

    in my report i have fields: intervention date responsible effort time description At the end of the month I can follow the different activities from the users and their time effort. After that I use a cross-tab to see the end result like the intervantions per user and the total of minutes...
  14. campia

    xi - extract sum from a date period

    Ok thanks... however i still do not have the result I'd like... What i'm trying to do is a formula to calculate the total of minutes spend for the year... At the end of the month I have in a cross-tab a column with the total of minutes spend for the month. Let's imagine at the end of this...
  15. campia

    xi - extract sum from a date period

    if {Object.Customer_Title} = "Test1" or {Object.Customer_Title} = "Test2" then Local NumberVar TMin_beginContact := 1680; Local NumberVar TMin_used ; Local NumberVar TMin_beginMonth; if month(currentdate) = 1 then TMin_used := TMin_beginContact / 60...
  16. campia

    xi - extract sum from a date period

    Hi, In a cross-tab I have a Total of minutes per moth (I enter a date period). Is it possible to store this total in a field because I need to calculate with this total? I tried this: Local NumberVar x x:= Sum ({Object.Grand_Total}) in {?StartDate} to {?EndDate} Thanks, André André
  17. campia

    XI - Shared values in a main report

    I'm trying to share values in two subreports and to use them in my main report. I created two formulas in each subreport and I store the value I need. The formulas works on the subreport because when I change my parameters fields the value changes. In the main report I want to add the two values...
  18. campia

    CR XI - evolution formula

    so if I put ToText(CDbl ({CTSTICKET.TICREATED}),"MM MMMM") i have an error saying me:"The string is non-numeric" I also tried the ToNumber and it's the same... André
  19. campia

    CR XI - evolution formula

    I do not have the sum option. My db fields have all the "text" type. André

Part and Inventory Search

Back
Top