How to Create Report?

[ngreddy1982]

Hi there, I have been asked to make a report on damaged orders. 1st I have a get a sample report on sql query ,copy it to excel and get approval is that ok go ahead to qlikvew. So table must contain below columns. can you please help me with query .

Damage Report
Order No	Country	Carrier	Box Used	Weight of Order

Message was edited by: Giridhar Nadavluru

[Anil_Babu_Samineni]

1) Check with then, Create sample report with below detailed columns in SQL

2) And ask them to share that then use that in Qlikview by help of load(May be Excel / DB Directly from View)

3) Create Straight Object help of these field with Metric

[satheshreddy]

Hi,

you have a columns so first connect the ODBC and write a SQL Query(SQL Query's also working in Qlikview)for get the data and save it and reload the application.

if you want all columns mention * other wise particular columns you can use.

once the reload done use Objects and create a report whatever you want.

Regards

Sathsih