Answer / ruchi

A PIVOT TABLE ALLOWS US TO REORGANIZE AND SUMMARIZE
SELECTED COLUMNS AND ROWS OF DATA IN A SREADSHEET.

Answer / prasanna s chitale

HI, GUYS

PIVOT TABLE IS ADVANCE FEATURE BY SQL ANSI WITH TRANSFORM
STATEMENT. THIS REPRESENTING THE DATA IN CONSOLIDATE WAY.
FOR EXAMPLE IF WE WANT THE PRODUCT V/S MONTHLY SALE ANALYSIS
THEN IT IS POSSIBLE WITH PIVOT TABLE.

MONTH APRIL-07 MAY-07 JUN-07
PRODUCT
MARUTI-800 700 800 550
MARUTI ZEN 100 120 90

ETC

THIS IS TYPICAL PIVOT TABLE

Difference between Tabletype and Snapshot?

0 Answers  

---

What are the types of validations available in Visual Basic?

2 Answers   Infosys, TCS,

---

What is the difference between procedure and functions in VB?

15 Answers   Infrasoft,

---

What are the tools available for Debuggiu in VB?

0 Answers  

---

Types of LockEdits in RDO.

0 Answers  

---

---

by writing MACRO CODE,i want to retrive data from one spead sheet to another UI (workbook). control will search cell by cell for each row and load the data in another workbook(UI). ex: custdetails custname lastname locaton mobile pincode custdetails raj tony hyd 555555 521245 servcreqrd srvce# srvcename location srvcepincode servcreqrd 754 drilling hyd 521784 for the above example in the another workbook retrive data like this custname Raj srvce# 754 srvcepincode 521784. while retrieving data control will search cell by cell for each row.

0 Answers   CGI, Infotech,

---

___,_____ and ____ container objects.

0 Answers  

---

What are different types of cursors in ADODB?

5 Answers  

---

What is RDO?

1 Answers  

---

How can I call a 'hidden' DOS program from VB?

0 Answers  

---

what is the diff between inprocess and out of process ?

1 Answers  

---

Explain what is Visual basic?

0 Answers  

---