locked
"#Error" display on a column on SSRS RRS feed

  • Question

  • Hi,

    I would like to specify if the column value display "#Error", it will generate data from 2nd dataset, however, any suggestion how can i get it link?

    Jobno     Jobname

    ABBC     #Error

    Wednesday, July 14, 2010 8:32 AM

Answers

  • IF you are in RS 2008 R2 , Then use Lookup() , LookUpset() and Multilookup() functions to display the values from second dataset .

    If you are in RS2005 / RS2008 then you are out of luck in displaying values form second dataset .

    Only one datset sould be associated with individual Report Item .

    Work around would be just combine all the tables if they are logically related , create a new dataset then start to Report .

    Thanks .


    Rajkumar Yelugu
    Wednesday, July 14, 2010 8:47 AM

All replies

  • Hi,

    you are allowed to use only one dataset fields in a matrix/table.. other dataset fields can be referred with aggregate functions.

    Eg :

     =First(Fields!name.value,"Dataset2")

    But.. check that 2nd dataset value by displaying it in seperate text box ot table with that 2nd dataset.

     

    Regards,

    Gayathri


    P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)

     

     

    Wednesday, July 14, 2010 8:41 AM
  • IF you are in RS 2008 R2 , Then use Lookup() , LookUpset() and Multilookup() functions to display the values from second dataset .

    If you are in RS2005 / RS2008 then you are out of luck in displaying values form second dataset .

    Only one datset sould be associated with individual Report Item .

    Work around would be just combine all the tables if they are logically related , create a new dataset then start to Report .

    Thanks .


    Rajkumar Yelugu
    Wednesday, July 14, 2010 8:47 AM
  • Hi,

        You may used some Expression in that text box.

        Sometimes there is no data returned from dataset.

        So the Expression will be displayed as #Error since calculation will be on nothing.

     

     

    Hope this helps,

    Gopala Krishnan.V

     

     

    Wednesday, July 14, 2010 9:45 AM