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

    How to set parameter value to "All"

    In the record selection that is.
  2. pgevaux

    How to set parameter value to "All"

    ({?ParameterName} = "All" or {Table.Field} = {?ParameterName}) This is what I use. Regards Phil
  3. pgevaux

    Exporting subreports to excel

    http://technicalsupport.businessobjects.com/KanisaSupportSite/search.do?cmd=displayKC&docType=kc&externalId=c2017620&sliceId=&dialogID=23920741&stateId=1%200%2023924148 This is the kbase. The best suggestion it makes is to bring the other fields of the main report into the subreport via shared...
  4. pgevaux

    CE, Scheduled Instances, Parameters & The "Run Now" Button

    Business Objects XIR2 has the ability to reschedule existing jobs within the Infoview. Remember that CE10 goes out of support in Feb 2008 so you want to start migrating.
  5. pgevaux

    To add a subreport

    Just extend the size of your report footer so that it takes up a whole page. Why do you want to use a subreport for this anyway? If there is no linked data from the main report then just build the disclaimer with text objects etc. in the report footer. I've learnt to avoid subreports wherever...
  6. pgevaux

    Name format

    Just realised that this formula will fail if there are any NULL values in the field. To get around this use: stringvar name := trim({fullnamestring}); if length(name) = 0 then " " else right (name, length(name) - instr(name, ",")) & " " & Left (name, instr(name, ",")-1)
  7. pgevaux

    Name format

    Just a simple one by I thought I would share it because I couldn't find an answer as simple as this one that I created. I wanted to change the name format of a string field from 'surname,firstname' to 'firstname surname' Existing {fullnamestring}: Smith,John What I wanted: John Smith This is...
  8. pgevaux

    Removing decimal places from X Axis of chart in version 10

    I knew there must be an easier way. Thanks for sharing it. I'm still a novice at formulas, and this forum is my lifeline. Regards Phil
  9. pgevaux

    Removing decimal places from X Axis of chart in version 10

    After some testing I realise this doesn't work. Sorry for the previous thread. You cannot use shared variables at chart processing level apparently. This formula below does work. I don't know why I was trying to use a variable when it wasn't needed. // This formula basically strips off the...
  10. pgevaux

    Removing decimal places from X Axis of chart in version 10

    In version 10 of CR it isn't easy to format the x-axis of a chart. I don't know why. I think in XI you can with the chart expert. How I got around this was to create a formula and base the x-axis of the chart off it. This is the formula I created: //START OF FORMULA // This formula...
  11. pgevaux

    Excel Export

    You're still using version 8???? I believe Business Objects will still sell you Crystal Enterprise 8 for next to nothing, as it is now unsupported and years old. CE offers the functionality to automatically distribute your reports instances to Excel and other formats. I don't think there is a...
  12. pgevaux

    Bar Chart Formatting

    I want to know how to conditionally format a bar chart so that the colour of the bars correspond to the value. For example, I want the top three values to be gold, silver, and bronze (or colours similar). I don't want this formatting to be static. Each week the top three could change...
  13. pgevaux

    Is it possible to run from a command line

    There is no way you can do this I'm afraid. Business Objects makes sure you can only use their report distribution tools (Crystal/BO Enterprise) to achieve automated report distribution. Phil
  14. pgevaux

    Dynamic cascading prompts in CR10

    I know that dynamic cascading prompts are not something available in Crystal Reports until version XI, but I believe there may be a way to create a workaround using Business Views (in version 10). Please let me know if you have any information that would help. Any samples or theoretical...

Part and Inventory Search

Back
Top