Hello, I have an issue. I'm not seeing the reportviewer data at all. The column names come up fine but there is no data in the report table. Here is what I'm doing
I created a dataset with the following query select * from av_project_mst where [EMAIL PROTECTED] Now I created a report (.rdlc) and dragged a table onto it and the report looks like the following <?xml version="1.0" encoding="utf-8"?> <Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/ 2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/ SQLServer/reporting/reportdesigner"> <DataSources> <DataSource Name="test1"> <rd:DataSourceID>0ac0f7f1-9a46-4289-a79d-97cab9205b09</ rd:DataSourceID> <ConnectionProperties> <DataProvider>SQL</DataProvider> <ConnectString /> </ConnectionProperties> </DataSource> </DataSources> <InteractiveHeight>11in</InteractiveHeight> <ReportParameters> <ReportParameter Name="projectid"> <DataType>String</DataType> <DefaultValue> <Values> <Value /> </Values> </DefaultValue> <AllowBlank>true</AllowBlank> <Prompt>Report_Parameter_0</Prompt> </ReportParameter> </ReportParameters> <rd:DrawGrid>true</rd:DrawGrid> <InteractiveWidth>8.5in</InteractiveWidth> <rd:SnapToGrid>true</rd:SnapToGrid> <RightMargin>1in</RightMargin> <LeftMargin>1in</LeftMargin> <BottomMargin>1in</BottomMargin> <rd:ReportID>4b5ab029-97b6-4439-966e-4a51232b81d2</rd:ReportID> <DataSets> <DataSet Name="DataSet1_AV_PROJECT_MST1"> <Fields> <Field Name="APM_Project_Name"> <DataField>APM_Project_Name</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="APM_Project_Start_Date"> <DataField>APM_Project_Start_Date</DataField> <rd:TypeName>System.DateTime</rd:TypeName> </Field> <Field Name="APM_Project_End_Date"> <DataField>APM_Project_End_Date</DataField> <rd:TypeName>System.DateTime</rd:TypeName> </Field> <Field Name="APM_Project_InCharge"> <DataField>APM_Project_InCharge</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="APM_Project_Desc"> <DataField>APM_Project_Desc</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="APM_Project_ID"> <DataField>APM_Project_ID</DataField> <rd:TypeName>System.Int32</rd:TypeName> </Field> <Field Name="APM_RECADDID"> <DataField>APM_RECADDID</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="APM_RECADDDATE"> <DataField>APM_RECADDDATE</DataField> <rd:TypeName>System.DateTime</rd:TypeName> </Field> <Field Name="APM_RECUPDATEID"> <DataField>APM_RECUPDATEID</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="APM_RECUPDATEDATE"> <DataField>APM_RECUPDATEDATE</DataField> <rd:TypeName>System.DateTime</rd:TypeName> </Field> </Fields> <Query> <DataSourceName>test1</DataSourceName> <CommandText>select * from av_project_mst where [EMAIL PROTECTED]</CommandText> <rd:UseGenericDesigner>true</rd:UseGenericDesigner> </Query> <rd:DataSetInfo> <rd:DataSetName>DataSet1</rd:DataSetName> <rd:TableName>AV_PROJECT_MST</rd:TableName> <rd:TableAdapterName>AV_PROJECT_MSTTableAdapter</ rd:TableAdapterName> <rd:TableAdapterFillMethod>Fill</rd:TableAdapterFillMethod> <rd:TableAdapterGetDataMethod>GetData</ rd:TableAdapterGetDataMethod> </rd:DataSetInfo> </DataSet> </DataSets> <Width>10.83333in</Width> <Body> <ReportItems> <Table Name="table1"> <DataSetName>DataSet1_AV_PROJECT_MST1</DataSetName> <Top>0.75in</Top> <Details> <TableRows> <TableRow> <TableCells> <TableCell> <ReportItems> <Textbox Name="APM_Project_Name"> <rd:DefaultName>APM_Project_Name</ rd:DefaultName> <Style> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> <ZIndex>2</ZIndex> <CanGrow>true</CanGrow> <Value>=First(Fields!APM_Project_Name.Value)</ Value> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="APM_Project_Start_Date"> <rd:DefaultName>APM_Project_Start_Date</ rd:DefaultName> <Style> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> <ZIndex>1</ZIndex> <CanGrow>true</CanGrow> <Value>=First(Fields! APM_Project_Start_Date.Value)</Value> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox6"> <rd:DefaultName>textbox6</rd:DefaultName> <Style> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> <CanGrow>true</CanGrow> <Value /> </Textbox> </ReportItems> </TableCell> </TableCells> <Height>0.25in</Height> </TableRow> </TableRows> </Details> <Header> <TableRows> <TableRow> <TableCells> <TableCell> <ReportItems> <Textbox Name="textbox1"> <rd:DefaultName>textbox1</rd:DefaultName> <Style> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> <ZIndex>8</ZIndex> <CanGrow>true</CanGrow> <Value>APM Project Name</Value> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox2"> <rd:DefaultName>textbox2</rd:DefaultName> <Style> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> <ZIndex>7</ZIndex> <CanGrow>true</CanGrow> <Value>APM Project Start Date</Value> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox3"> <rd:DefaultName>textbox3</rd:DefaultName> <Style> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> <ZIndex>6</ZIndex> <CanGrow>true</CanGrow> <Value /> </Textbox> </ReportItems> </TableCell> </TableCells> <Height>0.25in</Height> </TableRow> </TableRows> </Header> <TableColumns> <TableColumn> <Width>3.61111in</Width> </TableColumn> <TableColumn> <Width>3.61111in</Width> </TableColumn> <TableColumn> <Width>3.61111in</Width> </TableColumn> </TableColumns> <Height>0.75in</Height> <Footer> <TableRows> <TableRow> <TableCells> <TableCell> <ReportItems> <Textbox Name="textbox7"> <rd:DefaultName>textbox7</rd:DefaultName> <Style> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> <ZIndex>5</ZIndex> <CanGrow>true</CanGrow> <Value /> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox8"> <rd:DefaultName>textbox8</rd:DefaultName> <Style> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> <ZIndex>4</ZIndex> <CanGrow>true</CanGrow> <Value /> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox9"> <rd:DefaultName>textbox9</rd:DefaultName> <Style> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> <ZIndex>3</ZIndex> <CanGrow>true</CanGrow> <Value /> </Textbox> </ReportItems> </TableCell> </TableCells> <Height>0.25in</Height> </TableRow> </TableRows> </Footer> </Table> </ReportItems> <Height>2in</Height> </Body> <Language>en-US</Language> <TopMargin>1in</TopMargin> </Report> After this I created a aspx file and dragged the reportviewer control onto it which looks like following <rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" Font-Size="8pt" Height="400px" Width="560px"> <LocalReport ReportPath="c:\inetpub \wwwroot\sarvarpitgroup\av_system\Report\PurchaseReport.rdlc"> <DataSources> <rsweb:ReportDataSource DataSourceId="ObjectDataSource1" Name="DataSet1_AV_PROJECT_MST1" /> </DataSources> </LocalReport> </rsweb:ReportViewer> <asp:ObjectDataSource ID="ObjectDataSource1" runat="server" SelectMethod="GetData" TypeName="DataSet1TableAdapters.AV_PROJECT_MSTTableAdapter" DeleteMethod="Delete" InsertMethod="Insert" OldValuesParameterFormatString="original_{0}" UpdateMethod="Update"> <DeleteParameters> <asp:Parameter Name="Original_APM_Project_ID" Type="Int32" /> </DeleteParameters> <UpdateParameters> <asp:Parameter Name="APM_Project_Name" Type="String" /> <asp:Parameter Name="APM_Project_Start_Date" Type="DateTime" /> <asp:Parameter Name="APM_Project_End_Date" Type="DateTime" /> <asp:Parameter Name="APM_Project_InCharge" Type="String" /> <asp:Parameter Name="APM_Project_Desc" Type="String" /> <asp:Parameter Name="APM_RECADDID" Type="String" /> <asp:Parameter Name="APM_RECADDDATE" Type="DateTime" /> <asp:Parameter Name="APM_RECUPDATEID" Type="String" /> <asp:Parameter Name="APM_RECUPDATEDATE" Type="DateTime" /> <asp:Parameter Name="Original_APM_Project_ID" Type="Int32" /> </UpdateParameters> <SelectParameters> <asp:Parameter Name="projectid" Type="Int32" /> </SelectParameters> <InsertParameters> <asp:Parameter Name="APM_Project_Name" Type="String" /> <asp:Parameter Name="APM_Project_Start_Date" Type="DateTime" /> <asp:Parameter Name="APM_Project_End_Date" Type="DateTime" /> <asp:Parameter Name="APM_Project_InCharge" Type="String" /> <asp:Parameter Name="APM_Project_Desc" Type="String" /> <asp:Parameter Name="APM_RECADDID" Type="String" /> <asp:Parameter Name="APM_RECADDDATE" Type="DateTime" /> <asp:Parameter Name="APM_RECUPDATEID" Type="String" /> <asp:Parameter Name="APM_RECUPDATEDATE" Type="DateTime" /> </InsertParameters> </asp:ObjectDataSource> <br /> </div> </form></td> In my vb file I'm doing the following Dim userid As New ReportParameter("projectid", "2") Dim p() As ReportParameter = {userid} ReportViewer1.LocalReport.SetParameters(p) ReportViewer1.LocalReport.Refresh() Please help. Thanks, Vishal
