Answered by:
Hiding parameter's in the ssrs 2008
Question
-
User533496661 posted
Hi,
In my main report there will be three links which on click will navigate to other report.
WHen a sub report opens from the main report on click of link it was displaying all the parameters.
I am using report viewer but as i am passing parameters through URL for main report it was not prompting me for parameters, but when i click on link the subreport was displaying the result but still i can see all the parameter text boxes. I need to eliminate this.
Is there any way to eliminate this?
Thanks!
Thursday, March 22, 2012 3:03 PM
Answers
-
User2105670541 posted
Ive created a sample project containing main report and based on the report click calling sub report and settting the parameter of sub report, please have a look into this:
- Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
Saturday, March 24, 2012 2:42 AM
All replies
-
User2105670541 posted
its simple, go to the parameter properties of your subreport and set their visibility to HIDDEN
Friday, March 23, 2012 12:04 AM -
User533496661 posted
Yes i did that but if i am making all the parameters to hidden it was giving error saying parameter is missing a value.
Friday, March 23, 2012 8:40 AM -
User2105670541 posted
can you please share your code, or the snapshots. then we'll be able to help you in much better ways
Friday, March 23, 2012 10:33 AM -
User533496661 posted
<QueryParameters>
<QueryParameter Name="@supp_name">
<Value>=Parameters!supp_name.Value</Value>
</QueryParameter>
</QueryParameters>
<ReportParameters>
<ReportParameter Name="supp_name">
<DataType>String</DataType>
<AllowBlank>true</AllowBlank>
<Prompt>supp_name</Prompt>
<Hidden>true</Hidden>
</ReportParameter>
</ReportParameters>Friday, March 23, 2012 10:43 AM -
User2105670541 posted
no i mean to say, your report project....or the snapshot of your report parameter, data, dataset and all...
Friday, March 23, 2012 12:09 PM -
User533496661 posted
<?xml version="1.0" encoding="utf-8"?> <Report xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition"> <DataSources> <DataSource Name="NUPIC_DataSource"> <DataSourceReference>NUPIC_DataSource</DataSourceReference> <rd:DataSourceID>ba2e0c04-e728-4785-98bf-e8e788eb6419</rd:DataSourceID> <rd:SecurityType>None</rd:SecurityType> </DataSource> </DataSources> <DataSets> <DataSet Name="DataSet1"> <Fields> <Field Name="Member_Count"> <DataField>Member_Count</DataField> <rd:TypeName>System.Int32</rd:TypeName> </Field> <Field Name="not_using"> <DataField>not_using</DataField> <rd:TypeName>System.Int32</rd:TypeName> </Field> <Field Name="SUPP_INFO"> <DataField>SUPP_INFO</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="SUPP_NAME"> <DataField>SUPP_NAME</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="LOCATION"> <DataField>LOCATION</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="Members"> <DataField>Members</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> </Fields> <Query> <DataSourceName>NUPIC_DataSource</DataSourceName> <CommandText>if(@supp_name = '') SELECT COUNT(a.MEMB_CODE) AS Member_Count, (SELECT COUNT(aa.MEMB_CODE) FROM ASL aa INNER JOIN supplier ss ON aa.SUPP_NUMB = ss.SUPP_NUMB where aa.NOT_COUNT_AUDIT is null and ss.SUPP_NUMB = s.SUPP_NUMB) as not_using, s.SUPP_NUMB + '(' + s.SR_CG + '/' + s.PR_EX + ')' AS SUPP_INFO, s.SUPP_NAME, s.CITY + ', ' + s.STATE AS LOCATION, dbo.get_supp_used_by_memb_no_count_audit(s.SUPP_NUMB) AS Members FROM ASL a INNER JOIN supplier s ON a.SUPP_NUMB = s.SUPP_NUMB WHERE (a.NOT_COUNT_AUDIT = 1) GROUP BY s.SUPP_NUMB, s.SR_CG, s.PR_EX, s.SUPP_NAME, s.CITY, s.STATE ORDER BY s.SUPP_NAME if(@supp_name <> '') SELECT COUNT(a.MEMB_CODE) AS Member_Count, (SELECT COUNT(aa.MEMB_CODE) FROM ASL aa INNER JOIN supplier ss ON aa.SUPP_NUMB = ss.SUPP_NUMB where aa.NOT_COUNT_AUDIT is null and ss.SUPP_NUMB = s.SUPP_NUMB) as not_using, s.SUPP_NUMB + '(' + s.SR_CG + '/' + s.PR_EX + ')' AS SUPP_INFO, s.SUPP_NAME, s.CITY + ', ' + s.STATE AS LOCATION, dbo.get_supp_used_by_memb_no_count_audit(s.SUPP_NUMB) AS Members FROM ASL a INNER JOIN supplier s ON a.SUPP_NUMB = s.SUPP_NUMB WHERE (a.NOT_COUNT_AUDIT = 1) AND s.SUPP_NAME LIKE (@supp_name+'%') GROUP BY s.SUPP_NUMB, s.SR_CG, s.PR_EX, s.SUPP_NAME, s.CITY, s.STATE ORDER BY s.SUPP_NAME</CommandText> <QueryParameters> <QueryParameter Name="@supp_name"> <Value>=Parameters!supp_name.Value</Value> </QueryParameter> </QueryParameters> <rd:UseGenericDesigner>true</rd:UseGenericDesigner> </Query> </DataSet> </DataSets> <Body> <ReportItems> <Tablix Name="table1"> <TablixBody> <TablixColumns> <TablixColumn> <Width>1in</Width> </TablixColumn> <TablixColumn> <Width>1.13875in</Width> </TablixColumn> <TablixColumn> <Width>1.1425in</Width> </TablixColumn> <TablixColumn> <Width>1.61979in</Width> </TablixColumn> <TablixColumn> <Width>1.79688in</Width> </TablixColumn> <TablixColumn> <Width>1.34374in</Width> </TablixColumn> </TablixColumns> <TablixRows> <TablixRow> <Height>0.22in</Height> <TablixCells> <TablixCell> <CellContents> <Textbox Name="textbox4"> <CanGrow>true</CanGrow> <UserSort> <SortExpression>=Fields!SUPP_INFO.Value</SortExpression> </UserSort> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>Supplier Number</Value> <Style> <FontSize>8pt</FontSize> <FontWeight>Bold</FontWeight> </Style> </TextRun> </TextRuns> <Style> <TextAlign>Left</TextAlign> </Style> </Paragraph> </Paragraphs> <rd:DefaultName>textbox4</rd:DefaultName> <Style> <Border> <Style>None</Style> </Border> <BottomBorder> <Style>Solid</Style> <Width>2pt</Width> </BottomBorder> <BackgroundColor>White</BackgroundColor> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixCell> <TablixCell> <CellContents> <Textbox Name="textbox5"> <CanGrow>true</CanGrow> <UserSort> <SortExpression>=Fields!SUPP_NAME.Value</SortExpression> </UserSort> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>Supplier Name</Value> <Style> <FontSize>8pt</FontSize> <FontWeight>Bold</FontWeight> </Style> </TextRun> </TextRuns> <Style> <TextAlign>Left</TextAlign> </Style> </Paragraph> </Paragraphs> <rd:DefaultName>textbox5</rd:DefaultName> <Style> <Border> <Style>None</Style> </Border> <BottomBorder> <Style>Solid</Style> <Width>2pt</Width> </BottomBorder> <BackgroundColor>White</BackgroundColor> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixCell> <TablixCell> <CellContents> <Textbox Name="textbox6"> <CanGrow>true</CanGrow> <UserSort> <SortExpression>=Fields!LOCATION.Value</SortExpression> </UserSort> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>Location</Value> <Style> <FontSize>8pt</FontSize> <FontWeight>Bold</FontWeight> </Style> </TextRun> </TextRuns> <Style> <TextAlign>Left</TextAlign> </Style> </Paragraph> </Paragraphs> <rd:DefaultName>textbox6</rd:DefaultName> <Style> <Border> <Style>None</Style> </Border> <BottomBorder> <Style>Solid</Style> <Width>2pt</Width> </BottomBorder> <BackgroundColor>White</BackgroundColor> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixCell> <TablixCell> <CellContents> <Textbox Name="Textbox15"> <CanGrow>true</CanGrow> <UserSort> <SortExpression>=Fields!not_using.Value</SortExpression> </UserSort> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>Count of ASL Members Not using NVLAP/A2LA</Value> <Style> <FontStyle>Normal</FontStyle> <FontFamily>="Arial"</FontFamily> <FontSize>8pt</FontSize> <FontWeight>Bold</FontWeight> <TextDecoration>None</TextDecoration> </Style> </TextRun> </TextRuns> <Style> <TextAlign>Left</TextAlign> </Style> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox15</rd:DefaultName> <Style> <Border> <Style>None</Style> </Border> <BottomBorder> <Style>Solid</Style> <Width>2pt</Width> </BottomBorder> <BackgroundColor>White</BackgroundColor> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixCell> <TablixCell> <CellContents> <Textbox Name="Textbox1"> <CanGrow>true</CanGrow> <UserSort> <SortExpression>=Fields!Member_Count.Value</SortExpression> </UserSort> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>Count of ASL Members using NVLAP/A2LA</Value> <Style> <FontStyle>Normal</FontStyle> <FontSize>8pt</FontSize> <FontWeight>Bold</FontWeight> <TextDecoration>None</TextDecoration> </Style> </TextRun> </TextRuns> <Style> <TextAlign>Left</TextAlign> </Style> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox1</rd:DefaultName> <Style> <Border> <Style>None</Style> </Border> <BottomBorder> <Style>Solid</Style> <Width>2pt</Width> </BottomBorder> <BackgroundColor>White</BackgroundColor> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixCell> <TablixCell> <CellContents> <Textbox Name="textbox7"> <CanGrow>true</CanGrow> <UserSort> <SortExpression>=Fields!Members.Value</SortExpression> </UserSort> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>Members using NVLAP/A2LA</Value> <Style> <FontSize>8pt</FontSize> <FontWeight>Bold</FontWeight> </Style> </TextRun> </TextRuns> <Style> <TextAlign>Left</TextAlign> </Style> </Paragraph> </Paragraphs> <rd:DefaultName>textbox7</rd:DefaultName> <Style> <Border> <Style>None</Style> </Border> <BottomBorder> <Style>Solid</Style> <Width>2pt</Width> </BottomBorder> <BackgroundColor>White</BackgroundColor> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixCell> </TablixCells> </TablixRow> <TablixRow> <Height>0.21in</Height> <TablixCells> <TablixCell> <CellContents> <Textbox Name="SUPP_INFO"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=Fields!SUPP_INFO.Value</Value> <Style> <FontSize>8pt</FontSize> </Style> </TextRun> </TextRuns> <Style> <TextAlign>Left</TextAlign> </Style> </Paragraph> </Paragraphs> <rd:DefaultName>SUPP_INFO</rd:DefaultName> <Style> <Border> <Color>LightGrey</Color> <Style>None</Style> </Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixCell> <TablixCell> <CellContents> <Textbox Name="SUPP_NAME"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=Fields!SUPP_NAME.Value</Value> <Style> <FontSize>8pt</FontSize> </Style> </TextRun> </TextRuns> <Style> <TextAlign>Left</TextAlign> </Style> </Paragraph> </Paragraphs> <rd:DefaultName>SUPP_NAME</rd:DefaultName> <Style> <Border> <Color>LightGrey</Color> <Style>None</Style> </Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixCell> <TablixCell> <CellContents> <Textbox Name="LOCATION"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=Fields!LOCATION.Value</Value> <Style> <FontSize>8pt</FontSize> </Style> </TextRun> </TextRuns> <Style> <TextAlign>Left</TextAlign> </Style> </Paragraph> </Paragraphs> <rd:DefaultName>LOCATION</rd:DefaultName> <Style> <Border> <Color>LightGrey</Color> <Style>None</Style> </Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixCell> <TablixCell> <CellContents> <Textbox Name="not_using1"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=Fields!not_using.Value</Value> <Style> <FontSize>8pt</FontSize> </Style> </TextRun> </TextRuns> <Style> <TextAlign>Left</TextAlign> </Style> </Paragraph> </Paragraphs> <rd:DefaultName>not_using1</rd:DefaultName> <Style> <Border> <Color>LightGrey</Color> <Style>None</Style> </Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixCell> <TablixCell> <CellContents> <Textbox Name="Member_Count1"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=Fields!Member_Count.Value</Value> <Style> <FontSize>8pt</FontSize> </Style> </TextRun> </TextRuns> <Style> <TextAlign>Left</TextAlign> </Style> </Paragraph> </Paragraphs> <rd:DefaultName>Member_Count1</rd:DefaultName> <Style> <Border> <Color>LightGrey</Color> <Style>None</Style> </Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixCell> <TablixCell> <CellContents> <Textbox Name="Members"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=Fields!Members.Value</Value> <Style> <FontSize>8pt</FontSize> </Style> </TextRun> </TextRuns> <Style> <TextAlign>Left</TextAlign> </Style> </Paragraph> </Paragraphs> <rd:DefaultName>Members</rd:DefaultName> <Style> <Border> <Color>LightGrey</Color> <Style>None</Style> </Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixCell> </TablixCells> </TablixRow> </TablixRows> </TablixBody> <TablixColumnHierarchy> <TablixMembers> <TablixMember /> <TablixMember /> <TablixMember /> <TablixMember /> <TablixMember /> <TablixMember /> </TablixMembers> </TablixColumnHierarchy> <TablixRowHierarchy> <TablixMembers> <TablixMember> <KeepWithGroup>After</KeepWithGroup> <RepeatOnNewPage>true</RepeatOnNewPage> <KeepTogether>true</KeepTogether> </TablixMember> <TablixMember> <Group Name="table1_Details_Group"> <DataElementName>Detail</DataElementName> </Group> <TablixMembers> <TablixMember /> </TablixMembers> <DataElementName>Detail_Collection</DataElementName> <DataElementOutput>Output</DataElementOutput> <KeepTogether>true</KeepTogether> </TablixMember> </TablixMembers> </TablixRowHierarchy> <DataSetName>DataSet1</DataSetName> <Top>0.05556in</Top> <Left>0.12688in</Left> <Height>0.43in</Height> <Width>8.04166in</Width> <Style /> </Tablix> </ReportItems> <Height>0.54458in</Height> <Style /> </Body> <ReportParameters> <ReportParameter Name="supp_name"> <DataType>String</DataType> <AllowBlank>true</AllowBlank> <Prompt>supp_name</Prompt> <Hidden>true</Hidden> </ReportParameter> </ReportParameters> <Width>8.19458in</Width> <Page> <PageHeader> <Height>0.71181in</Height> <PrintOnFirstPage>true</PrintOnFirstPage> <PrintOnLastPage>true</PrintOnLastPage> <ReportItems> <Textbox Name="Textbox10"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>NVLAP/A2LA Report</Value> <Style> <FontFamily>Times New Roman</FontFamily> <FontSize>12pt</FontSize> <FontWeight>Bold</FontWeight> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox10</rd:DefaultName> <Top>0.01041in</Top> <Height>0.25in</Height> <Width>8.16854in</Width> <Style> <Border> <Style>None</Style> </Border> <BottomBorder> <Style>Solid</Style> <Width>2pt</Width> </BottomBorder> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> <Textbox Name="Textbox12"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>Search Criteria:</Value> <Style> <FontSize>8pt</FontSize> <FontWeight>Bold</FontWeight> <TextDecoration>Underline</TextDecoration> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox12</rd:DefaultName> <Top>0.32986in</Top> <Height>0.25in</Height> <Width>0.94791in</Width> <ZIndex>1</ZIndex> <Style> <Border> <Style>None</Style> </Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> <Textbox Name="Textbox13"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>="Supplier Name: " & IIf(Parameters!supp_name.Value="","All",Parameters!supp_name.Value)</Value> <MarkupType>HTML</MarkupType> <Style> <FontSize>8pt</FontSize> <FontWeight>Normal</FontWeight> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox13</rd:DefaultName> <Top>0.32986in</Top> <Left>0.9618in</Left> <Height>0.25in</Height> <Width>2.45125in</Width> <ZIndex>2</ZIndex> <Style> <Border> <Style>None</Style> </Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </ReportItems> <Style> <Border> <Style>None</Style> <Width>0.25pt</Width> </Border> <TopBorder> <Width>0.25pt</Width> </TopBorder> <BottomBorder> <Width>0.25pt</Width> </BottomBorder> <LeftBorder> <Width>0.25pt</Width> </LeftBorder> <RightBorder> <Width>0.25pt</Width> </RightBorder> </Style> </PageHeader> <PageFooter> <Height>0.35251in</Height> <PrintOnFirstPage>true</PrintOnFirstPage> <PrintOnLastPage>true</PrintOnLastPage> <ReportItems> <Textbox Name="Textbox77"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=Globals!ExecutionTime</Value> <Style /> </TextRun> </TextRuns> <Style> <TextAlign>Left</TextAlign> </Style> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox77</rd:DefaultName> <Top>0.05556in</Top> <Left>0.12688in</Left> <Height>0.25in</Height> <Width>1.71875in</Width> <Style> <Border> <Style>None</Style> </Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> <Textbox Name="Textbox79"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>="©2012 ETHANY Corporation, All rights reserved."</Value> <Style> <FontStyle>Italic</FontStyle> </Style> </TextRun> </TextRuns> <Style> <TextAlign>Center</TextAlign> </Style> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox79</rd:DefaultName> <Top>0.06944in</Top> <Left>2.61291in</Left> <Height>0.25in</Height> <Width>3.17709in</Width> <ZIndex>1</ZIndex> <Style> <Border> <Style>None</Style> </Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> <Textbox Name="Textbox78"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>="Page" & Globals!PageNumber & " of " & Globals!TotalPages</Value> <Style /> </TextRun> </TextRuns> <Style> <TextAlign>Right</TextAlign> </Style> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox78</rd:DefaultName> <Top>0.06944in</Top> <Left>6.68937in</Left> <Height>0.25in</Height> <Width>1.47917in</Width> <ZIndex>2</ZIndex> <Style> <Border> <Style>None</Style> </Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </ReportItems> <Style> <Border> <Style>None</Style> </Border> </Style> </PageFooter> <PageHeight>8.5in</PageHeight> <PageWidth>11in</PageWidth> <LeftMargin>0.25in</LeftMargin> <RightMargin>0.25in</RightMargin> <TopMargin>0.25in</TopMargin> <BottomMargin>0.25in</BottomMargin> <Style /> </Page> <Language>en-US</Language> <ConsumeContainerWhitespace>true</ConsumeContainerWhitespace> <rd:ReportID>c69ad09c-5d7f-40ed-89d1-54fccb19562d</rd:ReportID> <rd:ReportUnitType>Inch</rd:ReportUnitType> </Report>Friday, March 23, 2012 3:36 PM -
User2105670541 posted
Ive created a sample project containing main report and based on the report click calling sub report and settting the parameter of sub report, please have a look into this:
- Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
Saturday, March 24, 2012 2:42 AM
