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 Chriss Miller 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. thebigbadwolf

    Export report - Group per Date(months) and display all months even will null values

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

    Export report - Group per Date(months) and display all months even will null values

    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?)
  3. thebigbadwolf

    Export report - Group per Date(months) and display all months even will null values

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

    Cross tab. Position row total in next column

    ...i guess silence equals no?
  5. thebigbadwolf

    Cross tab. Position row total in next column

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

    Cross tab. Position row total in next column

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

    Bring specific field from record number

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

    Bring specific field from record number

    ...i'm using crystal 2008
  9. thebigbadwolf

    Bring specific field from record number

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

    monitor variables

    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!
  11. thebigbadwolf

    Page Header on subreport (...again)

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

    Page Header on subreport (...again)

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

    Link OLE Object without the default picture

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

    Insert word file to report

    it doesn't show headers and footers either..
  15. thebigbadwolf

    Insert word file to report

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

    Insert word file to report

    ...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 Report footer B has the second page...), but when i export to pdf, the pdf...
  17. thebigbadwolf

    The result between two timevalues taking also the is not possible

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

    The result between two timevalues taking also the is not possible

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

    Make a joined sort of two different (but same type) fields

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

    Sort a month year chart by date

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

Part and Inventory Search

Back
Top