Search results for query: *

In the record selection that is.

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

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

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.

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

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)

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

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

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

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

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

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

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

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