sub report

• paul-879829

  Newbie

  Points: 2

  More actions

  October 8, 2008 at 1:06 am

  #213842

  Hello,

  i am responsible for developing a report to do a mail merge in reporting services, the SQL behind the report works correctly but I cant for the life of me get the reporting to work correctly. The problem lies with when I am passing across the parameters to the sub report.

  From Sub report Properties Dialog box.

  =count(Fields!IDOutlet.Value, "DataSet1")

  returns 3, so there is data there, just like in the SQL query behind this.

  =first(Fields!IDOutlet.Value, "DataSet1")

  returns the first record.

  =Fields!IDOutlet.Value

  returns the last record in the dataset

  I cant work out a way of getting all of the records on different pages of the report. There is only one record coming up no matter what i try.

  Any ideas greatly appreciated

  Thanks Paul

• paul-879829

  Newbie

  Points: 2

  More actions

  October 9, 2008 at 1:26 am

  #882715

  paul (10/8/2008)

  ---

  Hello,

  Thanks Paul

  A colleague worked out that the subreport has to be in a list box for this to work. I did that now its working correctly.