Hi Crystal expert,
I need help. I used PthPercentile in Crystal report but got different result vs Oracle percentile function.
For example:
Our data like
dept num
1 0.1069
2 0.1182
3 0.0658
4 0.1045
I would like to find 33% low and 66% high values...
Thanks a lot for answering my question so quick. I just need to logon to Unix box from windows to create/run some scripts. I am not sure it is simple shell or secure shell.
Thanks.
Hi Crystal Reports experts,
I have some questions to consult you.
I need to create a report in bar chart format. The data is like:
Proj_id, start_date, End_date, Error_meg
The report will be like:
Proj1 | ___________
Proj2 | ________________
Proj3 | ________________________...
Hi, SQL expert, I have a question to consult you.
We have a table with fields to conbine user first name, last name and company name, and other information. There are two fields related, propertynames, propertyvalues. The two columns are ntext data type.
Some data sample like:
propertynames...
Hi, SQL reporting experts,
I have a question to consult you. We have setup the reports sending by email by attached excel file. The scheduled reports are sent by attached file like ReportA.xls. I would like to know if any way we can send the excel report with report name and date by attachment...
I am new for SQL Server and have a question to consult experts.
I have an Employee table:
ID Name ManagerID DepartmentID Region
101 Kay Scott 201 D1 South
102 Kim Lee 201 D1 South
103 Jean Lu 301 D2 North
107 Sam Smith 402...
I am new for MS SQL server. I was Oracle Developer. I would like to know how I can display the table's column information, like Oracle desc table_name command.
Thanks a lot for any help.
Jeanne
I will create a BO report to list Top 100 paid employees. I used Free-hand SQL ranking all the employees because I need the show total paid for top 100 and top paid for all others.
On the report, I only need show top 100. How can set the filter? Thanks a lot for any help.
Jeanne
Intuit,
Thanks a lot for your help. One more question, if I use same db name for new database, and modify tnsname on BO server machine, do I need to modify repository on BO server?
Thanks.
Jeanne
Hi, BO experts,
I have a question to consult you. We will change our oracle database server and database name. We use Business Objects version 6.1 (very old). And we have free hand SQL reports and Universes reports on BO web server. My question is how can I change database name for BO reports...
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.