Sorting Matrix Report

Jan 23, 2008

I have created a Matrix report with 5 row groups (Company and ProductName, ProductEndDate), one column group (Status) and two data columns(Amount & Count).



The report works fine except that it does not sort properly. I want to sort the data by Company, ProductEndDate, ProductName.

I took the following steps -- I highlighted the matrix and in the properties dialog box, selected the groups tab. In groups I selected each row group, hit the edit button, clicked the sorting tab and Company, ProductEndDate, ProductName.


View 3 Replies


ADVERTISEMENT

Reporting Services :: Matrix Report Column Sorting

Oct 29, 2015

I am creating a Matrix report using SSRS/Visual Studio 2008 as below:

Jan
Feb
March
April
May
June
July
Aug
Sept
Oct

A & B are customers. The values represent sales for each month.I have got most parts in place except the Month are displayed in random order (1,10,2,3,4,5,6 and so on).I have tried the option to create a calculated column with month numbers and change group properties but that did not work.how to get it to sort display as 1,2,3,4,5,6,7,8,9,10.

View 6 Replies View Related

Matrix Report:Adding Average Column/Sorting Based On Last Month/Conditional Formating

Aug 2, 2007



I have a matrix report with 2 column SaleAmount and ProfitAmounts by Month like


Sale Profit
Dealer 5/1/2007 6/1/2007 7/1/2007 5/1/2007 6/1/2007 7/1/2007
A 100 200 300 20 25 15
B 200 250 50 30 45 19


how can i do following 3 things


1)Add Total column for Sale and Average column for Profit
2)Sort report by lastMonth of Sale (here 7/1/2007) High to low
3)if last month of sale(here 7/1/2007) is less than second last month here (6/1/2007) whole row should be red

thanks

View 1 Replies View Related

Sorting A Matrix

May 19, 2006

I am trying to sort a matrix by column. I first tried adding an interactive sort to the column heading, but it either gave me a run-time error, or there was not response. I then tried adding sorting to the row groups, and that doesn't seem to work either. I feel I have done every combination of groupings and sort expressions. Has anyone been able to accomplish this?
Thanks,
Kris

View 1 Replies View Related

Matrix Sorting

Jun 27, 2007

Hi. I need to implement a matrix that supports column sorting just like a table.
For example, given a matrix that contains...

Col1 Col2Row1 1 8Row2 2 6Row3 3 7

...if the user clicks on "Col2", I need the matrix to look like this:

Col1 Col2Row2 2 6
Row3 3 7Row1 1 8

I cannot use the interactive sort feature since the matrix must be WYSIWYG with the printed copy and the built-in interactive sort arrows do appear in printed output.

Here's my partial solution; my hope is that someone can point me in the right direction from here:

When the user clicks on a column heading I will jump to a URL such as:
http://myserver/myreport.aspx?SortField=Col2&SortDirection=Ascending

SortField and SortDirection are parsed by the web app and passed as parameters to my report.

So, after the user clicks on Col2 the report knows the following:
Parameters!SortField.Value = "Col2"
and
Parameters!SortDirection.Value = "Ascending"

Given this information, is there a way to tell the report's matrix to actually display the data in the order shown in the example above.

Thanks for any help you can provide.

View 1 Replies View Related

Interactive Sorting In A Matrix

Oct 16, 2006

Bill,

You say, "we enjoy the option of specifying sorting for
multiple columns within the matrix, table or list within which we
are working." But, when I add interactive sorting to the headers of a matrix, the up and down toggles appear in the preview, but the rows are not sorted after clicking.

This works perfectly fine on tables, as you say, but I have yet to see it on a matrix.

Thanks,

Tom

View 7 Replies View Related

Sorting A Matrix On The Rowtotal

Jul 24, 2006

Is there a way to have a matrix sort his rows based on one of the total-values of the row ?

Ex

Col1 Col2 Col3 Total

Row1 10 25 35

Row2 1 10 9 20

Row3 2 2 2 6



Kind Regards

