Dynamics Community Forum Thread Details

SRSS reports and Solomon V7-SP3

Now that Solomon supports SQL Reporting Services Reports we have successfully developed and depoloyed numerous SSRS reports for Solomon.

However, we have been unable to successfully deploy one that uses the DrillThrough feature.

The report works perfectly using the web interface to SQL reporting services, but does not allow DrillThrough when rendered by the Solomon interface.

The following is an excerpt from the rdl file dealing with the DrillThrough

                    <Action>
                      <Drillthrough>
                        <ReportName>=IIF(IsNothing(Sum(Fields!TransAmount.Value)), False, "UB829sub2")</ReportName>
                        <Parameters>
                          <Parameter Name="TransCode">
                            <Value>=First(Fields!TransCode.Value)</Value>
                          </Parameter>
                          <Parameter Name="TransBegDate">
                            <Value>=Min(Fields!TransDate.Value)</Value>
                          </Parameter>
                          <Parameter Name="TransEndDate">
                            <Value>=IIf(InScope("matrix1_ColumnGroup1"), Min(Fields!TransDate.Value), Max(Fields!TransDate.Value))</Value>
                          </Parameter>
                        </Parameters>
                      </Drillthrough>
                    </Action>

The child report is defined by UB829sub2.rdl

The report takes parameters from the parent report (TransCode and Dates)

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)