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 Mike Lewis 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. Corres

    Report has prompt to select Report Name

    Dear Lbass, Smart simple solution, it works well. Thank you very much! Great to hear from you in five years here. :)
  2. Corres

    Report has prompt to select Report Name

    Hello, Starting with SAP BO Crystal Reports for Enterprise. Please give me idea how to update existing report in the way the client wants. The client wants to have a report prompt where the user will choose Name1 report or Name2 report to be displayed. Name1 is the existing report. Name2 is the...
  3. Corres

    How to insert subtotals after every 24 records?

    It can be actually 25. The data with subtotals has to be then placed in special templates that allow a limited number of rows.
  4. Corres

    How to insert subtotals after every 24 records?

    CRXI Hello, Please give me idea how I can insert subtotals after each 24 records of the report? Thank you for your time!
  5. Corres

    First day of the month that previous to lastfullmonth

    Thanks once again Pete, it works well. I have used it to modify other formulas as well. Cheers!
  6. Corres

    First day of the month that previous to lastfullmonth

    Thanks Pete for your time! I believe it should work. I will let you know tomorrow! Cheers,
  7. Corres

    First day of the month that previous to lastfullmonth

    CRXI I need to remove parameters {?Year},{?Month} from the report and use lastfullmonth function to run and distribute report in InfoView. I have the following selection formula in one of subreports which displays data for selected month plus the previous month (2 month range)...
  8. Corres

    How to force a group with 0 records appear in the report?

    CR2008, Oracle 10 The client wants to see the groups with 0 records appear in the report. I was trying to insert a query in the command line containing all values of the group and then link them. But it does not work. Please give me idea how to do it. Thank you very much!
  9. Corres

    Custom colors in chart are changed to default colors in InfoView

    SAP BusinessObjects Enterprise XI We have some reports with the charts where the Color Highlight feature with custom colors is used. The feature works perfectly when the reports are displayed in Crystal designer and exported to PDF. When the report is placed in Infoview, the colors of the chart...
  10. Corres

    Hello, CR2008, Oracle I need he

    That exactly what I need, thank you so much!
  11. Corres

    Hello, CR2008, Oracle I need he

    Hello, CR2008, Oracle I need help with a string formula. Example of Data: SART EXIT - Dave, Lisa - 2012-03-09 EX- SART - WUERCH - DEC 9, 2011 FIPD PERM 1 EXIT - Robert Yfdfhiuki - April 11 2011 FIPD PERM 1 EXIT - Rob Zfduuya - April 82011 Results Needed: 2012-03-09 DEC 9, 2011 April 11 2011...
  12. Corres

    Calculate time working with incident

    Thanks very much Ian! I do not have much experience with command line, I will try now and let you know how it is going.
  13. Corres

    Calculate time working with incident

    Thank you very much, Madawc for your reply! I appreciated it very much. I cannot group by Person because persons from different departments can work on the Incident as well. I added colors to make more readable. The Incident ( here inc_id = 898) can be assigned (assigning occurs when type_id...
  14. Corres

    Calculate time working with incident

    CR 2008, Oracle Dear specialists, Please give me ideas how to accomplish the following: The report has to be grouped by INC_ID and has to display for department 99 - length of time and person working with incidents: INC_ID DATE_RECEIVED RESPONSE_TIME TOTAL_TIME PERSON 898 04/06/2012 14:29 218...
  15. Corres

    How to create parameters that affect both subreports

    CR2008 I have a main report that is not connected to the database. The details section_a contains 1 subreport, details section_b contains the second subreport. The reports are not linked to the main report. Both subreports connect to the same database. The user asks to create parameters to...
  16. Corres

    First and Last Name in Parameter

    CRXI Can I use two fields in parameter first and last name, if these data are separate fields in table? Or Can I use simple formula as a parameter? Thanks.
  17. Corres

    .gif file logo does not display!?

    CRXI I have to insert logo - .gif file, but it give me message this file is not supported. I tried to save it as .jpeg, .jpg, .png file, but it gives me message that file is not supported. I simply opened this .gif file, copied and pasted in my Crystal Report, and it displays OK. But when I...
  18. Corres

    Array in Parameter

    CRXI, SQL Server. My user wants to choose multiple projects. In the parameter Value Options, I chose Allow Multiple Values. My Record selection Formula is: if {?ProjectID}>0 then {EntryLog.ProjectID} = {?ProjectID} else not isnull({EntryLog.ProjectID}) But it gives error: The array must be...
  19. Corres

    How to display a string of selected numeric parameter?

    Thanks very much LB, I gained so much knowledge from your sharing!

Part and Inventory Search

Back
Top