Showing posts with label grouping. Show all posts
Showing posts with label grouping. Show all posts

Friday, March 9, 2012

Please suggest!

Hi,
While using Reporting services, I have come across the following situation
where the grouping cirteria for the report is defined by the user using ASPX
page.
My problem is, I am not sure how I can send the the grouping preferences to
the Reporting service(I can't send this data as a part of Report parameters
as there is no limit on the number of groups permitted).
Thanks,
RajRaj,
Reports are cheap, and take up no space at all. So make as many reports as
you need that will satisfy your grouping options. On the ASPX have the user
select the grouping options, and your will the call the appropriate report by
name.
rwiethorn
"Raj" wrote:
> Hi,
> While using Reporting services, I have come across the following situation
> where the grouping cirteria for the report is defined by the user using ASPX
> page.
> My problem is, I am not sure how I can send the the grouping preferences to
> the Reporting service(I can't send this data as a part of Report parameters
> as there is no limit on the number of groups permitted).
> Thanks,
> Raj|||Thanks for the reply, rwiethorn.
The solution that you have suggested may not be too practical in my
application as the grouping is quite dynamic and its impossible to create all
the reports at design time.
Thanks again,
Raj
"rwiethorn" wrote:
> Raj,
> Reports are cheap, and take up no space at all. So make as many reports as
> you need that will satisfy your grouping options. On the ASPX have the user
> select the grouping options, and your will the call the appropriate report by
> name.
>
> rwiethorn
>
> "Raj" wrote:
> > Hi,
> >
> > While using Reporting services, I have come across the following situation
> > where the grouping cirteria for the report is defined by the user using ASPX
> > page.
> >
> > My problem is, I am not sure how I can send the the grouping preferences to
> > the Reporting service(I can't send this data as a part of Report parameters
> > as there is no limit on the number of groups permitted).
> >
> > Thanks,
> > Raj

Wednesday, March 7, 2012

please look at my problem..

I don't know what to call this but here is my problem:

I need to create a report:
sample table
(grouping by name)

name: kris (table_group1)
called number | type of call | duration (table_group1)
303492 call1 110 (table_detail)
3202394 call1 102
230384 call3 90
(sum up by grouping the calltypes)
type of call | duration total
call1 212
call3 90

(this is now the same as above)
name: nemo
called number | type of call | duration
303491 call2 111
3202392 call4 222
230386 call4 33

type of call | duration total
call2 111
call4 255

I can show the report by:
inserting a group then expression: "=fields!name.value"
(this solves the grouping for the name)

but my problem is the:
**********************************
type of call | duration total
call2 111
call4 255
**********************************

how do I do this? because i tried subreport, its showing differently results, same with inserting another group(group_2).

I apologize if there has been a same post of what i'm asking, but i just don't know what to call this. if anyone know something that can help, please reply here. thank you!

My Solution to this problem would be other way round, from high level to individual details. (Drill down)

Create a table. Make 2 header rows. Insert Name in first row. Insert Type of Call and Duration Total in the second row. Make Name and Type of Call as Drilldown by clicking Properties->Advanced->Visibility tab->Initial Appearance as Collapsed.

Make expression of Duration Total as =Sum(fields!duration.value)

In the detail row, add a text field with expression =fields!duration.value

When u preview, u should see multiple rows for Names and when u click on (+) sign before Name, it shows Type of Call and Duration Total for that Type of Call. When u click on (+) sign before Type of Call, it shows individual Type of Calls with their Duration.

Hope it helps.

|||Thanks for the alternative solution, Girija! I'll think about it. but it'll be much better if i can stick with the layout i thought of. :) Still, that is a good and possible idea ;) Thank you!

If anyone else have any idea how to make a same layout same as my example, please spare some time to post in here. Thank you!

|||Can you add a new group for each call type then drag and drop the duration field within the group and do a sum ....