Hi:
I wonder is there anyway I can show all items in a grouped level in a
cross-tab report with one click of a button (or an action)? The report is
query based.
For example, I have 10 stores and I want the user to be able to click a
botton and see all the customers in the 10 stores instead of clicking one by
one.
--
AraleHelo Arale,
What is a botton? Is that Chinese for button? Plewse spell better.
"Arale" wrote:
> Hi:
> I wonder is there anyway I can show all items in a grouped level in a
> cross-tab report with one click of a button (or an action)? The report is
> query based.
> For example, I have 10 stores and I want the user to be able to click a
> botton and see all the customers in the 10 stores instead of clicking one by
> one.
> --
> Arale
Showing posts with label items. Show all posts
Showing posts with label items. Show all posts
Wednesday, March 21, 2012
Monday, March 12, 2012
Matrix grouping
My fiscal year starts from April. How can I group with fiscal year like this?
Select items,sum(sales), date from tableA
2007
2006
4
5
6
7
8
9
10
11
12
1
2
3
4
5
6
7
8
9
10
11
12
1
2
3
1
Books
10
20
0
0
0
0
0
0
0
20
50
0
25
10
10
0
0
5
0
25
15
10
10
20
2
Panel
10
10
10
20
20
10
10
20
10
10
10
10
20
20
20
20
30
30
10
10
10
30
30
30
3
Frame
Try to add your fiscal year at your Time dimension.
Helped?
Regards
|||Is it possible user date field group to like this in matrix?
2005-4-1 to 2006-3-31
2006-4-1 to 2007-3-31
4
4
1
Books
10
25
2
Panel
10
20
3
Frame
6
6
Dear Friend,
the both columns is based in the date parameter of your report, correct?
You only need 2 periods? 1 year ago and 2 years ago from parameter date, correct?!
Regards!
|||Hi PedroCGD
The columns is based in the date parameter. I wants to do 5 year periods. Can you help me?
|||Yes I'll help you, but only in a few hours when I arrive home!!
You'll get it! Dont panic! :-)
regards!
|||palm99,
Can I try resolve your problem or you already resolved?
Regards
|||Hi PedroCGD
I am waiting your help.
Matrix grouping
My fiscal year starts from April. How can I group with fiscal year like this?
Select items,sum(sales), date from tableA
2007
2006
4
5
6
7
8
9
10
11
12
1
2
3
4
5
6
7
8
9
10
11
12
1
2
3
1
Books
10
20
0
0
0
0
0
0
0
20
50
0
25
10
10
0
0
5
0
25
15
10
10
20
2
Panel
10
10
10
20
20
10
10
20
10
10
10
10
20
20
20
20
30
30
10
10
10
30
30
30
3
Frame
Try to add your fiscal year at your Time dimension.
Helped?
Regards
|||Is it possible user date field group to like this in matrix?
2005-4-1 to 2006-3-31
2006-4-1 to 2007-3-31
4
4
1
Books
10
25
2
Panel
10
20
3
Frame
6
6
Dear Friend,
the both columns is based in the date parameter of your report, correct?
You only need 2 periods? 1 year ago and 2 years ago from parameter date, correct?!
Regards!
|||Hi PedroCGD
The columns is based in the date parameter. I wants to do 5 year periods. Can you help me?
|||Yes I'll help you, but only in a few hours when I arrive home!!
You'll get it! Dont panic! :-)
regards!
|||palm99,
Can I try resolve your problem or you already resolved?
Regards
|||Hi PedroCGD
I am waiting your help.
Friday, March 9, 2012
Matrix Column Grouping
What would be the best solution to accomplish the following?
The report would look as follows
Year 1 Total Year 2
Month 1 Month 2
Total items 25 12 5
Item type 1 8 9 4
Item type 2 7 2 3
Item type 3 9 5 1
When you click on the Year 1 totals, the detail months should expand
and shift everything to the right.
Just like in a table, you can hide the detail rows of a table, I would
like to hide/unhide the detail columns of a Matrix. However, when I go
to toggle the visibility of the column like I toggle the visibility of
a row in a table, it only hides the column header (obviously because
it's only toggling the visibility of the textbox itself instead of the
entire column). Is there any way to toggle the visibility of a column
in the same manner you do a row in table?
This could also be accomplished with a Table, utilizing static columns,
but that is not ideal.
In Excel, all that needs to be done is to is to group the headers, and
use the new group field to display the PivotTable headers.
Is there an easier/better way to accomplish what I'm trying to do?After hours of searching, shortly after I wrote this, I found the
answer here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rshowto/htm/hrs_designer_v1_0zvx.asp
So nevermind.
The report would look as follows
Year 1 Total Year 2
Month 1 Month 2
Total items 25 12 5
Item type 1 8 9 4
Item type 2 7 2 3
Item type 3 9 5 1
When you click on the Year 1 totals, the detail months should expand
and shift everything to the right.
Just like in a table, you can hide the detail rows of a table, I would
like to hide/unhide the detail columns of a Matrix. However, when I go
to toggle the visibility of the column like I toggle the visibility of
a row in a table, it only hides the column header (obviously because
it's only toggling the visibility of the textbox itself instead of the
entire column). Is there any way to toggle the visibility of a column
in the same manner you do a row in table?
This could also be accomplished with a Table, utilizing static columns,
but that is not ideal.
In Excel, all that needs to be done is to is to group the headers, and
use the new group field to display the PivotTable headers.
Is there an easier/better way to accomplish what I'm trying to do?After hours of searching, shortly after I wrote this, I found the
answer here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rshowto/htm/hrs_designer_v1_0zvx.asp
So nevermind.
Matrix and ReportItems
1. Using ReportItems, what items within a matrix is accessible?
2. Can ReportItems be used in one matrix to access textboxes in another
matrix?hi Deb,
unfortunally i've seen nobody to answer at your question. i have the same
problem: wanted to use reportItems in the matrix cells. since now i haven't
succed. i solved the problem by calculating what i needed in other datasets
and call the values like parameters. the problem is that the report makes a
lifetime for deploying and that's not very nice.
if you found a better solution please write it.
regards, Mirela
"Deb" wrote:
> 1. Using ReportItems, what items within a matrix is accessible?
> 2. Can ReportItems be used in one matrix to access textboxes in another
> matrix?
2. Can ReportItems be used in one matrix to access textboxes in another
matrix?hi Deb,
unfortunally i've seen nobody to answer at your question. i have the same
problem: wanted to use reportItems in the matrix cells. since now i haven't
succed. i solved the problem by calculating what i needed in other datasets
and call the values like parameters. the problem is that the report makes a
lifetime for deploying and that's not very nice.
if you found a better solution please write it.
regards, Mirela
"Deb" wrote:
> 1. Using ReportItems, what items within a matrix is accessible?
> 2. Can ReportItems be used in one matrix to access textboxes in another
> matrix?
Subscribe to:
Posts (Atom)