How to generate Reports into Excel

[Former Member]

Hi All,

I am implementing DashBoard for sales objects(i,e for Quotation,Order,

Delivery,Invoice and for Returns).Is there any option in business one through which

i can get the whole data of Sales Objects(i,e for Quotation,Order,Delivery,Invoice and for Returns) into a single Excel Sheet.

Help me regarding this how to generate the whole Data into a single Excel sheet.

Regards,

saleem

[Former Member · Accepted solution]

for two option

Example

if use Microsoft ActivX Data Objects 2.5 (or later) Library

-

---

Public ADOComp As ADODB.Connection

Public ADOData As ADODB.Recordset

...

Set ADOComp = New ADODB.Connection

ADOComp.ConnectionString = "Provider=SQLOLEDB;" _

& "Server=" + ServerName + ";" _

& "Database=" + CompanyDB + ";" _

& "User ID=" + sLogin + ";" _

& "Password =" + sPassword + ";" _

& "Current Language=English;" _

& "Application Name=Microsoft Excel;" '_

'& "Workstation ID=HOME"

ADOComp.CursorLocation = adUseClient

ADOComp.Open

...

Dim strSQL As String

strSQL = "SELECT Series FROM NNM1 T0 WHERE ObjectCode = '24' "

Dim rs As ADODB.Recordset

Set rs = New ADODB.Recordset

rs.Open strSQL, ADOComp, adOpenForwardOnly, adLockReadOnly, adCmdText

...

[former_member184566]

Hi

There is two options

1)You can try using free SAP XL reporter add-on.Should do the trick.

2)Your other option is that you can create an excel workbook where you create you own code/Macro that connects to the database and creates the report. Uses VBA but it is very similar to VB. In excel go tools->macro->visual basic editor. That will open an enviroment for you to program in.

Hope that helps