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

    HasValue causing errors with 3rd party viewers in CR2008

    !!!!Resolved!!!! :-) Easy View 3 now supports Optional Parameters in CR 2008. Peter.
  2. pandpp

    HasValue causing errors with 3rd party viewers in CR2008

    Hello all. I have a number of reports I am developing, which all work brilliantly in CR2008. I am only using an Eval copy at this site, but feel certain that's not the issue. The DB is Sybase, but don't think that's relevant here either. Using CR2008 & having the option of using Optional...
  3. pandpp

    Landscape AND Portrait in CR 2008

    Thanks LB, spot on. On the Paging tab in Section Export, bottom of the tab, there's a section titled Orientation. In there you have 3 options, Default, Portrait & Landscape. So, all that is required is to put each sub-report in a separate section, then change the orientation of each section...
  4. pandpp

    Landscape AND Portrait in CR 2008

    Hi there. This is a long shot, but I thought it was worth asking. I've done a decent search, and I can see that lbass says several times that it can be done in CR 2008, which I am using, but, doesn't elaborate. I have 2 version of a report, Summary & Detail. The Summary is in Portrait...
  5. pandpp

    Sum(Top 25) / Sum(All) = ZERO, why???

    I got back to this report & fixed it. I used the format painter to format the result. Not sure what happened, but, the end result is it stuffed up. I put a new object on the page & the correct result was displayed. Thanks LB for the time spent on trying to fix a problem that turned out to...
  6. pandpp

    Sum(Top 25) / Sum(All) = ZERO, why???

    Thanks LB. I'll check with SAP. To me, there is NO reason at all, so, hopefully it is nothing more than a wee feature. Peter.
  7. pandpp

    Sum(Top 25) / Sum(All) = ZERO, why???

    Yes LB, hence why I pointed out that my answer was coming back as 0.0000, I pushed it out to 4 dp. Peter.
  8. pandpp

    Sum(Top 25) / Sum(All) = ZERO, why???

    LB, I have @varTop25$: If {BillabongDataWarehousev0001_query.Customer Rank (by Base Line Value) Top 25} <= 25 Then {BillabongDataWarehousev0001_query.Base Line Value} Else 0 and that's in the Detail section. {BillabongDataWarehousev0001_query.Customer Rank (by Base Line Value) Top...
  9. pandpp

    Sum(Top 25) / Sum(All) = ZERO, why???

    This report pulls out all records in a set. Only the top 25 of those is to be displayed. All of that is working fine. What I need on top of that is the percentage of Sum(Top 25) / Sum(All) To get the Top 25, I have a ranking field from the Universe. When that is > 25, I merely assign a...
  10. pandpp

    Horizontal Table in Crystal 2008 - is it possible?

    Thanks LB, right on the money there. I don't recall that functionality existing in versions 7-10, BUT, I never went looking for it either. Works like a charm. Thanks again, Peter.
  11. pandpp

    Horizontal Table in Crystal 2008 - is it possible?

    ...to be laid out as follows: 1 2 3 4 5 6 7 8 9 10 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Each record consists of a picture & a 7 * 2 table of data. It's been a while since I've used Crystal (been using WebI) & this is my first time with 2008. Having said that, I don't recall...
  12. pandpp

    Suppress reports in WEBI 6.5 SP2

    Steve, Thanks for the info, & a special thanks for the BO forum recommendation. Peter.
  13. pandpp

    Suppress reports in WEBI 6.5 SP2

    Hello again. It seems I'm here a lot asking what may seem like obvious questions. I know you can add, delete, even duplicate reports with a document. What I'm looking to do is selectively suppress reports within a document, based say on a prompt. I've searched here, done a Google & even...
  14. pandpp

    Rotating text in Webi 6

    Hello again. Thanks to those who have helped with my previous questions, much appreciated. I am spec'ing a CrossTab report, with up to 30 odd columns. Even in Landscape on an A4 sheet, this is going to be either squashy or micro dot font. I had a thought that the obvious choice was to turn...
  15. pandpp

    MER Universe design

    Hello there. I have cross posted this in the Business Objects solutions Forum as well, since I notice that this forum doesn't seem to get much traffic, but, my responses here would be much more appropriate. I've had to become something of a Crystal to BO convert. I've used Crystal since the...
  16. pandpp

    Basic Universe structure question BO 6.5

    Hello there. I've had to become something of a Crystal to BO convert. I've used Crystal since the late 90's, but this is my first attempt at BO, 6.5. I am using a product called Ellipse, which is using BO 6.5 as it's reporting tool, called MER (Mincom Ellipse Reporting). Ellipse contains...
  17. pandpp

    WEBI 6.5 prompt questions

    Ties, After posting that, I did a Google search for the cascading prompts, locating the posts you mentioned. What that pointed out to me though was that I wasn't using the correct terminology. What I'm trying to do, is hide or show the entire prompt altogether, based on a value chosen in an...
  18. pandpp

    WEBI 6.5 prompt questions

    ...from what I've seen indicates that EVERY prompt HAS to have a value, before the report will run. Now, CHAR prompts can be defaulted to ALL or *, but that trick can't be used for dates. This is annoying if the prompt is perhaps optional, but needs a value selected regardless. Thanks, Peter.
  19. pandpp

    Using a trigger to cancel an UPDATE, INSET or DELETE

    thargtheslayer, Thanks for the suggestion. Unfortunately, I probably didn't fully explain the problem. The 3rd party app is fully allowed to have write access to the table. What I need is to be able to make certain records within that table effectively read only, depending upon certain...
  20. pandpp

    Using a trigger to cancel an UPDATE, INSET or DELETE

    Hello there. I'm not a trigger expert, but happy to give most anything a try. I have a 3rd party app, part of which I need to lock down from being able to edit data in the DB. As such, I decided (maybe stupidly) that it was easy enough to create a trigger to catch the change & put a stop to...

Part and Inventory Search

Back
Top