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

    Excel Export Help

    We have BO 12.0 and the users need to view & then export so they can input their specific parameters.
  2. ajxmas

    Excel Export Help

    I am using CR 2008 for development and using the Central Management Console to deploy to users to view with Business Objects Infoview. I created a report specifically for exporting to Excel and it works fine in my client version of CR 2008. But when I deploy it for the users to Infoview, the...
  3. ajxmas

    Report Processes Twice

    Yes, I use CurrentDate to calculate the start & end dates for the record selection. I thought that might be part of the issue after reading through some other posts. But I'm not sure if I can get around using that. The report is designed to select data for the previous 2 months, along with...
  4. ajxmas

    Report Processes Twice

    Thanks anyway LB, but that did not seem to make any difference.
  5. ajxmas

    Report Processes Twice

    HI all, I am having a strange issue. I used CR2008 to develop my report on my desktop client. Once I publish it to the Central Management Console for user access I noticed something weird I have never seen before. After the report returns the results, when I click on the arrow to go to...
  6. ajxmas

    Printing Optional/Multiple Number Parameter

    Thanks so much, this is exactly what I was trying to do. I guess I had the wrong syntax for the hasvalue when I tried it before. Thanks again for you quick response and expert help.
  7. ajxmas

    Printing Optional/Multiple Number Parameter

    I'm using Crystal 2008 with Oracle DB I have an optional number parm that can accept multiple entries. I want to print this in the header or "All" if they didn't enter anything. This formula works fine if something is entered in the parm but gives me an error when nothing is entered. The...
  8. ajxmas

    Subtotals within a Group

    Thanks so much lbass, I'll give that a try.
  9. ajxmas

    Subtotals within a Group

    Just to add, I tried including another group but that breaks up my detail section which is not what I want
  10. ajxmas

    Subtotals within a Group

    Hi all, using CR11 - Oracle DB Report Looks like this: Group 1... Group 2... Group 3 .... Issue 25.00 .... Sale 10.00 .... Issue 11.00 .... Entry 5.00 .... Sale 30.00 .... Sale 1.00 I need to add count & sum subtotals in my...
  11. ajxmas

    Displaying default text when no data available

    Hi, I am using Crystal XI with Oracle DB I have a DB field on the report that I want to put 'N/A' if it doesn't exist. This field comes from a secondary table that is linked to the primary table. So it only contains data when there is a match to the primary table. The report shows blanks when...
  12. ajxmas

    Alternate Conditional Record Selection

    Hi all, I am fairly new at this. I'm using CR XI using an Oracle DB. I have an account table I'm reporting on with data such as: ACCT ID NAME ADDRESS ZIP 0000220 COLBERT 234 XYZ LANE 20705 0009990 STATE 0000005 ZZZZZ 20943 0000005 UNION 1500 RED ST 21190 0009991...
  13. ajxmas

    Sorting a summary

    I will try this method. For clarification my groups are: Group 1: - Sorted by Service Type Group 2: - Sorted based on User entered parm (@sort) Group 3: - Sorted by sales description So Group 2 is the only group that should change sort order based the parm entered.
  14. ajxmas

    Sorting a summary

    I'm sorry, @sum amt is actually @total. global numbervar total := total + {VENDOR_SALES.AMT_SOLD} Yes, I have a current group sorted on @sort with the following formula: If {?Sort Field} = '1' then crDescendingOrder else crAscendingOrder
  15. ajxmas

    Sorting a summary

    The user enters a parameter (?Sort Field) to pick which way he wants to sort. ?Sort Field = 1(Dollar) or 2(Zip) or 3(cust name) or 4(cust #) @sort- formula: if {?Sort Field} = '1' then totext({@sum amt}) else if {?Sort Field} = '2' then {VENDOR_ACCOUNT.ZIP_BASE} &...
  16. ajxmas

    Sorting a summary

    I tried that but then my other sort options get ignored.
  17. ajxmas

    Sorting a summary

    Hello All, I am using CR XI. I'm totally new to CR. I am creating a Sales report with many different parameter and sort options for the user to select from. One of the sort options is descending by total $ sold per customer. Because of CR's multi-pass processing I cannot sort on a running...

Part and Inventory Search

Back
Top