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
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...
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
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...
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.
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
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...
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
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...
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...
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.
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
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.