How to add columns dynamically based on number of groups used.

How to add columns dynamically based on number of groups used.
Hi,
I am pretty new to the Microsoft Reporting services. I wanted to know if
this is possible to design in the reporting server.
I have a requirement to take the number of groups in my report as input. So
if there are two groups I will have two columns and if I have three groups I
will have three colums. Is there any way I can dynamically set the number of
columns based on the input.
Currently I am having to design different report for different number of
groups. This causes more maintenance in case of frequent report design
changes.
Thanks in advance,The matrix control add columns dynamically.
"Ragz" wrote:
> How to add columns dynamically based on number of groups used.
>
> Hi,
> I am pretty new to the Microsoft Reporting services. I wanted to know if
> this is possible to design in the reporting server.
> I have a requirement to take the number of groups in my report as input. So
> if there are two groups I will have two columns and if I have three groups I
> will have three colums. Is there any way I can dynamically set the number of
> columns based on the input.
> Currently I am having to design different report for different number of
> groups. This causes more maintenance in case of frequent report design
> changes.
>
> Thanks in advance,
>
>

How to add columns dynamically based on number of groups used.

Hi,

I am pretty new to the Microsoft Reporting services. I wanted to know if this is possible to design in the reporting server.

I have a requirement to take the number of groups in my report as input. So if there are two groups I will have two columns and if I have three groups I will have three colums. Is there any way I can dynamically set the number of columns based on the input.

Currently I am having to design different report for different number of groups. This causes more maintenance in case of frequent report design changes.
Thanks in advance,
Ragz.To Elaborate further on this question.

If I have a table like

Employee(EmployeeName varchar(100),EmployeeManagerName varchar(100),team varchar(100),experience int)

I take the following inputs:
The number of groups and what to group on.

For example one input might be:
No of groups:1
group-on:EmployeeName.
The resulting report will have
Employee-Name experience
xxxx yyyy
But If I have Number of Groups as 2 and
group-on as
EmployeName and EmployeemanagerName
then i will have three columns Employee-name Employee-manager-name experience

The questions is how can I generate these columns dynamically ?|||Yes, you can do this. The way to do this is:
1) Create a report parameter that specifies the number of groups
2) to add a calculated field to your data set (right click on the Fields window and choose add).
2.1) the expression for the field would select which of the three groups you'd have (e.g. 1, 2, or 3... or what ever you need)
3) Create a matrix report
3.1) group the columns on your constructed parameter

That should probably work.

-Lukasz

How to add an image dynamically using an URL

I need to generate a report which (1)using a dataset to get the path
and file names of a group of GIF images from a database table, and (2)
dynamically construct an URL for each images, and finally (3) using the
URLs to dynamically add the images into the report pages.
Since I have millions of images stored in a virtual directory, I cannot
add them all into my report project.
Thanks in advance if anybody have any solution and can share it with
me!
TommyYou will need SP1 of RS 2000 which supports retrieving "external" images
through http://. Check section 4.1.4 of the SP1 readme for details.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tommy" <qtao@.doe.k12.de.us> wrote in message
news:1114002588.814601.73710@.g14g2000cwa.googlegroups.com...
>I need to generate a report which (1)using a dataset to get the path
> and file names of a group of GIF images from a database table, and (2)
> dynamically construct an URL for each images, and finally (3) using the
> URLs to dynamically add the images into the report pages.
> Since I have millions of images stored in a virtual directory, I cannot
> add them all into my report project.
> Thanks in advance if anybody have any solution and can share it with
> me!
> Tommy
>