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

    Recommended Training For XI Java Customisation

    Hi, I have just inherited a project to migrate/upgrade our CE10 installation to BOXI-R2 (or R3 if it comes out soon enough.) Our CE10 environment is very heavily customised with lots of bespoke CSP scripts to do things like carrying out "DB password pass-through", "fake-on-demand", "report...
  2. horatiog

    Dymanic LOVs For Parameters & Server Side-Filters

    Hi, I have been tasked to migrate our CE10 implementation (some 300+ reports) to BOXI R2 running on MS Server 2003. We chosen to implement the Enterpise Server in Java (Jakarta Tomcat) as we may be moving to a non-MS platform at some point in the future. Part of my remit is to introduce what...
  3. horatiog

    [color green]Green Text[/cMy customer wants "all" in param values.....

    Hi, If its in the record selection formula, I think you can simplify this even further: ( {?Status} = "All" or {workorder.status} in {?Status} ) and ( {?Technician} = "All" or {workorder.leadcraft} in {?Technician} ) and ( {?Worktype} = "All" or {workorder.worktype} in {?Worktype}...
  4. horatiog

    Grouping Based On A Maximum From A Subordinate Group

    Hi LBass, Thanks for that great reply and sorry it took so long to get back to you. I got dragged into a lot of support work for the last week or so and have only now got back to this report. Also, apologies for not including the whole hierarchy of formulae - I now see why you would want this...
  5. horatiog

    Grouping Based On A Maximum From A Subordinate Group

    Hi LBass, Yes it is a '?' - the result is a string from the following formula: If IsNull({@Margin Value}) Then '?' Else if {@Margin Value} > 0 then 'y' else 'n' {@Margin Value} is a numeric value that is NULL if any of the source columns that are used in its...
  6. horatiog

    Grouping Based On A Maximum From A Subordinate Group

    Hi Running CR10 on Windows XP. I have a requirement to produce a report based on whether we can propose one or more opportunities to our clients based on whether the client/opportunity combo meets cetain a requirement which itself is determined by a cut-off level supplied as a parameter...
  7. horatiog

    "Limits" Option Not Archving Instances In CE10

    I was speaking to some colleagues on Monday and they seem to think that history is only ever archived on a user by user basis, so the rules are only applied to a specific user's history for a specific report when that user runs that report. Our experience seems to be bearing this out in that we...
  8. horatiog

    "Limits" Option Not Archving Instances In CE10

    Hi, Running CE10 on Windows 2000. We ran out of space on our production server yesterday. We are considering buying a bigger disk but in the meantime I urgently needed to get some space back. Stopping & restarting the services and some judicious culling of spurious files on the disk yielded...
  9. horatiog

    Determine The Parent Group From Which A Drilldown Was Called

    Hi Ido, We user CR to develop the report but its deployed on a CE10 implementation and the users use the ActiveX plugin to view their generated reports. Regards, Harry.
  10. horatiog

    Determine The Parent Group From Which A Drilldown Was Called

    Hi Ido, Thanks for the suggestion but, as a company, we have elected not to use subreports. The reason for this is that when looking back at a report that has been run some time in the past, you see the data as it is was when report was first run. However, if you then drilldown into a...
  11. horatiog

    Determine The Parent Group From Which A Drilldown Was Called

    Hi, Running CE10 on Windows 2000. I have a quite complex report with 6 grouping levels. The user has specified that at the drilldown for Group4, to show all the Group5s under the Group4 headers, thus: Group4 #1 (Header) Group5 #1 (Footer) Group5 #2 Group5 #3 Group4 #2 Group5 #4...
  12. horatiog

    Cannot Drilldown From Repeated Group Header

    Hi, Running CR10 On XP Pro SP2 & CE10 on Windows 2000. I have designed a report which a user has subsequently logged an issue with. The report lends itself to drill-downs from the report headers. This works fine in CE & CR for the most part. However, if you have a group that splits over more...
  13. horatiog

    Can CE10 Hyperlink Use Same Window Report Was Called From

    Hi Andrew, Thanks for getting back again so quickly. Hmmm; not sure how I can implement your code here. When I am designing my report, I am going into "format field" for the field I want to hyperlink back to Salesforce from, and then selecting the "Hyperlink" tab. I am selecting "A Website On...
  14. horatiog

    Can CE10 Hyperlink Use Same Window Report Was Called From

    Hi Andrew. Thanks for the feedback. I'm a bit of an HTML noobie and was wondering if you be more specific how to implement this. If you are suggesting that I modify the hyperlink back to Salesforce from CE10, then I can concatenate something onto the back of the link string, e.g...
  15. horatiog

    Can CE10 Hyperlink Use Same Window Report Was Called From

    Hi, Not sure if this is a CE question or an IE6/Firefox question or a Salesforce question or a combination of one or more of these...but here goes in the CE section to start with! Hope somebody can help with this request that our UAT group passed to me. We are running CE10 on a Windows 2000...
  16. horatiog

    Business View Problem - Last Completed & Next (Over)Due Activity

    Hi, Hope you can help here. I have a requirement to write a business view from a table of Activities (ACTIVITY), to determine the next due (or overdue) activity and last completed activity for each pair of who & what entities. Simplified, the structure of the ACTIVITY table is as follows: ID...
  17. horatiog

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

    Hi SynapseVampire, Thanks for that. When you say "it should use what was set when you scheduled it", do you mean when it runs on a scheduled basis, or when we run it via the "Run Now" button or in both cases? I take it InfoView is a 3rd party product? In that case we would not be allowed to...
  18. horatiog

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

    Hi, Hope you can help here. Configuration: CE10 running on Windows Server 2003. I have set up a Recurring Instance from the "Schedule" tab after having first setting my parameters to the default values that I require for this recurring instance. (Using the "Process | Parameters" tab.)...
  19. horatiog

    Find A Parent on an Oracle "Tree" Table Based On A Compound Key

    No worries. Enjoy your bash. Hope to hear from you when you have a moment. Thanks & regards, Harry.
  20. horatiog

    Find A Parent on an Oracle "Tree" Table Based On A Compound Key

    Hi Mufasa, Thanks for your reply. The primary key on this table is GMAID. However, I don't THINK I can use this column to form a relationship between the two levels of the query and instead I have to use the unique composite key of GMMCU + GMOBJ + GMSUB. The parent for any row in the table...

Part and Inventory Search

Back
Top