Cost Comparision !!

[Former Member]

Hello Experts,

Is there any way where i can compare the cost ?? i have got contractors for which i have maintained G/L separately like for Pertol/gas expense , Mobile , hourly rate etc.

every time i have to export the data into Excel then do a cut paste to keep all information horizontal and in sequence... is there any way i can do a reporting using MS Excel ??

Is there any way to solve this long activity

[Former Member]

solved through XL Reporter

[Former Member]

Sorry for the delayed response. I am too busy at the moment. Check this thread to find how to do it. The result is what you expected:

To get the result you need, you could use all kinds of Excel functions after you get raw data.

[Former Member]

Gordon,

i will try the same.. but so far i just understood the connection of ODBC... let see what it gives then i will keep you posted.

Cheers !!

[Former Member]

Hi!

Added to the above points,

we have a option in Excel like save the query.

You save your query in a desired path and exceute this every time.

Also, use macro recorder to recored the designs you are doing after exporting the data.

You save this recorded macro in your Personal Book Option.

so, every time after exporting the data. you can run the macro to automat the format you need.

[Former Member]

Hi,

that means macro is the only option ?? i cannot do through Crystal or XLR ??

i never wanted to use macro for this activity.

please reply

[Former Member]

Have you tried to make a database query through ODBC? That could be refreshed automatically when you open your Excel.

Thanks,

Gordon

[Former Member]

Gordon,

I have heard this term lot of times ODBC..if i will try to use this ODBC then can i make my own design in Excel and data can be populated automatically every time i export the data from SBO ?

please give me some link for this ODBC or tell me how i can do this ?

Gordon you are a life saver man !!!

[Former Member]

hi gordon,

i m waiting for your answer.. please

[Former Member]

Hi Ish,

1.Go to Excel>Data

2.Create a Database Connection

3Select Sql server

4.then follow the instruction .

Hope this helps

Bishal

[Former Member]

Bishal,

I have tried it but it just import the data from SQL Tables.. i need a customize view in which in case any changes occur then it should display automatically.

i have tried this thing but i dont know the refine way !!

Please advice

[Former Member]

Hi Ish,

The reason I gave to to get connected with SAP tables with Excel as suggested.To do query against it ,you need to import from Ms Access and create a view in that.

But it seems to like you need some trigger ,however I think it is not possible .

The reason we use this method is to create reports because we can create some other table and manipulate SAP data based on the need .

This is not the correct way to recive any changes automatically if something happen in SAP .

Hope this helps

Bishal

[Former Member]

what i need is that.. i need some data from SBO which comes vertical but i need to put the same data into horizontal conditions with (+/-).

suppose i have one Contractor and i pay him for his mobile, petrol , repair and maintenance and i have different G/L for all Engg.'s

Like this

G/L Account/Contractor Name Petrol Mobile Repairs Food Entertainment

60000 300 400 500 100 900

but now it is coming vertical

do you understand the requirement ?

i want whenever i export the data into excel it should be filled in ready made template.