Viewing 13 posts - 1 through 13 (of 13 total)
Thank you Mike too. I haven't tried yours yet, but I imagine it would work as well. 🙂
July 24, 2018 at 9:57 am
Oh, I was trying to do that and so close, but kept getting conversion errors, etc or incorrect minutes with everything I was trying.
This works perfectly though!! Thank you...
July 24, 2018 at 9:55 am
ScottPletcher, that is exactly what I was looking for!!! With a few minor tweaks, I now have this is working beautifully.
You're awesome!! Thank you so much...very much appreciated!! 🙂
March 26, 2018 at 3:12 pm
Thank you pietlinden for that idea...DAX Calendar function seems like it might work well, but I think that was introduced in SQL 2016. I'm on SQL 2014 still. :-(.
I...
March 23, 2018 at 1:51 pm
Thank you both!
Luis, your code was spot on!! Huge thanks! Very much appreciated.
October 4, 2017 at 1:47 pm
Amazing!! Worked exactly as I needed on the first try!
Thank you very much sgmunson for the super fast reply and incredible results! I think it is in fact much easier...
September 29, 2017 at 2:45 pm
In the end I get results like this:
Blank Row
Blank Row
Blank Row
Abbe
Adams
Arlyn
Blank Row
Blank Row
Blank Row
Bird
Bryn
Burn
September 29, 2017 at 12:05 pm
Ok, so I'd like to try and insert these blank rows via the dataset/stored procedure I have setup to see if that is easier(and this also gives me some...
September 29, 2017 at 11:27 am
Thanks again for all the advice Thom A.
I did land up getting this to work a round about way...I added 3 rows inside the group(at the top) and...
September 22, 2017 at 1:33 pm
Just one other clarification. I was not hiding for Z before. I wanted the 3 blank rows to appear after each group(A, B, C, etc), including Z at the very...
September 22, 2017 at 11:56 am
Hmm...that sounds almost like it would work, but won't I lose my blank rows after group Z then(they'll appear before Z it seems like)?
Maybe I could just have...
September 22, 2017 at 11:45 am
Thanks again Thom A!
So currently on my SSRS report I have the grouping(by the first letter of the persons last name) setup and my 3 lines inserting at the...
September 22, 2017 at 9:07 am
Thank you!! I was able to get it to work by using grouping on my tablix as you suggested. Took me a couple tries, but it is now working...
September 13, 2017 at 6:48 pm
Viewing 13 posts - 1 through 13 (of 13 total)