View 3 Replies View Related

Sorting A Matrix Subtotal Column

Oct 30, 2007

I have a matrix with the rows consisting of customers and the columns consisting of different revenue streams. The revenue streams are totalled using the matrix subtotal feature. I would like to sort, either interactively or statically (if that is the only option) by the subtotal column. I've read through everything I can find online and even the solutions that appear to be appropriate do not work. Can anyone give me a suggestion?

Thanks,
Zack Gallinger

View 5 Replies View Related

Sorting Matrix Column In Random Order

Aug 14, 2007



Hi,

I have a matrix report...the column results
are as follows

Con Std , Con Access, SF Std, SF Acc, Broadband, Pay TV

how would i make the columns appear in the above order when displaying as it is default alphetically sorted...I have tried putting numbers at the front which work till I get to the number 10 which alphetically sorted is next to 1 not 9?
is there a better way off sorting matrix column which have no specific criteria to sort from?

thanks

View 6 Replies View Related

How Can I Apply Dynamic Sorting For Columns In Matrix Reports

Apr 30, 2008

Hi,

We have a matrix report which displays columns in a default sorting order. This report columns vary dynamically depending on the user input.

e.g. If user wants to see the report for column Alfa, Beta , Gama then a report will be genarted with column Alfa, Beta , Gama sorted in alphabetical order.






Site
%Risk
Alfa
Beta
Gama

X
2
1
2
3

Y
10
4
5
6
However the users want the Columns to be sorted in the order which they provide the inputs e.g. if the user entered Gama, Alfa, Beta the report should display the columns in the same order instead of applying the default sorting order.






Site
%Risk
Gama
Alfa
Beta

X
2
3
1
2

Y
10
6
4
5

Any thoughts on ways to achieve this in SSRS matrix report would really help.

Cheers,
Viv

View 3 Replies View Related

Passing Parameter To OLAP As A Free Text And Interactive Sorting In Matrix

Apr 30, 2007

Dear All,



I am facing one problem with reporting services 2005 (SSRS), When i try to pass a parameter to Cube which is built in SSAS, i can not use a parameter where i can type the value instead of choosing it from a dimension.



Any way we can type the value for parameter, instead choosing from the drop down? If can, then how can we create the parameter? and how can i write a MDX to read it?



Thanks.



Regards,

Swarna.

View 4 Replies View Related

Adding Columns To A Matrix Report That Don't Belong To The Matrix Columns Groups

Jan 2, 2007

Can we do this?



Adding more columns in a matrix report that don€™t
belong to the columns drilldown dimensions€¦



That is, for example, having the following report:

Product Family


Product

Country City Number of units sold





Then I
would add some ratios, that is, Units Sold/Months (sold per month) and other that
is the average for Product Family (Units Sold/Number of Product Family), for putting an example€¦ some
columns should be precalculated prior to the report so do not get into it, the
real problem I don€™t see how to solve is adding one or two columns for showing
these calculated column that doesn€™t depend on the column groups but they do
for the rows groups€¦




Any guidance
on that?


The only
way I am seeing by now is to set it as two different reports, and that is not
what my client wants€¦






Many
thanks,
Jose

View 4 Replies View Related

Report Sorting Issue

Oct 22, 2007

Sorry guys I have to put this as new thread. Looks no one wants to talk about this issue. Is there any work around at least.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=723793&SiteID=1

Thanks

View 1 Replies View Related

Sorting A Report After Rendering To Excel Or Pdf

Apr 2, 2008

Ok guys, here's the problem. Normally if I were sorting a report that needed to be rendered to pdf or excel, I'll sort the data in the dataset before loading it into the reportviewer in my code. This is in vb, for example:

dataSetName.Tables(0).DefaultView.Sort = "field ASC"

But for this particular case, I have to load the data into the report first, because in the actual report I have to combine two columns based on certain criteria (i do this using an expression for a column in my table) , and after those two columns are combined then they must be sorted.

