Could not create Report From XL Reporter

[Former Member]

Hi all,

I tried t generate the Report the Report from XL Reporter -Report Composer,But the data is not loaded in Excel.

I Dragged BpCode,BPName From table and Dragged into Report Area,and refreshed now report composer showed me the report , When i give GENERATE REPORT a new window is opened and here i clicked REPORT GENERATION, It took me to Excel Sheet but no data is displayed .opened with blank work book,Please help me to resolve this

Regards

Mohamed Zubair.N ;

[Former Member · Accepted solution]

Hi Mohamed,

This is currently a system behavior.

If thereu2019s only one Dimension (BP name is an attribute of Dimension BP code), thereu2019s no data returned in Excel. Weu2019ll have to add at least a light dimension or measure to have data returned.

You can create a query and use the 'Export to MS-EXCEL' functionality, if you would like to report on one dimension only.

Hope it helps.

Regards,

Jacqueline Jiang

SAP Business One Forums Team