Post reply

Form Letter

  • August 26, 2005 at 10:35 am

    #114856

    Can someone tell me how I can create a form Letter in SQL Reporting Services?  I need to get this done ASAP.  So any help would be appreciated.  I am writing code in VB.Net for a ASP.Net application.  I want to create a form letter that will print out a single page per record.  I have the form letter created but can not figure out how to traverse through the records.  Do I need to use multiple tables or can I do it just from the Body where I have it now.

    Thanks,

    SQL Reporting Services Frustrated

     

     

  • August 26, 2005 at 11:03 am

    #585519

    you gotta create a grouping for each name.

    Drop a listbox on your form, right click properties General tab, Edit Details group, and create a group. Not sure what constitutes a new letter so I would create a group using these fields, firstname, lastname, address1, address2, city,state,zip.

    Before you click okay, click page break at end.

    Then drop those fields in the listbox.

    Followed by your letter.

     

  • August 26, 2005 at 11:05 am

    #585521

    Thanks Ray ,

    I could not figure out what the list box was.  I will try it.

     

     

     

  • August 26, 2005 at 11:12 am

    #585527

    Well its used to display a list, but the group definition is causing only 1 row to show.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply