Report dynamic fields

Hi all,
I need to let my report user to select the columes in the report:
I want to make a report with all the relevant fileds .
the user will have window that read the rdl file and display all the reports
fields.
The user can select only the columes he need from the colume list.
How can I doit ?
Can I change the rdl file before the user use the report ?
10x,
Shachar.My suggestion if you decide to do this is to use RS 2005 (out in November).
RS 2005 along with the new controls shipping with Visual Studio 2005 will
make this much much easier than trying to do this with RS 2000. RS 2000 is
totally server based. You would have to deploy your new RDL (uniquely names,
remember you are server based) and then get your client to execute that
report (using either URL integration or web services). Then you would need
to remove it when done. With the new control with VS 2005 you can operate in
local mode where you give it a dataset and the rdl. No deployment necessary.
If all your reports are done this way then you don't even need the server
product, just the new controls.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Shachar" <me@.use.com> wrote in message
news:OXJyiTlpFHA.3040@.TK2MSFTNGP10.phx.gbl...
> Hi all,
> I need to let my report user to select the columes in the report:
> I want to make a report with all the relevant fileds .
> the user will have window that read the rdl file and display all the
> reports fields.
> The user can select only the columes he need from the colume list.
> How can I doit ?
> Can I change the rdl file before the user use the report ?
> 10x,
> Shachar.
>|||What if the application is a web base apllication ?
What is the right colume filter solutuin ?
10x,
Liz.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:OlEEZcmpFHA.272@.TK2MSFTNGP15.phx.gbl...
> My suggestion if you decide to do this is to use RS 2005 (out in
November).
> RS 2005 along with the new controls shipping with Visual Studio 2005 will
> make this much much easier than trying to do this with RS 2000. RS 2000 is
> totally server based. You would have to deploy your new RDL (uniquely
names,
> remember you are server based) and then get your client to execute that
> report (using either URL integration or web services). Then you would need
> to remove it when done. With the new control with VS 2005 you can operate
in
> local mode where you give it a dataset and the rdl. No deployment
necessary.
> If all your reports are done this way then you don't even need the server
> product, just the new controls.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Shachar" <me@.use.com> wrote in message
> news:OXJyiTlpFHA.3040@.TK2MSFTNGP10.phx.gbl...
> > Hi all,
> >
> > I need to let my report user to select the columes in the report:
> > I want to make a report with all the relevant fileds .
> > the user will have window that read the rdl file and display all the
> > reports fields.
> > The user can select only the columes he need from the colume list.
> >
> > How can I doit ?
> > Can I change the rdl file before the user use the report ?
> >
> > 10x,
> >
> > Shachar.
> >
>|||I use RS 2005 .
"Liz Matyas" <lizmts@.mail.com> wrote in message
news:Ozf7%23yopFHA.3064@.TK2MSFTNGP15.phx.gbl...
> What if the application is a web base apllication ?
> What is the right colume filter solutuin ?
> 10x,
> Liz.
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:OlEEZcmpFHA.272@.TK2MSFTNGP15.phx.gbl...
> > My suggestion if you decide to do this is to use RS 2005 (out in
> November).
> > RS 2005 along with the new controls shipping with Visual Studio 2005
will
> > make this much much easier than trying to do this with RS 2000. RS 2000
is
> > totally server based. You would have to deploy your new RDL (uniquely
> names,
> > remember you are server based) and then get your client to execute that
> > report (using either URL integration or web services). Then you would
need
> > to remove it when done. With the new control with VS 2005 you can
operate
> in
> > local mode where you give it a dataset and the rdl. No deployment
> necessary.
> > If all your reports are done this way then you don't even need the
server
> > product, just the new controls.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Shachar" <me@.use.com> wrote in message
> > news:OXJyiTlpFHA.3040@.TK2MSFTNGP10.phx.gbl...
> > > Hi all,
> > >
> > > I need to let my report user to select the columes in the report:
> > > I want to make a report with all the relevant fileds .
> > > the user will have window that read the rdl file and display all the
> > > reports fields.
> > > The user can select only the columes he need from the colume list.
> > >
> > > How can I doit ?
> > > Can I change the rdl file before the user use the report ?
> > >
> > > 10x,
> > >
> > > Shachar.
> > >
> >
> >
>

Report Designer: Refreshing Fields VERY Slow

