Answer / saurabh

In my understanding you have to use deski not webi for free hand sql .in deski there is no bar for this you can design on your own way....not possible in webi (even if u use custom query also)

Answer / gowthami

You can get the 7th column data also in the report by using free hand sql by following the below steps
assume name of the 7th column is "new"
1.Add some dummy object and go to sql and remove the dummy object field name and put your actual "new" field name

1a. if the dummy object and "new" column is from same table
then no need to change the where clause of sql query
1b. if the dummy object and "new" column is not from same table then need to update the correct join condition in where clause of sql query
2. check 'donot generate sql query based on the result objects'
3.run the report

this way is not advisable. you have to create a object in universe and use it in a report

How to execute the MACRO through Infoview?

1 Answers  

---

what is difference between Rich client web intelligence and Boxir2 web intelligence

3 Answers   TCS,

---

hi,in crystal report xI after select stantderd report Data window appear when ever i click Repository folder it ask me system/user name and p/w and when ever i put my info it says:Tranport falier :comunication error,can any body tell me what to do i already reinstall this s/w 3 times(every thing is working with same user name and p/w like xcelsois,webi,deski,desinger,cmc u name it..thanks

0 Answers  

---

I have saved one file in GMT as a standard time and the server must convert it into local time. How to do it?

1 Answers   IBM,

---

I am trying to save the XI report to CSV format. the csv file not displaying columns in order. all the columns are misplaced. the report size is 12MB Can any one tell me why the columns are incorrect position when XI report converted into CSV format?

3 Answers  

---

When we r going for Short_cut join & It's Resolution??? Plz provide one scenario??

2 Answers   Rolta, TCS,

---

I HAVE USED A PROMPT TO SELECT A COUNTRY IF I REFRESH THE REPORT IT HAS TO SELECT COUNTRY AS INDIA IN DEFAULT AND HAVE TO GIVE THE RESULT? HOW TO ACHIEVE THIS?

3 Answers   BirlaSoft,

---

how many user were there

1 Answers  

---

why do we use crystal reports rather than webintelligence reports ?

7 Answers   CTS, Tech Mahindra,

---

Example of how the fantraps and chasm traps works?

1 Answers   IBM,

---

Hi frns, In the report level i have dragged objects in the query panel. If i check the sql query it is displaying 2 separate queries. What will be the possibilities for this?

2 Answers   Accenture,

---

How to make alternative rows red and green in WebI Report?

3 Answers   Accenture, Mphasis,

---