No I'm using IE. My problem is the reportviewer comes up but no data is displayed.
thanks On Nov 3, 6:31 pm, CK <[EMAIL PROTECTED]> wrote: > are you using firefox - cos reporting services doesn't work well on it > > On 3 Nov, 10:51, vishal <[EMAIL PROTECTED]> wrote: > > > 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> > > > > ... > > read more ยป
