Viewing 15 posts - 1,486 through 1,500 (of 3,505 total)
What are you going to use this for? I'm asking because in SSRS, this is really simple. You would add a tablix to your report surface, and just group by...
July 12, 2017 at 9:18 am
You don't have PowerShell? Why not download it?
July 11, 2017 at 10:49 pm
What if you did it using PowerPivot and DAX. There are functions for that. CLOSINGBALANCE stuff, etc. Is that an option? What did you intend to do with the data....
July 10, 2017 at 2:31 pm
Sort of an apples vs oranges comparison. They're used for different purposes. What's your end goal?
July 10, 2017 at 1:24 am
I hate to be ugly, but I really think you're over your head on this one. E-mail Albert Kallal and see. He wrote about designing something very similar on the...
July 8, 2017 at 2:21 pm
Albert Kallal wrote one of these several years ago. Or one very similar to this. Not sure if he used SQL Server as a back end, although he might have.
July 8, 2017 at 9:02 am
Sounds like homework. Pretty sure you're supposed to do it yourself. Try it and ask if you don't understand something.
July 7, 2017 at 6:22 pm
Do you mean as HTML? "This format" and showing a picture doesn't really help.
July 5, 2017 at 3:27 pm
If the expression you used to segment the records into the 30/70 split is part of your dataset, then it's stupid easy,
Open the report, switch to Design mode,...
June 28, 2017 at 11:52 pm
If you use COUNT and DATEDIFF() and GETDATE(), you're home free.
June 28, 2017 at 10:32 pm
June 28, 2017 at 2:16 pm
Haven't seen the book yet. I went to Robert Cain's presentation on SSRS 2016 at SQL Saturday DC and he covered some of the stuff in the book. He knows...
June 27, 2017 at 10:54 am
do you have double-byte characters in your text? If not, you don't need NTEXT at all.
June 26, 2017 at 2:06 pm
That sounds like an article in the making...
How people do it wrong.... and then how to fix it/do it correctly.
June 26, 2017 at 11:06 am
Viewing 15 posts - 1,486 through 1,500 (of 3,505 total)