Search results for query: *

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...

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 expert, I would like to consult with you. Any free download tool for me to use from windows xp connect to Unix? Thanks a lot for any help. J

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

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...

Hi, SQL experts, I need help. I want to like top 5 employees with highest salary for each department. For example, we have 3 departments A, B, and C. I would like to have: Deparment A: emp1 $100,000 emp2 $99,000 emp3 $98,200 emp4 $89,999 emp5 $85,300 Deparment B: emp6 $120,000 emp7 $100,900...

Hi, Experts, Please give me some link about Business Objects Report documents or good books. Thanks. J

Hi, SQL experts, I need help. I have a table like: SERV_MONTH R NUM JANUARY R01 19 JANUARY R02 2 JANUARY R03 2 JANUARY R04 3 FEBRUARY R01 1 FEBRUARY R02 1 MARCH R03 1 APRIL R02 1 MAY R02 1 MAY R03 1 JUNE R01 1 JUNE R03 1 JULY R01 2 JULY R02 1...

Hi, Web experts, I have a page (DataCollect.cfm) with 20 checkboxs and several other input fields. Those checked and input values will be inserted into a table. After the user clicks SAVE button, it will go to another page (DaataSave.cfm) to display all values selected and input in a page with...

Hi, expert, I need help. I use Coldfusion to create an application. When I deleted a user from a page, the user is gone from the table, but still shows on the page after the user has been deleted. Thanks a lot for any help.

I am doing a report for a book store. We have data like: STORE_ID SUBJECT SUB_DETAIL NUMBERS 1001 CD CD_TITLE1 2 1001 CD CD_TITLE2 4 1001 CD CD_TITLE3 1 1001 DVD DVD_TITLE1 7 1001 DVD DVD_TITLE2...

I have created a key in cgicmd file like: mykey: USERID=myuserid/mypassword@mydb ?* Then I run the report in web: http://myserver:7778/reports/rwservlet?mykey&report=myreport But I got error message:REP-52005: The specified key ccpskey does not exist in key map file. I do not know how to solve...

I am new for the report. I have some questions to consult the experts. 1. I have created the reports and want to put them on the web (ColdFusion, HTML, or Oracle Portal). How to public the reports on the web? 2. I would like to hide database user id and password on URL, how? 3. I would like to...

I have a question to consult experts. I need to spool the data by dept no to excel file and the file name will be with dept no. For example, I have 10 depts. I would like to spool the data to 10 excel files. The script should include a cursor. I do not know how to do it. Here is my sql script...

I use MS Windows 2000 Professional. I have problem with popup ads. When I work on the computer in my office or home, there are always many popup screens even I do not open IE. I installed Spybot but the problem is still there. I would like to consult the experts what I should do for this...

I have a problem and need help. I created a web page using Coldfusion the report by PDF file. I have no problem at all but others have problem to open pdf file. They got "the file is damaged and cannot be repaired" message which I never had. Here is my code: <CFQUERY NAME="rptName"...