Viewing 15 posts - 1 through 15 (of 127 total)
The code in the report worked awesome. Thanks. But I did run into a problem since it had more that one group. My fault, I left it out. I like...
August 6, 2020 at 5:24 pm
The TSQL didn't work. The report can't do a double aggregate like Sum(Last()).
You're code is awesome for testing. I should have thought of this. My fingers are crossed and I'm...
July 24, 2020 at 2:58 pm
You're right, and I do apologize. I'm a little confused as to how to ask what I need. I'll see if I can get some data, but first how about...
July 24, 2020 at 1:47 pm
The example I get is horrible, I should redo the thread. Sorry about that. Let me try this.
This is closer to what I want. In yellow I...
July 23, 2020 at 10:09 pm
If I include it as a sub report it only shows the first employee because the parameter expression is =First(Fields!Employee.Value, "Employee"). If I take out the first I get an...
February 25, 2020 at 2:03 pm
I'm not sure how to combine two different types of tables into one. How do I force a page break on employee? Since they are two separate tables the results...
February 25, 2020 at 1:43 pm
Awesome, Cross Join with Union All worked perfect.
February 19, 2020 at 1:37 pm
Thanks but I can do the T-SQL. I'll just do that.
October 30, 2019 at 3:31 pm
I'm fairly sure we haven't add anything to our SQL Server yet. I'll look this over, but I think I need to do that first. Oops, wrong forum.
October 30, 2019 at 3:20 pm
Here is an example. The last six digits of the GL Account number represent Region/Division. The first matrix totals the 5 series GL Accounts. The second matrix actually has a...
October 30, 2019 at 2:20 pm
I posted and now I don't see it???
October 30, 2019 at 2:02 pm
April 12, 2018 at 5:42 am
April 10, 2018 at 12:51 pm
Thank you, I think I'm going to give this a try.I was curious, not being as familiar with the coding, why does the update need to address the alias...
April 10, 2018 at 12:22 pm
April 6, 2018 at 10:29 am