But since the data is already loaded into the reportviewer I can't sort like I normally would, the report is rendered in either excel or pdf so interactive sort is pointless. I can't sort through table or properties or the properties of the text box because both fields are combined and you can only sort based on one field.

Any ideas?

Aaron

View 3 Replies View Related

Sorting The Report Data After Exporting To Excel

May 11, 2007



We have a requirement where in we need to sort the data after exporting to excel .But when we are trying to apply the filter on the excel and trying to sort we are getting an error ..



Is there any workaround for this??

View 1 Replies View Related

Transact SQL :: Sorting Alphanumerical In Report Builder

Sep 3, 2015

I am trying to sort alphanumeric varchar in a column.Elsewhere PATINDEX is used for sql, but the function is not available in Report Builder. How to create an expression/

View 9 Replies View Related

Sorting Parameter Values In SSRS Model Based Report

Sep 21, 2007

Hi,

I have created a report using Report designer (Visual Studio, using Data Model as a data source), in the report I had created few datasets (with single filed) to populate the report parameters, lets say I have created a multi valued Parameter CustomerName and assigned field from a dataset,

result are coming correctly and combo box is getting populated but the customers are not in alphabetical order!

I want to sort it and need to specify it in report (please note that I am using Report Model as a data source and I can€™t sort the source table in the data base to get the result sorted)


Please let me know if anybody has done that or forward me if know some link which talks about it.


Thanks in advance.

Regards,

Jayant Jape

View 23 Replies View Related

Embedded Mage In Subreport Not Displaying When Report Has Interactive Sorting.

Feb 14, 2008



Hi!

I have a report that contains a table with certain columns that have interactive sorting. At the top of the report there is a subreport that contains an embedded image. When I first run the report, the image in the subreport displays. But, when I sort the table interactively, the image turns into a red asterisk inside a white box. When I click the 'refresh' button, the image redisplays correctly. This is occurring in the Visual Studio 2005 Report Designer when you preview the report. I believe I have the most current version of Visual Studio. I'm not sure what to do about this. Any suggestions?

Karen

View 7 Replies View Related

Reporting Services :: Sorting On Calculated Report Items Columns

Jun 21, 2015

I need to sort my tablix report where I have several calculated columns like:

=ReportItems!Textbox47.value+ReportItems!Textbox48.value..

Now I would like to sort these by using the Interactive sort functions - but I have seen elsewhere that this is not possible..(I'm also getting an error when trying..)Is there not a way that I can bypass this (using Code function or similar) ? The datasource for the data is a OLAP cube

View 3 Replies View Related

Reporting Services :: Subreport Fails If Main Report Does Interactive Sorting

Apr 16, 2013

I've been reading a lot of posts on this subject. I understand that the issue is due to the fact that the subreport is only rendered once. So after the main report is sorted on another column, the cell with the subreport produces an error.

What I want to know is whether or not this is considered a defect. And if it is a defect, is it fixed in another version?

I am currently running SSRS SQL2008R2 SP2 (20.50.4000.0)

View 3 Replies View Related

Reporting Services :: Interactive Sorting With Drill Down Reports In Report Builder 3.0

Aug 20, 2015

I am using Report Builder 3.0 and i have report which has a drill down group. The report opens in a collapsed form.This report has interactive sorting on a column. But,when we drill down and sort the column, the group collapses and the details disappear.

In some posts, i have seen that instead of interactive sorting, people recommended a parameter. But i have to do interactive sorting only.

View 3 Replies View Related

Help With The Matrix Report

Mar 2, 2007

Hello All!

I developed a matrix SSRS report for a specific scenario, and the results look something like the example below. The result set is grouped by the date value, so for all records on that date in the first column I have just one value - 2/5/2007. The client would like to see a value for each cell in every row in the date column, so they can sort the results and do other manipulation in Excel. I tried to make it happen but I doesnt seem to work using the matrix. I would really appreciate if anyone has any suggestions on how to make it work. btw, it really has to be a matrix report :)

Thanks, everyone!















