SSRS Adding text box that accepts input for printing

reporting-services ssrs-2008 rdlc bids rdl
Luke Wyatt picture Luke Wyatt · Oct 24, 2012 · Viewed 11.6k times · Source

Using Business Intelligence Development Studio, I am creating a report for SSRS that requires the user to add a few notes before being printed. The notes do not need to be sent back to the SQL Server that the report is being generated from, they just need to be included when the report is printed or exported. I have some other solutions including:

  • Exporting to Word for edit, then the user can manually publish to pdf & send
  • Including parameters for the note fields which involves pulling the report, then adding in the notes and lastly re-pulling the report again to include the data

But I really don't want to add the extra steps to the user's process unless necessary. Has anyone tried this before? I've been tinkering and searching and have had no luck.

Thanks in advance.

Answer

Jamie F picture Jamie F · Oct 25, 2012

Input to an SSRS report comes from data sources and the parameters. Some server settings are applied, but all the per-report stuff is from either of those two places.

Based on the OP comment, I would add a text parameter that allows blank values. You can set a default value of ="" so that the report will run on first access. Then any text the users adds can be inserted into the report simply by referring to the parameter's value.(=Parameters!MyParam1.Value)

Related questions

Row color and Alternate Row color for Table in RDLC Report

How do I give row color and alternate row color for a Table in RDLC report? When I googled I found most of the result says something like = iif(RowNumber(Nothing) mod 2, "Red", "White") OK! But where should I place …

Read More
Alternate rows background color in a group

I have following situation: Report with nested groups, whether group column has value 1 or 2. Next child group has 2 groups for each parent group, so for parent group 1 there is two child groups (1-1 and 1-3), and also for parent group 2 …

Read More
How to create totals row for grouped columns

If have an rdlc-report with grouped columns within a tablix (table). I want to add a footer row that spans all dynamically created columns and shows a total for all columns together. How can I tell to a cell that …

Read More