Search results for query: *

Maybe I found a way but I'd like to avoid it. Since it's an report for export (in excel sheet) I could change the grouping and have only one group, the date (showing every month). Then I could create as many formulas as the combination of the two previous groups: Region and Category. So if I...

I tried to but it threw an error because of the magnitude of data. I used left outer join and connected the two date fields. (Right?)

Hello all, I suspect that a solution must have been shown elsewhere but I only see issues for charts and cross tabs. I want to create an export report and I have 3 groups, 1.Region, 2.Category and 3.Date and I want to show total hours. I'm grouping the dates to be shown per Month. This export...

...i guess silence equals no?

ok, forget my previous post, i'm just gonna export the report to excel so no problem. But i have another issue. Can i have on the end right of the report, the total of DF, CM per equipment? like: january february TOTAL DF CM...

Hello everyone, I have a crosstab with one row (equipments) and two columns (month and job type). The results appear fine, no problem with that. But the results doesn't fit in a A4 page. (there are 12 months is here! lol) So i would like to position the row total of the month under the row, not...

well, that would help if i wanted to print only one or two records. The thing is that i want to print all the records, but with a different sorting. The sorting will be configured from a formula that it's already in the details section. That's why i can't sort from this formula, it's a...

...i'm using crystal 2008

Hello everyone, i'm sure that the title doesn't make any sense so this is what i want to do: if i place a field in the details section it will show the data oof the table.. record number field 1 field_A 2 field_B 3 field_C 4 field_D ... etc Is there a function that i can select the 3rd, or...

Hello everyone, i have a big formula with many variables (booleans, strings, datetime, numbers) and i would like to monitor the values of the variables. is there a way to see that? (when the formula crashes due to an infinite loop, the values of the variable are shown) Thanks!

found it! i already had a second group in the subreport. so, i placed the data of the report footer on the GF2 and i conditionaly suppressed it with "not onlastrecord". I had alredy ticked the "keep group together" of the group 2 and voila! problem fixed! I hope i helped someone facing the...

So yeah, i've also done the trick with the fake page header (whileprintingrecords; "") ..but what happens when the subreport reach the report footer(of the subreport) when it has changed page? ie. ------------------ <-this is the beginning of the page GH1 (pseudo page header) details details...

Hello everyone, I've inserted an OLE Object in the report and I have linked it (through graphic location etc) with a URL {field}. But, as you know, when you insert an OLE Object, you have to insert a default file or image.(am i right?) The OLE Object is placed in the details section and every...

it doesn't show headers and footers either..

...too quiet in here! does that mean that it can't be done?

Hello everyone! I'm using CR2008 and i'm trying to insert a word document to the report footer. I've tried Insert->OLE Object but crystal seems to support only up to one page word document. I've also tried to convert the word to *pdf (one page per section - Report footer A has the first page and...

I tried this and again the result was 23. An I think is normal as this function uses the whole date field

Hello, I have two datetime fields like 01/01/2013 10:00 and 02/01/2013 09:00. Even if I created two formulas with their timevalues, when I am trying to take the result 09:00 - 10:00 I took 23 instead of -1 (seems like the result is taking the whole field) Is it possible to have the -1 as a...

I have hte following command: SELECT 'ISIT' as TYPE, ISIT_ISSUE_DATE, ISIT_ITEM, ISIT_ISSUE, ISIT_QUANTITY, ISIT_VALUE FROM ISSUE_ITEM UNION SELECT 'RCIT' as TYPE, RCIT_LAST_UPDATE, RCIT_ITEM, RCIT_RECEIPT, RCIT_QUANTITY, RCIT_VALUE FROM RECEIPT_ITEM ORDER BY ISIT_ISSUE_DATE that is working...

Hello, Here is a thing. I need to have a chart with a value per month year. The problem is that the chart columns are not appearing sorted by the date but as their names. For example for a date space 01/11/2011 - 01/02/2013 I need to have the following: 11/2011 - 12/2011 - 01/2012 - 02/2012...