I have a query that uses temp tables, and the query seems to execute and
refresh fields fine, but as soon as I put in a parameter for a DateTime field
the query will run but the Refresh Fields button takes forever...like 2
hours! I think it is running my rather lengthy query without the parameters
which because of the size of the tables takes a long time.
I have tried changing the data type for the parameter from String to
DateTime and neither seem to refresh the fields quickly.
Can anything be done to refresh the fields list quicker?I thought my MSDN Universal Subscription entitled me to a response within two
days... I guess not.
"Chance" wrote:
> I have a query that uses temp tables, and the query seems to execute and
> refresh fields fine, but as soon as I put in a parameter for a DateTime field
> the query will run but the Refresh Fields button takes forever...like 2
> hours! I think it is running my rather lengthy query without the parameters
> which because of the size of the tables takes a long time.
> I have tried changing the data type for the parameter from String to
> DateTime and neither seem to refresh the fields quickly.
> Can anything be done to refresh the fields list quicker?
>

Report designer - how you refer to an existing field in calculation

Hi,

This seems simple but can't find. Say in my report I have 3 fields(A,B and C).

In field C I want to give a calcultion based on fields A and B. Say field C value = A+B

How do you do this? In expressions I couldn't see existing report fields, it only shows dataset columns.

Sonny

Hi Sonny,

You have several options to do something like this.

You can create a calculated field in your dataset:

In your dataset window, right click on the dataset and select Add Type in the name (FieldC) Select Calculated Field and type in =Fields!FieldA.Value + Fields!FieldB.Value In the textbox where you want FieldC to be, type in =Fields!FieldC.Value|||

Hi Jessica,

Thanks for the answer.

Sonny

Report designer - how you refer to an existing field in calculation

Hi,

This seems simple but can't find. Say in my report I have 3 fields(A,B and C).

In field C I want to give a calcultion based on fields A and B. Say field C value = A+B

How do you do this? In expressions I couldn't see existing report fields, it only shows dataset columns.

Sonny

Hi Sonny,

You have several options to do something like this.

You can create a calculated field in your dataset:

In your dataset window, right click on the dataset and select Add Type in the name (FieldC) Select Calculated Field and type in =Fields!FieldA.Value + Fields!FieldB.Value In the textbox where you want FieldC to be, type in =Fields!FieldC.Value|||

Hi Jessica,

Thanks for the answer.

Sonny

Report Design & Layout

Hi Everybody, i have been having problems in design & layout of the following report .
i need the report layout as follows a
-
HP- FIELDS IN HEADER OF PAGE -REPEATED IN EVERY PAGE.
HR- FIELDS IN HEADER OF REPORT-ONLY ONCE ON 1st PAGE OF REPORT.

i have created a table report in the body of the report as follows.

HP - In Page Header, i have placed some text and page no
HR - In Table Header, i have placed some text & fields.
HP - In Group Header 1, i have some text & fields. & RepeatOnNewPage = true
HR - IN GROUP HEADER 1, text & fields, which i want to repeat on only 1st page.
(this is were i am having problems to set the group header for the table to
to repeat only on 1st page)
HP - In Group Header 1, some text & fields
DETAIL- some fields.

I would really appreciate your help, or any changes in design & layout of the report.

Thanks A lot IN ADVANCE
Sud

As I understand your issue, you have three rows in Group Header 1, the first row you want to repeat on every page, the second row you only want it to show on the 1st page, is this correct?

You can try creating two groups with the same group expressions. Put the first row in the first group and mark it RepeatOnNewPage. Put the second row in the second group and don't repeat it.

Report Description

