XLR generates empty reports

[Former Member]

I've got a problem with the XL Reporter.

When I execute a report, it comes up empty. The layout and calculations are there, but no data.

When I test the selected dimension with the report composer, there is data. And with the SQL-profiles I see that the correct SQL statement is executed and when I try the SQL statement with SQL Manager, I get the correct results. But in Excel it's as if there are no results at all.

I've generated report definitions with excel and with the report composer wizard, both resulting in the exact same empty report.

I've tried to generate reports as simple as possible; just display the financial periods there are.

In the report composer, drag the Financial Period item into the Selected Dimensions field. Using the refresh report button I see there are results (200505, 200506, ... , 200601). Clicking the Generate Report button let's me enter a name, select the Execute Report radio button, etc.

But in Excel the resulting workbook has only the header in it, no data.

I've been wondering wether the right database is being queried, but the dashboard example does report some data (not much, but that could be cause by me using a sandbox database.)

Am I missing some vital setting somewhere?

(SBO 2004A, SQL server, Microsoft Office 2003, .net 1.1)

[former_member184566]

Hi Roland

Once you generate it and it goes to excel, it should not have data. It should have something like formulas and the required headings. You'll then run it in excel and then it will make another book with the data. When in excel it should have like a small mini toolbar of it's own. Also a side window to the left. In the mini toolbar the first button on the left will run it.

Hope this helps

[Former Member]

That's when I edit the definition (been there, done that). But when I execute the report, it is empty. In the report definition, there are indeed formulas in the fields, put there by me or by the wizard.

I can execute the report with the report composer, Excel (using the first icon on the floating toolbar when editing the definition) or the SBO main menu, under Reports. But there is no difference in the resulting report.

[former_member184566]

Hi Roland

Did you run it without editing it. I've also edited sometimes and at the end it was what i edited to cause it. Once you put into excel, run it straight away and don't edit....does it return data then??

It's hard to see from here and explain. Also i know XL in 2004 has a few problems. Im using 2005 and it works okay and has all the modules now. You??

Hope this helps

[Former Member]

I've even executed reports directly from the Report Composer wizard. As I wrote in the first post, just drag the Financial Period item to the selected Dimensions field and execute the report. (Using the Execute Report radio button) This way I skip the report definition in Excel and go directly to the generated report.

I even see the correct SQL statement being executed, but the report is empty.

[former_member184566]

I'm clueless

??????????????

Sorry

[former_member184566]

Hi Roland

I have just experienced the same thing. The reason it does it it because you have no monetary value.....numbers. When you just have text it gives a blank Excel sheet.

Hope this helps

[Former Member]

That indeed seems to be the problem.

I need an item from each of the three icon-catagories (3 arrows, a funnel and $#) for any result to be displayed.

When I want an address list of all business partners we dealt with in 2005, we also need to include some money fields in the report...

Weird.

Thanks for the tip, I now nknow I've got to make my reports more complex to get them to work.

[former_member184566]

Not a problem