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: *

  • Users: pandpp
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. pandpp

    Is it possible to run UPDATE SQL on DB

    Hello, I am a Crystal person from way back. Not sure about the latest version, but when I looked last time, this wasn't available, in CR at least. Ultimately we will have access to BO v6.5.3. I have a user asking if it is possible, after (or whilst) running a report, to update a field in a...
  12. pandpp

    Modified multi param not showing in SQL

    Hello. Using CR10 on Oracle 8. I have a parameter, allowing multi discrete string values, which are freetype. These values are work orders, which are stored in the DB as 8 char, zero padded strings (eg. '00000001', NOT '1'). Now, I can't make my users ensure they pad the entries to 8 chars...
  13. pandpp

    Break in a Line Chart in CR10

    Hello all. I am using CR10 against an Oracle DB I have a line chart that needs to have one of the lines break/stop in it. I have looked at the cr_line_chart_nulls.pdf only, the clear statement at the top of it of indicated that this was not likely to work for me. That was 12 months ago, so...
  14. pandpp

    Add VbaProject password via VB code

    Hello, It's been a while, but I have previously added VBA code to an Excel project via VB. What I am now seeking is guidance on how to protect, via a password, the Project code, from within VB. I have found the Protection property of the VBComponent within the "Microsoft Visual Basic for...
  15. pandpp

    'Current CE User ID' within a formula

    I have a CR10 report published on CE10. On the report I can put the 'Current CE User ID' on the report and it will print when viewed. What I need to do is use this info in a formula at run time, to select records. I don't fancy asking the user for their user name again, seeing as how they JUST...
  16. pandpp

    VB/Delphi via SDK to view a report - can it be done?

    Hello there, I am running CE10, via a Citrix server. I mention the Citrix because of the licensing issues it implies. I have NEVER used the CE SDK previously. Always it's been RDC until now, via VB. I need to be able to pass 3 parameters (UserID, PositionID, DistrictID) to a report on CE &...
  17. pandpp

    VERY slow ORDER BY, what suggestions?

    Hello. Oracle 8i I have a query which I have just tuned, returning 54K rows in around 4 seconds. This query is being pumped into a Crystal Report, which, optimally, wants to issue an ORDER BY clause. If I let it do the sort on Oracle, the sort itself, on just a single, field takes some 46...
  18. pandpp

    Group tuning problems

    Hello again. CR10 Oracle 8i I have a report, which runs off a VIEW. I have tuned the view, such that I am being returned around 54,000 records in around 8 seconds, off a large number of tables. The report that this feeds has 4 levels of grouping in it. As such, there are effectively 4...
  19. pandpp

    Chart Axis - Sort by abc, display xyz

    CR10 Oracle 8i I have a Bar Chart that displays a rolling 12 month period. I have a couple of ways that I can sort the bars on the graph & this works okay. What displays for the Axis though is 10/2004, when my user wants to see October. I created a formula (MonthName) to decipher 10/2003...
  20. pandpp

    Specifying set number of Major Grid lines in chart

    Hello there. CR10, Access. I am trying to determine if anyone knows of a way to specify the minimum/maximum number of major grid lines. All I have located so far is the ability to specify a min/max values. Unfortunately this won't work, seeing as how my graph works on many different sets of...

Part and Inventory Search

Back
Top