January 20, 2017 at 4:39 am
Hello,
I can't solve a problem which is displaying two matrices in a report based on a value passed to matrix field. I have a base matrix which takes a filed value of 0 or 1. In report i should get two matrices for 0 and for 1. Can anyone help with this problem? If you need more specific information please let me know.
Best regards
Lucas
January 20, 2017 at 4:56 am
We would certainly need more detail like
1. DDL of the tables involved
2. Some sample data
3. Expected results based on the sample data to test the solutions
A bit more detailed problem description would also be helpfull.
If you need any idea on how to this, please follow the link in my signature.
How to post data/code on a forum to get the best help - Jeff Moden
http://www.sqlservercentral.com/articles/Best+Practices/61537/
January 20, 2017 at 6:06 am
Kingston Dhasian - Friday, January 20, 2017 4:56 AMWe would certainly need more detail like
1. DDL of the tables involved
2. Some sample data
3. Expected results based on the sample data to test the solutionsA bit more detailed problem description would also be helpfull.
If you need any idea on how to this, please follow the link in my signature.
Thank you very much for response. I think that i have the answer to my problem but first i need to see if it works. Then i will give more details and i will surely look the link.
January 20, 2017 at 8:29 am
lukaszpiech - Friday, January 20, 2017 6:06 AMKingston Dhasian - Friday, January 20, 2017 4:56 AMWe would certainly need more detail like
1. DDL of the tables involved
2. Some sample data
3. Expected results based on the sample data to test the solutionsA bit more detailed problem description would also be helpfull.
If you need any idea on how to this, please follow the link in my signature.Thank you very much for response. I think that i have the answer to my problem but first i need to see if it works. Then i will give more details and i will surely look the link.
So the solution to my problem is to place matrix inside of another matrix (in one row) and add a row group on that row. I am grouping on a field that takes 0 and 1 values.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply