Creating reports and dashboards | Stimulsoft community forum

Posted: **Tue Jan 05, 2016 9:41 am**

Hi,

I tried to filter a crosstable like shown here:
http://webfx.stimulsoft.com/?reportname ... ingCountry

Unfortunately I got an array error:

Code: Select all

   at Stimulsoft.Report.CrossTab.Core.StiGrid.SetCell(Int32 cellX, Int32 cellY, Int32 cellWidth, Int32 cellHeight, Object text, Object value, StiCrossField field, Boolean isNumeric, Object hyperlink, Object toolTip, Object tag, Dictionary`2 drillDownParameters, Int32 level)
   at Stimulsoft.Report.CrossTab.Core.StiCross.SetCellValue(Int32 x, Int32 y, Object value, Int32 calcIndex, Int32 level, StiFieldType fieldType, Object hyperlinkValue, Object toolTipValue, Object tagValue, Dictionary`2 drillDownParameters)
   at Stimulsoft.Report.CrossTab.Core.StiCross.CopySummary(StiSummary summary, Int32 left, Int32 top, Int32 colIndex, Int32 rowIndex, Boolean setValue, Boolean grandTotal, Object emptyValue)
   at Stimulsoft.Report.CrossTab.Core.StiCross.CopySummaries(Int32 left, Int32 top, Object emptyValue)
   at Stimulsoft.Report.CrossTab.Core.StiCross.Create(DataTable table, StiReport report, StiSummaryDirection direction, String emptyValue)
   at Stimulsoft.Report.CrossTab.StiCrossTabHelper.BuildCross(StiCrossTab masterCrossTab, Boolean designTime)
   at Stimulsoft.Report.CrossTab.StiCrossTabHelper.CreateCross(StiCrossTab masterCrossTab)

Is there any other way to filter a cross table?

Posted: **Tue Jan 05, 2016 12:51 pm**

Hello.

We have found a bug. Please, set the Show Totals property of the Row to True.

Thank you.

Posted: **Tue Jan 05, 2016 1:02 pm**

The error disapears, but filtering still doesn't work.

Posted: **Tue Jan 05, 2016 1:29 pm**

Hello.

The Sorting works right.
What value do you set to the parameter?

Thank you.

Posted: **Tue Jan 05, 2016 2:35 pm**

I tried to put in Canada as a value but nothing happened. I was hoping to see Argentina etc. disapear after klicking on submit.

Posted: **Wed Jan 06, 2016 8:03 am**

Hello.

Your previous report template works fine.
Did you do any changes in the report?

: Untitled.png (3.99 KiB) Viewed 2843 times

Thank you.

Posted: **Wed Jan 06, 2016 10:52 am**

You were right. It works now. Thank you for your help

Posted: **Wed Jan 06, 2016 11:25 am**

Hello.

We are always glad to help you.
Let us know if you need additional help.

Thank you.

Creating reports and dashboards | Stimulsoft community forum

Error when filtering cross table

Error when filtering cross table

Re: Error when filtering cross table

Re: Error when filtering cross table

Re: Error when filtering cross table

Re: Error when filtering cross table

Re: Error when filtering cross table

Re: Error when filtering cross table

Re: Error when filtering cross table