2/5/2007
Value 1
3604




Value 2
5250

Value 3
1281

Value 4
1612

Value 5
2861

Value 6
2135

Value 7
850

Value 8
5368

Value 9
1146

Value 10
2928

Value 11
1435


Value 12
195

Value 14
1414

Value 15
776

View 4 Replies View Related

Matrix Report

Jan 30, 2007

hello all,

I have to make matrix report,
my problem is that I have to make report like this picture:
http://img2.tapuz.co.il/forums/1_93196948.jpg

Is there is a way to make it?
do I need a subreport?


Any tips would be appreciated Thanks

View 2 Replies View Related

Add A New Row To Matrix Report

Apr 18, 2008



Hi ALL,

I'm trying to create a report using matrix report.
I use a simple query like this.

SELECT Catergory, Month, SUM(TotalApp) AS TotApp
FROM Table1
GROUP BY Catergory, Month

result is like thsi
Approved 2007-03-01 00:00:00.000 60198
Approved 2007-04-01 00:00:00.000 59786
Approved 2007-05-01 00:00:00.000 80608
Decisioned 2007-06-01 00:00:00.000 65981
Decisioned 2007-07-01 00:00:00.000 60217
Decisioned 2007-08-01 00:00:00.000 59040
Decisioned 2007-09-01 00:00:00.000 45180

Now I want to add Approved into one row and decisioned into the next row like that. I can easily do row grouping in the matrix. but then I wont be able to add new rows inbetween those groups. I want to add some rows inbetween those groups to include calculated fields.

I try to use something like this;

=IIf(Fields!Category.Value = "Decisioned" , Fields!TotalApps.Value, " " )

But It gives the same result for every group.( does not matter whether its decisioned , Approved or smthign else)

can any one tell me how to do this?

Thanks

View 6 Replies View Related

Help With Matrix Report

Apr 25, 2008

Hi Everyone,

I am having some trouble creating my employee schedules report. I would like to design a report like this:

Name | 7:00am | ............|..............|................|..30 minutes apart..|................|................| 8:00pm
Frank [ FIRST BRK ] [ LUNCH ] [ PROJ 23 ]
Tony [ FIRST BRK ] [ LUNCH ] [ COACHING ]


The dataset includes the following fields:


EmpID int

EmpName varchar

RowDate date

StartTime datetime

StopTime datetime

SegmentCode char(10)

ColorCode
Can someone please advise me on how I can create this report in SQL Server 2005 Reporting Services. Thank You

View 4 Replies View Related

Help With Matrix Report.

May 1, 2007

Hi All,

I have the following matrix report.







Health
1
2
3
4

Std: 1
Health Promotion and Disease Prevention
4
2
4
3

Std: 2
Accessing Health Information, Products, and Services
2
2



Std: 3
Self-Management
2




Std: 4
Influence of Culture, Media, and Technology
2

2


Std: 5
Interpersonal Communication


3


Std: 6
Goal Setting and Decision Making Skills
4


2

Std: 7
Advocating for Health

3





I need a bit of help to do two things.

One is the first row needs to be the average of the matrix columns (1,2,3,4).

Two is for a header row that will span the matrix columns.



So the final output would be;






Average Proficiency Level

Health
1
2
3
4



Overall
2.8
2.3
3
2.5

Std: 1
Health Promotion and Disease Prevention
4
2
4
3

Std: 2
Accessing Health Information, Products, and Services
2
2



Std: 3
Self-Management
2




Std: 4
Influence of Culture, Media, and Technology
2

2


Std: 5
Interpersonal Communication


3


Std: 6
Goal Setting and Decision Making Skills
4


2

Std: 7
Advocating for Health

3







The number of columns can vary from 1 to 4.



Any help would be very much appreciated.

View 2 Replies View Related

Sorting And Grouping Question By Allowing Users To Select The Sorting Field

Feb 11, 2007

