Method:Classic General Q&A

Re: Pivot grid report on page not the same as in Designer preview

Method_Ben — Wed, 30 Mar 2016 19:24:21 GMT

Hi MikeB,

My apologies for the lengthy response time on this one. More than happy to help out!

Definitely a strange Issue here. Would you be able to email be at <b.hargreaves@method.me> with;

The Account Name/Screen you have this report displaying
The Name of the Report thats having issues for you

Ill take a look at both of these things on my end and see if we cant get this one sorted out for you.

Thanks Mike.

Regards,

Ben

Re: Pivot grid report on page not the same as in Designer preview

MikeB — Mon, 28 Mar 2016 13:58:51 GMT

Still looking for an answer on this

Re: Pivot grid report on page not the same as in Designer preview

MikeB — Mon, 14 Mar 2016 13:31:16 GMT

I would really appreciate a response on this.

The data that I generate is sound. The previews in Method Report Designer are also sound.

But the report on the Method screen has incorrect, mixed up numbers and the report format is jumbled.

Re: Pivot grid report on page not the same as in Designer preview

MikeB — Thu, 10 Mar 2016 19:03:30 GMT

Also, changing the report to a PDF shows only the first page of data/customers, even though the numbers themselves are correct

Changing the report to an XLS file results in the same garbled data and formatting as HTM files

Re: Pivot grid report on page not the same as in Designer preview

MikeB — Thu, 10 Mar 2016 16:49:23 GMT

The problem is when showing the report in HTM mode on the Method screen. The following issues arise:

No column/Data headers
Data values do not match what the customers should have. Everything is offset or jumbled
The report is not sorted A-Z by customer

Is there a bug with this?

Again. the following works (ie. correct values, report sorted A-Z by customer):

Preview in Report designer
HTM view in Report designer
PDF view in Method on the screen
Manual export of table data that has just been refreshed and viewing that in an Excel pivot table.

Please respond.

Pivot grid report on page not the same as in Designer preview

MikeB — Wed, 09 Mar 2016 18:35:31 GMT

A few things:

I have a button on a screen that puts sales data into a custom table. I then have a pivot grid report that reflects that data
It's a very simple grid:

Rows = ParentFullname
Data1 = YTD Sales
Data2 = Marketing allocation
Data3 = Marketing Spent

All 4 of the fields above are in my custom table and the values are sound

In the preview section in Report Designer, this is what I see:

The HTML section looks good, too

But when I put a report on a Method screen (embedded), the report goes haywire. Data become titles and everything is off. In the image below you can see the word "Customer", which is supposed to be the title for the rows, is now the 3rd row