Search results for query: *

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é

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é

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...

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é

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...

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 (...

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...

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é

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é

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...

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é

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...

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 =...

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...

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é

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?

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...

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?

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?

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...