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!

Register Log in
  • Congratulations derfloh 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: *

  • Users: campia
  • Content: Threads
  • Order by date
  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

    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 (...
  7. 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...
  8. 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é
  9. 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é
  10. 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...
  11. campia

    CR XI - evolution formula

    Hi, I'd like to create a report where I can see the evolution of the total of tickets per month in a bar chart. 56 65 54 jan fev mars ... Any idea? Thanks André
  12. campia

    ISS Error message when saving rtp file

    Hi, I use CR version 11.0.0.895 Sometimes when I create a new report and I try to save it I have the message: "Failed to save document". Even if the document already exists sometimes after editing the document I have this message. If I try to save it with another name then I see the...
  13. campia

    XI - question message error

    Hi, I'm trying to group two fields in one and to rename it. I use this formula, but I have the error: "The special variable Formula must be assigned a value within the formula" . What it means? Dim var If {CTSTICKET.TICOMPANY} = "MIC" or {CTSTICKET.TICOMPANY} = "MIC-MOVE" Then var =...
  14. campia

    XI - formula question

    Hi, To find out how many days I needed to solve my ticket, I use this formula: Select Case DateDiff("d",{Object.Creation Date}, {Object.Solved Date}) Case 0 formula="Same Day" Case 1 to 5 formula="1day-5days" Case 5 to 10 formula="5days-10days" Case 10 to 15 formula="10days-15days" Case 15 to...
  15. campia

    XI - problem to create report

    Hi, I need to create a report that shows me the solved incidents: same day 1day-5days 5days-10d 10-15 15-20 +20days How can I create this kind of report, any idea? Thanks in advance. andré
  16. campia

    CR XI - formula to calculate average

    Hi, I need to calculate the average of time spend on the tickets with priority="very high" per month. In my db I have the fields: creation date and solved date. How can I do this formula?
  17. campia

    CR XI - problem subreport display

    Hi, In my mainreport I have a few subreports. For example I have a subreport that shows me the incidents created for a certain apllication "Incidents by Application". When I only execute the subreport I see the correct number of incidents from de db. However when I execute the mainreport (that...
  18. campia

    CR xi - problem display

    Hi, I created a main report with a few subreports. After entered a date period (StartDate and EndDate) I see the right result in my subreports but I have duplicates in my report...instead of having 3 pages I have more than 300 pages. Can you help me?
  19. campia

    CR xi - formula for Histogram

    Hi, I created a histogram with this formula : MonthName(month ({Table.Creation_Date})) but the months on the report are put at the bad place. I have for example: April, June, March and May...but I should be March, April, May and June. Can you help me?
  20. campia

    CRxi - Pie Chart problem

    Hi, In my report (pie chart) i see the label and the values. However the first line of the legend doesn't have a label and the value is 0....this is because in my database i have a blank line. example: 0 solved 65 in progress 14 closed 78 How can i avoid this...

Part and Inventory Search

Back
Top