Can I create Letter type reports within the Report Builder

Hi,

I need to create letter type reports using the report builder, is this possible?. I am trying to create a letter that embeds some variable fields, i.e,. name, address, contact number. I can't seem to find a way to create page headers, and embed report data fields within text. Is this not possible within the report builder? it seems that the only thing you can do within the report builder is add fields to their predesignated areas. I am being forced to use the report builder instead of the report designer in order to give the end user the ability to make modifications to the report/letter. This is very frustrating. not being able to allow the user to edit report designer files, and then having force them to use report builder which doesn't seem to support some simple features..

Any suggestions would be appreciated...

Sorry, the current version of Report Builder is very limited in its functionality and you can't do what you are trying to do.

There is an undocumented feature in Report Builder that may help. You can create a textbox and set its value to an RDL expression, by typing the RDL expression into the text area. This is very limited since you cannot create custom datasets to reference.

Can I add parameters to a report in the Microsoft Report Builder.

Hi,
I'm using SQL Server 2005 Reporting Services and Visual Studio 2005.
I'm just wondering if I can add parameters to a report with the Report
Builder or is this facility only available in the VS2005 report editor? If
it's possible what are the steps I need to follow?
Alternatively, assuming that I can't add parameters in the report
builder directly, I was wondering if parameters could be defined in a report
model and then after it's published the parameters could be included in the
Report Builder report using the model?
Thanks in advance,
Mark.Hi Mark
You can add parameters by adding a Filter.
When building the filter expression click on the operator in the expression
and choose "Prompt" this will generate a parameter. I guess this operator is
not available for all filtering expressions and depends on attribute
ValueSelection property.
Hope this helps,
Jordi Rambla
SQL Server MVP (Reporting Services)
SolidQualityLearning Iberoamericana
"Mark Hayes" <MarkHayes@.discussions.microsoft.com> escribió en el mensaje
news:75FEDA12-7594-4EB4-A035-F93C9A3E6979@.microsoft.com...
> Hi,
> I'm using SQL Server 2005 Reporting Services and Visual Studio 2005.
> I'm just wondering if I can add parameters to a report with the Report
> Builder or is this facility only available in the VS2005 report editor? If
> it's possible what are the steps I need to follow?
> Alternatively, assuming that I can't add parameters in the report
> builder directly, I was wondering if parameters could be defined in a
> report
> model and then after it's published the parameters could be included in
> the
> Report Builder report using the model?
> Thanks in advance,
> Mark.|||I read your response, I am trying to Add a filter or Parameter to a report. I
don't see any expression Builder, just a list of values? Which in my case has
18,000 rows. Where does one build an expression for a filter?
"Jordi Rambla" wrote:
> Hi Mark
> You can add parameters by adding a Filter.
> When building the filter expression click on the operator in the expression
> and choose "Prompt" this will generate a parameter. I guess this operator is
> not available for all filtering expressions and depends on attribute
> ValueSelection property.
> Hope this helps,
> Jordi Rambla
> SQL Server MVP (Reporting Services)
> SolidQualityLearning Iberoamericana
> "Mark Hayes" <MarkHayes@.discussions.microsoft.com> escribió en el mensaje
> news:75FEDA12-7594-4EB4-A035-F93C9A3E6979@.microsoft.com...
> > Hi,
> > I'm using SQL Server 2005 Reporting Services and Visual Studio 2005.
> > I'm just wondering if I can add parameters to a report with the Report
> > Builder or is this facility only available in the VS2005 report editor? If
> > it's possible what are the steps I need to follow?
> > Alternatively, assuming that I can't add parameters in the report
> > builder directly, I was wondering if parameters could be defined in a
> > report
> > model and then after it's published the parameters could be included in
> > the
> > Report Builder report using the model?
> >
> > Thanks in advance,
> > Mark.
>
>