Can someone please let me know what the use of the Report > Report Properties
> Author & Description Fields are?
When I deploy my reports to the server these values are not visible in the
report properties of the report manager nor are they exposed to be used in a
report. Both of which I want to do.I have just tested what you said below, and I found that although the Author
property I entered was overwritten by my NT login, the description came
through alright on the server after deploying. Go to the Properties tab of
the report in Report Manager and click on the General link; you should see
the description at least.
The description is very useful when searching [there is a Search for text
box at the top right of the screen].
Charles Kangai, MCT, MCDBA
"SAcanuck" wrote:
> Can someone please let me know what the use of the Report > Report Properties
> > Author & Description Fields are?
> When I deploy my reports to the server these values are not visible in the
> report properties of the report manager nor are they exposed to be used in a
> report. Both of which I want to do.|||Hi Charles:
I deployed my rdl using visual studio and the description was not displayed
on the general link of the report properties in the report manager. I also
tried this by uploading the rdl file onto the server...no description either.
Is there a setting that coud be preventing this from occuring?
"Charles Kangai" wrote:
> I have just tested what you said below, and I found that although the Author
> property I entered was overwritten by my NT login, the description came
> through alright on the server after deploying. Go to the Properties tab of
> the report in Report Manager and click on the General link; you should see
> the description at least.
> The description is very useful when searching [there is a Search for text
> box at the top right of the screen].
> Charles Kangai, MCT, MCDBA
> "SAcanuck" wrote:
> > Can someone please let me know what the use of the Report > Report Properties
> > > Author & Description Fields are?
> >
> > When I deploy my reports to the server these values are not visible in the
> > report properties of the report manager nor are they exposed to be used in a
> > report. Both of which I want to do.|||Hi checked the code in the rdl file and my description is referenced in
it...so I really dont know what the issue could be.
"Charles Kangai" wrote:
> I have just tested what you said below, and I found that although the Author
> property I entered was overwritten by my NT login, the description came
> through alright on the server after deploying. Go to the Properties tab of
> the report in Report Manager and click on the General link; you should see
> the description at least.
> The description is very useful when searching [there is a Search for text
> box at the top right of the screen].
> Charles Kangai, MCT, MCDBA
> "SAcanuck" wrote:
> > Can someone please let me know what the use of the Report > Report Properties
> > > Author & Description Fields are?
> >
> > When I deploy my reports to the server these values are not visible in the
> > report properties of the report manager nor are they exposed to be used in a
> > report. Both of which I want to do.|||Another thing we have two report server this description does appear on one
fo them, but not on the other. Why?
"Charles Kangai" wrote:
> I have just tested what you said below, and I found that although the Author
> property I entered was overwritten by my NT login, the description came
> through alright on the server after deploying. Go to the Properties tab of
> the report in Report Manager and click on the General link; you should see
> the description at least.
> The description is very useful when searching [there is a Search for text
> box at the top right of the screen].
> Charles Kangai, MCT, MCDBA
> "SAcanuck" wrote:
> > Can someone please let me know what the use of the Report > Report Properties
> > > Author & Description Fields are?
> >
> > When I deploy my reports to the server these values are not visible in the
> > report properties of the report manager nor are they exposed to be used in a
> > report. Both of which I want to do.|||If you have deployed the report before the description does not go over. It
only goes over it it is the first time you have deployed. Delete the report
on the server and redeploy and the description will come over.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"SAcanuck" <SAcanuck@.discussions.microsoft.com> wrote in message
news:B37830C2-DE50-4695-B8D2-085B6976AC55@.microsoft.com...
> Hi Charles:
> I deployed my rdl using visual studio and the description was not
displayed
> on the general link of the report properties in the report manager. I also
> tried this by uploading the rdl file onto the server...no description
either.
> Is there a setting that coud be preventing this from occuring?
>
> "Charles Kangai" wrote:
> > I have just tested what you said below, and I found that although the
Author
> > property I entered was overwritten by my NT login, the description came
> > through alright on the server after deploying. Go to the Properties tab
of
> > the report in Report Manager and click on the General link; you should
see
> > the description at least.
> >
> > The description is very useful when searching [there is a Search for
text
> > box at the top right of the screen].
> >
> > Charles Kangai, MCT, MCDBA
> >
> > "SAcanuck" wrote:
> >
> > > Can someone please let me know what the use of the Report > Report
Properties
> > > > Author & Description Fields are?
> > >
> > > When I deploy my reports to the server these values are not visible in
the
> > > report properties of the report manager nor are they exposed to be
used in a
> > > report. Both of which I want to do.|||Bruce:
thanks it works now. Is there away to prevent the NT login name from
overwriting the Author name?
"Bruce L-C [MVP]" wrote:
> If you have deployed the report before the description does not go over. It
> only goes over it it is the first time you have deployed. Delete the report
> on the server and redeploy and the description will come over.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "SAcanuck" <SAcanuck@.discussions.microsoft.com> wrote in message
> news:B37830C2-DE50-4695-B8D2-085B6976AC55@.microsoft.com...
> > Hi Charles:
> >
> > I deployed my rdl using visual studio and the description was not
> displayed
> > on the general link of the report properties in the report manager. I also
> > tried this by uploading the rdl file onto the server...no description
> either.
> >
> > Is there a setting that coud be preventing this from occuring?
> >
> >
> >
> > "Charles Kangai" wrote:
> >
> > > I have just tested what you said below, and I found that although the
> Author
> > > property I entered was overwritten by my NT login, the description came
> > > through alright on the server after deploying. Go to the Properties tab
> of
> > > the report in Report Manager and click on the General link; you should
> see
> > > the description at least.
> > >
> > > The description is very useful when searching [there is a Search for
> text
> > > box at the top right of the screen].
> > >
> > > Charles Kangai, MCT, MCDBA
> > >
> > > "SAcanuck" wrote:
> > >
> > > > Can someone please let me know what the use of the Report > Report
> Properties
> > > > > Author & Description Fields are?
> > > >
> > > > When I deploy my reports to the server these values are not visible in
> the
> > > > report properties of the report manager nor are they exposed to be
> used in a
> > > > report. Both of which I want to do.
>
>|||I don't know anything about that, sorry.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"SAcanuck" <SAcanuck@.discussions.microsoft.com> wrote in message
news:6B8F8E52-2909-4FE6-B15A-E25ABE45CB64@.microsoft.com...
> Bruce:
> thanks it works now. Is there away to prevent the NT login name from
> overwriting the Author name?
> "Bruce L-C [MVP]" wrote:
> > If you have deployed the report before the description does not go over.
It
> > only goes over it it is the first time you have deployed. Delete the
report
> > on the server and redeploy and the description will come over.
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "SAcanuck" <SAcanuck@.discussions.microsoft.com> wrote in message
> > news:B37830C2-DE50-4695-B8D2-085B6976AC55@.microsoft.com...
> > > Hi Charles:
> > >
> > > I deployed my rdl using visual studio and the description was not
> > displayed
> > > on the general link of the report properties in the report manager. I
also
> > > tried this by uploading the rdl file onto the server...no description
> > either.
> > >
> > > Is there a setting that coud be preventing this from occuring?
> > >
> > >
> > >
> > > "Charles Kangai" wrote:
> > >
> > > > I have just tested what you said below, and I found that although
the
> > Author
> > > > property I entered was overwritten by my NT login, the description
came
> > > > through alright on the server after deploying. Go to the Properties
tab
> > of
> > > > the report in Report Manager and click on the General link; you
should
> > see
> > > > the description at least.
> > > >
> > > > The description is very useful when searching [there is a Search for
> > text
> > > > box at the top right of the screen].
> > > >
> > > > Charles Kangai, MCT, MCDBA
> > > >
> > > > "SAcanuck" wrote:
> > > >
> > > > > Can someone please let me know what the use of the Report > Report
> > Properties
> > > > > > Author & Description Fields are?
> > > > >
> > > > > When I deploy my reports to the server these values are not
visible in
> > the
> > > > > report properties of the report manager nor are they exposed to be
> > used in a
> > > > > report. Both of which I want to do.
> >
> >
> >