I have a report where I am giving the users a parameter so that they can select which field they would like to sort on.The report is also grouping by that field. I have a gruping section, where i have added code to group on the field I want based on this parameter, however I also would like to changing the sorting order but I checked around and I did not find any info.

So here is my example. I am showing sales order info.The user can sort and group by SalesPerson or Customer. Right now, I have code on my dataset to sort by SalesPerson Code and Order No.So far the grouping workds, however the sorting does not.



Any suggestions would help.


Thanks

View 1 Replies View Related

Reporting Services :: Horizontal Axis Show Last Value In First And Last Space When Sorting A-z But Shows Correctly When Sorting Z-a

Jul 10, 2015

SSRS 2012 - VS2010...The report compares two years with a sort order on a value that has been engineered based on text switched to int.  When sorting A-Z this is the result in the horizontal axis is: 5th, K, 1st, 2nd, 3rd, 4th, 5th..When sorting Z-A the result in the horizontal axis is:5th, 4th, 3rd, 2nd, 1st, PreK..Z-A is correct but A-Z sorting shows 5th as the start and end.  The magnitude of the PreK location is correct but the label is wrong on the A-Z sort order.  The sorting is implemented using the Category Group sorting option.

View 6 Replies View Related

MAtrix Report With Drill-through

Mar 13, 2007

Hi All,

I have a table which has a country, division, category, product, Valuetype, value

data looks like this:

Country division, category, product, Valuetype, value
---------------------------------------------------------------------

UK Division1 Food Pizza Volume 10000
UK Division1 Food Pizza Revenue 2000
UK Division1 Food Pizza ROI 4.5

UK Division2 Food Pizza Volume 14000
UK Division2 Food Pizza Revenue 2400
UK Division2 Food Pizza ROI 4.1

UK Division2 Drinks Cola Volume 14000
UK Division2 Drinks Cola Revenue 2400
UK Division2 Drinks Cola ROI 4.1

I want to build a drill-through report to be grouped on country, division, category and product.

Can someone help me with some suggestions?

Cheers
Josh

View 1 Replies View Related

Matrix Report With Totals

Apr 1, 2007

Hi,

Is there a tutorial on how to do a matrix report with row & column tables? This is easy on by default in Crystal, but I can't figure out how to do it in RS.

Thanks,
John

View 2 Replies View Related

Sum Of Fields In Matrix Report

Aug 24, 2007

I have matrix report to display gender statistics based on hierachical geographic data e.g.
Country 1 | region 1 | subregion 1 | No-of-males | no-of-females
with drill through enabled

I want to have persentage near the number-of-gender as well as total population for a row, like this
Country 1 | region 1 | subregion 1 | No-of-males (%-males) | no-of-females (%-females) | Total in the row


but I cannot find the way to do it.

Expression for data cell is
=sum(Fields!no_of_person.Value)

but if I try something like


=sum(Fields!no_of_person.Value) & " (" & sum(fields!no_of_person.Value) / sum(fields!no_of_person.ParentUniqueName, "column") * 100 & ")"


to get the total for both genders - the reports fails

Thanks in advance

View 4 Replies View Related

Help With Matrix Report And Design

May 3, 2008

I've got this data source that returns member information.. great.


I've got a function that when passed the member number and a month/
year returns days participating in the club.





I need to build a report that will output some of the columns for the
member, but then report other information for 6 months for each member
that all calulated based on days particpating for that month. Which 6
months will be dertimed by a single parameter passed to the report for
starting month/year... basically the next 6 months.


Is a matrix report a good option for this? Or should I just have the
function called 6 times in my data source? Ideally I layout the report
for one month and then *somehow* join in my data source for 6
iterations where month is 1 through 6.





Right now I'm having trouble wrapping my mind around how and where to
join the data? Especially if matrix and I have two data sources. I'm
also not sure I can call my function from cells in the matrix or if I
can even have mulitple data buckets in the matrix. I'm tempted to do
this the only way I know how, but I suspect there is a better way.





I've never built a matrix report in ssrs, any information or help is
appreciated.




Thank you!

