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 Chriss Miller 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?

    Hello there. Background: We have a report that we've developed in WebI XI, which works well, except for the images. The image displayed for each record is based on the record. The problem WebI has is when we export to PDF, the images are omitted. We tried using Image URL, but you can't...
  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

    Hello. Just completed some training on WEBI 6.5, including Designer & Supervisor. I have used all versions of Crystal from 7 to 10, but am learning that doesn't do much for me in the BO field. The trainer wasn't too happy to impart too much knowledge, preferring to offer answers in a...
  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