Report Code

Hi All,
I need to go over all the report fields from the report code:
ForEach ReportField! in ReportItems! . . .
What is the right syntax ?
10x,
Shachar.What are you trying to accomplish with the code?
"Shachar" wrote:
> Hi All,
> I need to go over all the report fields from the report code:
> ForEach ReportField! in ReportItems! . . .
> What is the right syntax ?
> 10x,
> Shachar.
>
>|||I need to translate all the report fields.
"daw" <daw@.discussions.microsoft.com> wrote in message
news:87602185-7A9D-47CD-89E6-5DAF035644EF@.microsoft.com...
> What are you trying to accomplish with the code?
> "Shachar" wrote:
> > Hi All,
> >
> > I need to go over all the report fields from the report code:
> >
> > ForEach ReportField! in ReportItems! . . .
> >
> > What is the right syntax ?
> >
> > 10x,
> >
> > Shachar.
> >
> >
> >

Report Builder limitations

Can anyone confirm the following?

1. Can't add images to reports.

2. Can't have fields in a non-tabular layout (e.g. mailing labels, letters, etc.).

3. Can't control column or row spacing of fields or have details that span more than one row.

Thanks.

Alrighty then. Can anyone at least tell me if there are any 3rd-party products out there that might be more robust than Report Builder?

|||

I use Visual Studio .NET to create reports. I am able to do all three. I will explain how if you need it, however if you use a different program to create reports I am not sure.

- Glenda

|||Yeah, I'm talking about design tools for end-users.|||

1) In the current version you can have images pulled from database. You need to have a model entity with an attribute of type binary (corresponding to your image column) and you need to edit the attribute to specify the right MIMType. After that you can drag the attribute into report and you will see images. In Yukon SP1 we are adding support for images embedded in report itself.

2) Yes, it will be hard

3) You can change width hieght of columns and rows in report builder

|||Thanks for the response. I look forward to SP1.