View 1 Replies View Related

Different Totals In A Matrix Report

Aug 21, 2007

I have a matrix report with 2 column Groups and 2 Row Groups ,I need to calculate the Subtotals at Row Group2

2007
JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC TOTAL

Current Period Total 1211 1813 3040 1699
CB 1062 1551 2527 1517
BR 149 262 513 182
Prior Year Total 1528 1894 3238 1676
CB 1276 1540 2521 1400
BR 252 354 717 276
Prior Year Chg% Total <the Total here Should not be a sum of the individual percents but a Calculated percentage>
CB -16.77 0.71
BR -40.87 -25.99



With this Matrix this is what i have in the cell

=iif (InScope("matrix1_Ddat_Prod_Mth_Nm"),

iif(InScope("matrix1_Date_Calculations"),iif(fields!Date_Calculations.Value = "Current Period",

iif(fields!Ddat_Prod_Mth_Nbr.Value > Month(Today),COBJ("-"),

Round(Sum(Fields!RecruitsCount.Value),2)),

iif(fields!Date_Calculations.Value = "Prior Year Chg %",

iif(fields!Ddat_Prod_Mth_Nbr.Value > Month(Today),"-",

iif(fields!Ddat_Prod_Mth_Nbr.Value <= Month(Today) And fields!RecruitsCount.value = -100,

"-", Round(Sum(Fields!RecruitsCount.Value),2))),Round(Sum(Fields!RecruitsCount.Value),2))),

iif(Fields!Date_Calculations.Value= "Current Period",

iif(Fields!RecruitsCount.Value= 0,"-",Sum(Fields!RecruitsCount.value)),

iif(Fields!Date_Calculations.Value= "Prior Year",Sum(Fields!RecruitsCount.value),

iif(Fields!Date_Calculations.Value="Prior Year Chg %",iif(ASC(Fields!RecruitsCount.Value)= ASC("-"),"-",Round(First(Fields!RecruitsCount.Value),2)),0)))),

iif(InScope("matrix1_Date_Calculations"),Round(Sum(Fields!RecruitsCount.Value),2),Round(Sum(Fields!RecruitsCount.Value),2)))

i have to replace the red strip with a calculated function that would return a total percentage for that row .

I am using AS 2005 as datasource for this , the AS2005 has the totals calculated but i am not able to pull them into the reporting services .
here is the MDX for that

