Stimulsoft Business Intelligence System | Forum

Hi,
I'm having problems getting drilldown to another page to work properly. I watched the video mentioned in the documentation, and followed the manual point 2.16 - but when I drilldown from page 1 to page 2 there is no information.

A clue might be that there is no information on page 2 even before I add the filter on the data band on page 2?

The object class we use as viewer, is StiViewerFx. It is integrated in test versions of our Flex application.

And we use ActionScript command lo_stidesigner = lo_report.designDialog(lr_1);(where lo_report is a StiViewerFx) to open the designer

Hello.

Could you specify how do you pass the parameters?
Please, send us your report template for analysis.

Thank you.

Hi - I'm afraid the only information I have is this - but i guess this is the report template?

<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<StiSerializer type="Flex" application="StiReport" version="1.02">
<Dictionary isKey="true" Ref="1" type="Dictionary">
<Databases isList="true" count="0"/>
<DataSources isList="true" count="3">
<Fixed isKey="true" Ref="2" type="DataTableSource">
<Alias>Fixed</Alias>
<Columns isList="true" count="9">
<value>A_CUST,System.String</value>
<value>A_CUSTDESCR,System.String</value>
<value>A_CUSTICONURL,System.String</value>
<value>A_SUBREG,System.String</value>
<value>A_SUBREGDESCR,System.String</value>
<value>A_USERCODE,System.String</value>
<value>A_USERNAME,System.String</value>
<value>A_DATE,System.String</value>
<value>A_DATETIME,System.String</value>
</Columns>
<Dictionary isRef="1"/>
<Name>Fixed</Name>
<NameInSource>dataset.Fixed</NameInSource>
</Fixed>
<Data isKey="true" Ref="3" type="DataTableSource">
<Alias>Data</Alias>
<Columns isList="true" count="3">
<value>L_AKSJON_ID,System.Int32</value>
<value>AL_AKSJON_ID,System.String</value>
<value>A_BESKRIVELSE,System.String</value>
</Columns>
<Dictionary isRef="1"/>
<Name>Data</Name>
<NameInSource>dataset.Data</NameInSource>
</Data>
<Data2 isKey="true" Ref="4" type="DataTableSource">
<Alias>Data2</Alias>
<Columns isList="true" count="11">
<value>D_STARTDATO,System.DateTime</value>
<value>AD_STARTDATO,System.String</value>
<value>D_SLUTTDATO,System.DateTime</value>
<value>AD_SLUTTDATO,System.String</value>
<value>A_NAVN,System.String</value>
<value>L_NAVN_ID,System.Int32</value>
<value>AL_NAVN_ID,System.String</value>
<value>A_PRODUKTTYPE_ID,System.String</value>
<value>M_BELOEP,System.String</value>
<value>L_AKSJON_ID,System.Int32</value>
<value>AL_AKSJON_ID,System.String</value>
</Columns>
<Dictionary isRef="1"/>
<Name>Data2</Name>
<NameInSource>dataset.Data2</NameInSource>
</Data2>
</DataSources>
<Relations isList="true" count="2">
<Relation1 isKey="true" Ref="5" type="DataRelation">
<Alias>Relation1</Alias>
<ChildColumns isList="true" count="1">
<value>L_AKSJON_ID</value>
</ChildColumns>
<ChildSource isRef="4"/>
<Dictionary isRef="1"/>
<Name>Relation1</Name>
<NameInSource>Relation1</NameInSource>
<ParentColumns isList="true" count="1">
<value>L_AKSJON_ID</value>
</ParentColumns>
<ParentSource isRef="3"/>
</Relation1>
<Relation2 isKey="true" Ref="6" type="DataRelation">
<Alias>Relation2</Alias>
<ChildColumns isList="true" count="1">
<value>L_AKSJON_ID</value>
</ChildColumns>
<ChildSource isRef="4"/>
<Dictionary isRef="1"/>
<Name>Relation2</Name>
<NameInSource>Relation2</NameInSource>
<ParentColumns isList="true" count="1">
<value>L_AKSJON_ID</value>
</ParentColumns>
<ParentSource isRef="3"/>
</Relation2>
</Relations>
<Report isRef="0"/>
<Variables isList="true" count="0"/>
</Dictionary>
<EngineVersion>EngineV2</EngineVersion>
<GlobalizationStrings isList="true" count="0"/>
<MetaTags isList="true" count="0"/>
<Pages isList="true" count="2">
<Page1 isKey="true" Ref="7" type="Page">
<Border>None;Black;2;Solid;False;4;Black</Border>
<Brush>Transparent</Brush>
<Components isList="true" count="1">
<DataBand1 isKey="true" Ref="8" type="DataBand">
<Brush>Transparent</Brush>
<ClientRectangle>0,0.4,19,0.8</ClientRectangle>
<Components isList="true" count="1">
<Text1 isKey="true" Ref="9" type="Text">
<Brush>Transparent</Brush>
<ClientRectangle>0.6,0,8.6,0.6</ClientRectangle>
<Conditions isList="true" count="0"/>
<Font>Arial,10,Bold</Font>
<Interaction isKey="true" Ref="10" type="Stimulsoft.Report.Components.StiInteraction">
<DrillDownEnabled>True</DrillDownEnabled>
<DrillDownPageGuid>9d98762792c4dd209650177ca94bf0c0</DrillDownPageGuid>
<DrillDownParameter1 isKey="true" Ref="11" type="Stimulsoft.Report.Components.StiDrillDownParameter">
<Expression>Data.L_AKSJON_ID</Expression>
<Name>L_AKSJON_ID</Name>
</DrillDownParameter1>
</Interaction>
<Margins>0,0,0,0</Margins>
<Name>Text1</Name>
<Page isRef="7"/>
<Parent isRef="8"/>
<Text>{Data.L_AKSJON_ID} {Data.A_BESKRIVELSE}</Text>
<TextBrush>Black</TextBrush>
<Type>Expression</Type>
</Text1>
</Components>
<Conditions isList="true" count="0"/>
<DataSourceName>Data</DataSourceName>
<Filters isList="true" count="0"/>
<Name>DataBand1</Name>
<Page isRef="7"/>
<Parent isRef="7"/>
<Sort isList="true" count="0"/>
</DataBand1>
</Components>
<Conditions isList="true" count="0"/>
<Guid>6d4a8d90e39793d2220b16d21736c191</Guid>
<Margins>1,1,1,1</Margins>
<Name>Page1</Name>
<PageHeight>29.7</PageHeight>
<PageWidth>21</PageWidth>
<Report isRef="0"/>
<Watermark isKey="true" Ref="12" type="Stimulsoft.Report.Components.StiWatermark">
<Font>Arial,100</Font>
<TextBrush>[50:0:0:0]</TextBrush>
</Watermark>
</Page1>
<Page2 isKey="true" Ref="13" type="Page">
<Border>None;Black;2;Solid;False;4;Black</Border>
<Brush>Transparent</Brush>
<Components isList="true" count="3">
<Text3 isKey="true" Ref="14" type="Text">
<Brush>Transparent</Brush>
<ClientRectangle>33.8,1.8,1.6,0.6</ClientRectangle>
<Conditions isList="true" count="0"/>
<Font>Arial,10</Font>
<Margins>0,0,0,0</Margins>
<Name>Text3</Name>
<Page isRef="13"/>
<Parent isRef="13"/>
<Text>{Data2.D_STARTDATO}</Text>
<TextBrush>Black</TextBrush>
</Text3>
<Text4 isKey="true" Ref="15" type="Text">
<Brush>Transparent</Brush>
<ClientRectangle>31,1.8,2.8,0.6</ClientRectangle>
<Conditions isList="true" count="0"/>
<Font>Arial,10</Font>
<Margins>0,0,0,0</Margins>
<Name>Text4</Name>
<Page isRef="13"/>
<Parent isRef="13"/>
<Text>D_STARTDATO</Text>
<TextBrush>Black</TextBrush>
</Text4>
<DataBand2 isKey="true" Ref="16" type="DataBand">
<Brush>Transparent</Brush>
<ClientRectangle>0,0.4,19,0.8</ClientRectangle>
<Components isList="true" count="5">
<Text2 isKey="true" Ref="17" type="Text">
<Brush>Transparent</Brush>
<ClientRectangle>0.6,0,4.2,0.6</ClientRectangle>
<Conditions isList="true" count="0"/>
<Font>Arial,10</Font>
<Margins>0,0,0,0</Margins>
<Name>Text2</Name>
<Page isRef="13"/>
<Parent isRef="16"/>
<Text>{Data2.A_NAVN}</Text>
<TextBrush>Black</TextBrush>
</Text2>
<Text5 isKey="true" Ref="18" type="Text">
<Brush>Transparent</Brush>
<ClientRectangle>5.4,0,3.8,0.6</ClientRectangle>
<Conditions isList="true" count="0"/>
<Font>Arial,10</Font>
<Margins>0,0,0,0</Margins>
<Name>Text5</Name>
<Page isRef="13"/>
<Parent isRef="16"/>
<Text>{Data2.AD_STARTDATO}</Text>
<TextBrush>Black</TextBrush>
</Text5>
<Text6 isKey="true" Ref="19" type="Text">
<Brush>Transparent</Brush>
<ClientRectangle>9.8,0,3.8,0.6</ClientRectangle>
<Conditions isList="true" count="0"/>
<Font>Arial,10</Font>
<Margins>0,0,0,0</Margins>
<Name>Text6</Name>
<Page isRef="13"/>
<Parent isRef="16"/>
<Text>{Data2.A_PRODUKTTYPE_ID}</Text>
<TextBrush>Black</TextBrush>
</Text6>
<Text7 isKey="true" Ref="20" type="Text">
<Brush>Transparent</Brush>
<ClientRectangle>14.6,0,1.6,0.6</ClientRectangle>
<Conditions isList="true" count="0"/>
<Font>Arial,10</Font>
<Margins>0,0,0,0</Margins>
<Name>Text7</Name>
<Page isRef="13"/>
<Parent isRef="16"/>
<Text>{Data2.M_BELOEP}</Text>
<TextBrush>Black</TextBrush>
</Text7>
<Text8 isKey="true" Ref="21" type="Text">
<Brush>Transparent</Brush>
<ClientRectangle>17,0,1.6,0.6</ClientRectangle>
<Conditions isList="true" count="0"/>
<Font>Arial,10</Font>
<Margins>0,0,0,0</Margins>
<Name>Text8</Name>
<Page isRef="13"/>
<Parent isRef="16"/>
<Text>{Data2.L_AKSJON_ID}</Text>
<TextBrush>Black</TextBrush>
</Text8>
</Components>
<Conditions isList="true" count="0"/>
<DataSourceName>Data2</DataSourceName>
<Filters isList="true" count="1">
<value>_x007B__x0028_int_x0029__x0020_this_x0020__x005B__x0022_L_AKSJON_ID_x0022__x005D__x0020__x003D__x003D__x0020_Data2_x002E_L_AKSJON_ID_x007D_</value>
</Filters>
<Name>DataBand2</Name>
<Page isRef="13"/>
<Parent isRef="13"/>
<Sort isList="true" count="0"/>
</DataBand2>
</Components>
<Conditions isList="true" count="0"/>
<Guid>9d98762792c4dd209650177ca94bf0c0</Guid>
<Margins>1,1,1,1</Margins>
<Name>Page2</Name>
<PageHeight>29.7</PageHeight>
<PageWidth>21</PageWidth>
<Report isRef="0"/>
<Watermark isKey="true" Ref="22" type="Stimulsoft.Report.Components.StiWatermark">
<Font>Arial,100</Font>
<TextBrush>[50:0:0:0]</TextBrush>
</Watermark>
</Page2>
</Pages>
<PrinterSettings isKey="true" Ref="23" type="Stimulsoft.Report.Print.StiPrinterSettings"/>
<ReportAlias>Report</ReportAlias>
<ReportChanged>07/06/2017 12:42:33 PM</ReportChanged>
<ReportCreated>07/06/2017 09:34:13 AM</ReportCreated>
<ReportFile/>
<ReportGuid>68dd3373c16b57f9e8e0177c9134d61e</ReportGuid>
<ReportName>Report</ReportName>
<ReportUnit>Centimeters</ReportUnit>
<ReportVersion>2017.1.2</ReportVersion>
<ScriptLanguage>CSharp</ScriptLanguage>
<Styles isList="true" count="0"/>
</StiSerializer>

I should also add that if i put a page header etc on page 2, the information is visible when a click on page 1 opens page 2. It is only the detail band that doesn't show.

Hello.

Sorry, we can't reproduce your issue.
We have created the same report.
It works as expected.
Maybe the issue is with data.

Thank you.

Thank you. I then looks like I made a correct set up. Would a number parameter be better than a varchar parameter?

Hello.

It's no matter what type of parameter you are using.
Do you still get any issue?

Thank you.