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

  • Users: legend8
  • Content: Threads
  • Order by date
  1. legend8

    Which version has PDF compare utility

    Hi all, Do all the versions of Acrobat (i.e Professional, Standard and Element) have the ability to compare PDF files? Cheers Legend8
  2. legend8

    Adding Tab to merge PDFs

    Hi all, I've couple of PDFs and would like to merge them into one. Is there a way to do that using tab (i.e. 1 tab for each PDF) THX Legend
  3. legend8

    SQRDIR setup in SQR

    To all the experts and pro, I've setup PS 7.5 Single User in NT Workstation. When I ran SQRW.exe, I received : (SQR 14) The required environment variable SQRDIR has not been defined. I tried to change the SQRDIR in pssqr.ini but no luck. Any idea would be really appreciated. THX
  4. legend8

    Description section in Infoview

    Hi there, Does anyone know how to hide the "Description" section of all the documents in the inbox? Thanks Legend8
  5. legend8

    SQL for converting a CHAR(15) field

    Hi all, I'm wondering if it is possible to do the following with DB2: Trim and remove all the special charaters (including spaces) in a CHAR(15) field so that it contains only characters like A-Z and 0-9. For example: ' AB 123-456' converts to 'AB123456' Can this be done in DB2 SQL? Any...
  6. legend8

    Microsoft JET Database Engine error '80040e14'

    Hi there, My machine is currently being reimaged and I got the above error when I tried to access a web page with IE 5.5 and I was able to access the page with no problem. Any idea? Thanks
  7. legend8

    Submit a macro using BCA

    Hi there, I've created a macro in a report and perform the following: - Refresh the dataprovider - use 'Call ConvertTo' function to export the data to Excel and then save it to a local directory in the reporting server (eg. c:\rptxls\mydata.xls). I submitted the above report thru Broadcast...
  8. legend8

    Universes with different DBRMS

    Hi there, I've a universe with DB2 and the other in Oracle. Can I use them both in a report? Thanks Legend8
  9. legend8

    Repository backup/restore

    Has anyone tried to backup/restore the reporting repository before? Is this just a matter of copying all the BO tables in the database? Any suggestion is appreciated.
  10. legend8

    Optimize file size of a PDF from Distiller

    Hi there, What is the 'Best' mode when converting to PDF using Distiller in order to obtain the smallest file size? The PDF file that I'm created conatined charts and words plus a very small jpeg file. Any suggestion? THX Legend8
  11. legend8

    Outer join for DB2 V6 s/390

    I've a complex view that use some LEFT OUTER JOINs and then the view is being used again and create another view using some RIGHT OUTER JOINs. The final view is working fine (slow but at least it runs) until we upgraded DB2 from 5 to 6. Whenever the view was dropped and recreate again in V6...
  12. legend8

    Download PDF from Webi (Infoview)

    I've setup an Infoview (WebIntelligence) for users to view their reports in PDF format. When the file is getting too big (eg. 3MB), the document cannot be downloaded to their workstation. Is there any way to resolve this problem? Legend8
  13. legend8

    Conditions change in the data provider

    I have a very strange problem. I have 2 environments A and B and I made a change to the universe by adding a condition to it. I add the condition in a report and everything works properly in A. Then I imported the universe from A to a file and exported it to environment B which is in...
  14. legend8

    Dos Error

    I'm currently using version 8 and I got the error "Dos Error" when I tried to opened a report. Any idea what's wrong?
  15. legend8

    Using CASE statement and aggregate fn in BO

    I'm using BO and DB2 for my reports. If I'm using a CASE..WHEN..END statement and aggregate function in the SELECT clause, BO will automatically generate an SQL with SELECT .... CASE..WHEN..END,...COUNT(*).... FROM .... WHERE .... GROUP BY ... CASE..WHEN..END which fails because DB2 does not...
  16. legend8

    Is there any way to compare between

    Is there any way to compare between universes? I am working in offline mode and using a universe stored locally on my computer and I made some changes to it. Any suggestion is appreciated.
  17. legend8

    Using SELECT in the FROM clause in Designer

    In the Designer, is it possible to create a SELECT statement in the FROM clause? For example: Select * From tbl1 table1, (Select a, count(*) ct1 from tbl2 group by a) table2 Where ......... I appreciate if someone has a solution for this. Thanks
  18. legend8

    view PDF thru Inoview

    I have a problem when viewing a report thru Infoview in PDF format. I'm viewing a report with Landscape orientation, however, sometimes it is being displayed in Portrait format in a random fashion that is so unpredictable. Does anyone has this problem? Any suggestion is appreciated. The BO...

Part and Inventory Search

Back
Top