none
Help to resolve the issue about SSRS expression in SSRS 2012 RRS feed

  • 问题

  • Background:

    I use SQL Server 2012 and SSRS 2012 to develop.

    There is a table TestTable with the columns: Empl_C and Empl_X. Dont put any records in this table.

    USE [TestDB]
    GO
    
    /****** Object:  Table [dbo].[TestTable]    Script Date: 5/9/2013 9:27:31 AM ******/
    SET ANSI_NULLS ON
    GO
    
    SET QUOTED_IDENTIFIER ON
    GO
    
    SET ANSI_PADDING ON
    GO
    
    CREATE TABLE [dbo].[TestTable](
    	[Empl_C] [varchar](50) NULL,
    	[Empl_X] [varchar](50) NULL
    ) ON [PRIMARY]
    
    GO
    
    SET ANSI_PADDING OFF
    GO

    Use SSRS to create a dataset named TestDataSet with the sql " select * from TestTable".

    Insert a table band the datasetin SSRS and write a expression in the table :

    ="ABCD ["+IIF(IsNothing(Field!Empl_X.value),"1","2")+"] 1234"

    Issue:

    When i preview the report in SSRS i can see the result as below:

    But When i Export the report as PDF, i only can see the border of the table. but cant see the result of the expression:

    Please help to resolve this qns.Is it a bug in SSRS 2012?


    2013年5月9日 1:38

答案

全部回复