WITH MEMBER [Measures].[Avg Monthly] AS 'AVG(Descendants([DimDate].[Fiscal Hierarchy].Currentmember),[Measures].[RecruitsCount])' MEMBER [Measures].[Total Prior Year] AS 'Sum([dimdateCalculations].[Prior Year])'
SELECT { [Measures].[RecruitsCount] } ON COLUMNS,
{ ([dimDate].[Fiscal Hierarchy].[Ddat Prod Mth Nbr].ALLMEMBERS
* [Date Calculations].[Date Calculations].ALLMEMBERS
* [dimWritingNumber].[Dwnb Broker Ind].[Dwnb Broker Ind].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS
FROM ( SELECT ( STRTOSET(@dimDateDdatProdYrNbr, CONSTRAINED) ) ON COLUMNS
FROM ( SELECT ( STRTOSET(@dimProdChainDpchLowestLvlConsolIDNo, CONSTRAINED) ) ON COLUMNS
FROM ( SELECT ( STRTOSET(@dimProdChainDpchLvlConsolIDNo7, CONSTRAINED) ) ON COLUMNS
FROM ( SELECT ( STRTOSET(@dimProdChainDpchLvlConsolIDNo6, CONSTRAINED) ) ON COLUMNS
FROM ( SELECT ( STRTOSET(@dimProdChainDpchLvlConsolIDNo5, CONSTRAINED) ) ON COLUMNS
FROM ( SELECT ( STRTOSET(@dimProdChainDpchLvlConsolIDNo4, CONSTRAINED) ) ON COLUMNS
FROM ( SELECT ( STRTOSET(@dimProdChainDpchLvlConsolIDNo3, CONSTRAINED) ) ON COLUMNS
FROM ( SELECT ( STRTOSET(@dimProdChainDpchLvlConsolIDNo2, CONSTRAINED) ) ON COLUMNS
FROM ( SELECT ( STRTOSET(@dimProdChainDpchLvlConsolIDNo, CONSTRAINED) ) ON COLUMNS
FROM ( SELECT ( STRTOSET(@dimProdChainDpchTdNm, CONSTRAINED) ) ON COLUMNS
FROM ( SELECT ( STRTOSET(@dimProdChainDpchCompanyCd, CONSTRAINED) ) ON COLUMNS
FROM [MRSCUBE])))))))))))
WHERE
( IIF( STRTOSET(@dimProdChainDpchCompanyCd, CONSTRAINED).Count = 1,
STRTOSET(@dimProdChainDpchCompanyCd, CONSTRAINED), [dimProdChain].[Dpch Company Cd].currentmember ),
IIF( STRTOSET(@dimProdChainDpchTdNm, CONSTRAINED).Count = 1,
STRTOSET(@dimProdChainDpchTdNm, CONSTRAINED), [dimProdChain].[Dpch Td Nm].currentmember ),
IIF( STRTOSET(@dimProdChainDpchLvlConsolIDNo, CONSTRAINED).Count = 1,
STRTOSET(@dimProdChainDpchLvlConsolIDNo, CONSTRAINED), [dimProdChain].[Dpch Lvl50 Consol ID No].currentmember ),
IIF( STRTOSET(@dimProdChainDpchLvlConsolIDNo2, CONSTRAINED).Count = 1,
STRTOSET(@dimProdChainDpchLvlConsolIDNo2, CONSTRAINED), [dimProdChain].[Dpch Lvl49 Consol ID No].currentmember ),
IIF( STRTOSET(@dimProdChainDpchLvlConsolIDNo3, CONSTRAINED).Count = 1,
STRTOSET(@dimProdChainDpchLvlConsolIDNo3, CONSTRAINED), [dimProdChain].[Dpch Lvl46 Consol ID No].currentmember ),
IIF( STRTOSET(@dimProdChainDpchLvlConsolIDNo4, CONSTRAINED).Count = 1,
STRTOSET(@dimProdChainDpchLvlConsolIDNo4, CONSTRAINED), [dimProdChain].[Dpch Lvl45 Consol ID No].currentmember ),
IIF( STRTOSET(@dimProdChainDpchLvlConsolIDNo5, CONSTRAINED).Count = 1,
STRTOSET(@dimProdChainDpchLvlConsolIDNo5, CONSTRAINED), [dimProdChain].[Dpch Lvl40 Consol ID No].currentmember ),
IIF( STRTOSET(@dimProdChainDpchLvlConsolIDNo6, CONSTRAINED).Count = 1,
STRTOSET(@dimProdChainDpchLvlConsolIDNo6, CONSTRAINED), [dimProdChain].[Dpch Lvl30 Consol ID No].currentmember ),
IIF( STRTOSET(@dimProdChainDpchLvlConsolIDNo7, CONSTRAINED).Count = 1,
STRTOSET(@dimProdChainDpchLvlConsolIDNo7, CONSTRAINED), [dimProdChain].[Dpch Lvl29 Consol ID No].currentmember ),
IIF( STRTOSET(@dimProdChainDpchLowestLvlConsolIDNo, CONSTRAINED).Count = 1,
STRTOSET(@dimProdChainDpchLowestLvlConsolIDNo, CONSTRAINED), [dimProdChain].[Dpch Lowest Lvl Consol ID No].currentmember ),
IIF( STRTOSET(@dimDateDdatProdYrNbr, CONSTRAINED).Count = 1,
STRTOSET(@dimDateDdatProdYrNbr, CONSTRAINED), [dimDate].[Ddat Prod Yr Nbr].currentmember ) )
CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS


Please help . Thank you

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved