Are the posted questions getting worse?
- Jason A. Long - Wednesday, May 3, 2017 3:46 PMApparently there are far too few people who know how to do green bar in an SSRS tablix...
So here's how...1) Go to the Report Properties dialog box and select the Code tab and paste in the following code...
Private bOddRow As Boolean
'*************************************************************************
' -- Display green-bar type color banding in detail rows
' -- Call from BackGroundColor property of all detail row textboxes
' -- Set Toggle True for first item, False for others.
'*************************************************************************
Function AlternateColor(ByVal OddColor As String, _
ByVal EvenColor As String, ByVal Toggle As Boolean) As String
If Toggle Then bOddRow = Not bOddRow
If bOddRow Then
Return OddColor
Else
Return EvenColor
End If
End Function
2) Put focus on the left-most cell in the details section and look for the "BackgroudColor" property in the properties section and paste in the following expression...
=Code.AlternateColor("#d7e4f4", "Transparent", True)For all the remaining columns (2 - N) do the same thing but use a slightly different expression... (switch from "True" to "False")
=Code.AlternateColor("#d7e4f4", "White", False)Congrats, you now have legit "green bar"... On in this case (using #d7e4f4) "blue bar".
Well, actually, if you want the true green bar (or blue bar) effect it should be every three lines alternating color, not every line alternating color. That is how the real green/blue bar paper looked like when I worked as a computer operator and actually printed reports using high speed line printers back when dinosaurs shared the planet with us.
- Lynn Pettis - Wednesday, May 3, 2017 4:47 PM
Fair enough... Unfortunatly I didn't write that wee bit of VB myself... I'm certain that toggling every 3 rows would be doable for someone better versed in writing VB or C#.
Either way, the same methodology should work. - Lynn Pettis - Wednesday, May 3, 2017 3:36 PM
Maybe they got sick of people asking for more information. In my experience, SO was more of a quick, one-line answer forum back when I used it several years ago. When I posted something that was flagged as too detailed and the one-line answer marked as the answer wasn't the best approach, I turned my back and never looked back.
- Jason A. Long - Wednesday, May 3, 2017 5:17 PM
I remember he stone ages. The old 132-column printers could spit out COBOL code like nobody's business. I don't miss the days of the mainframe.
- jasona.work - Wednesday, May 3, 2017 1:16 PM
The daily struggle of the report writer.
'I'd like a report that shows me this'
'You realise you'd get more meaningful data on the back of a cereal box'
'Will I? Never mind, build the report anyway.'
.
.
.
'This report doesn't show me what I need to see. I think it would be better if it did this':crazy:
On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a PhilosopherHow to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
- Lynn Pettis - Wednesday, May 3, 2017 3:36 PM
I'd say this is more evidence for multiple people using one account. The way the answer is written is very different from some of the questions posted here. That user name and avatar look very familiar though.
On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a PhilosopherHow to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
- jasona.work - Wednesday, May 3, 2017 8:14 AM
I was once asked in an interview about what level I believed I was.
"Better than average, but I think 'average' is pretty low.". At that time I had worked with a contractor who actually generated more work than he completed and had come across a Dev DBA who's CV looked amazing and was truly awful.
- Jason A. Long - Wednesday, May 3, 2017 3:46 PM
Depending on the complexities of the report
IIf(RowNumber(Nothing) Mod 2, "White", "Green")Far away is close at hand in the images of elsewhere.
Anon. - Ed Wagner - Wednesday, May 3, 2017 6:17 PM
Stack Overflow is pretty much unusable.
- Beatrix Kiddo - Thursday, May 4, 2017 3:09 AM
I', really not a fan of it either. I remember finding it quite difficult to get along with.Trying to paste code in and it telling me I had to indent it all (it was), so ended up asking questoins without my code. Unsurprisingly, I was asked for the code in question, which I couldn't paste! I even tried uploading it else where and putting the link in my post, but you had to have "reputation" to put hyperlinks in your posts...
I've never posted again, and never use it unless it comes up in a Google search. First Impressions are everything 😛
At least here I can paste my SQL (although SSC takes my formatting and spits it after it's had a nice blend 🙁 ).
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk - Thom A - Thursday, May 4, 2017 3:18 AM
SELECT GarbleGargleBlaster being #()*%$JGFGFS
- RandomEvent - Wednesday, May 3, 2017 7:56 AM
Heh... too funny. But, no. The BI Developers aren't oxymorons. It's just BI (IMHO) that frequently is. I've seen too many people be thrilled with pretty stuff and the ability to quickly stack and restack pivots and a whole bunch of other information and still come to the wrong conclusion. It cost 1,500 out of 3,000 people their livelihood at a company I once worked for because the officers of the company (lowest level all the way to the GM) didn't listen to what the data was saying even when someone tried to point it out. Using the same "pretty pictures" they were using, I predicted the month and year they would need to do the layoffs two years ahead of time and couldn't get anyone to listen.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
Jeff, I take it you weren't there by the time that month and year rolled around?
EDIT: as in left under your own power because you could see the hammer coming?
- Thom A - Thursday, May 4, 2017 3:18 AM
Whether using FireFox or IE, I've found that the "patch" for that is to make sure that you use the "tabs to spaces" option in SSMS and, when you're ready, copy your code, paste it into NotePad, copy that and paste it into the SQL IF Code block.
It's a real shame that the upgrade screwed up the code windows so bad. After the last upgrade (more than a decade ago, it seems), they had similar problems for years and finally got it mostly right even with a direct copy'n'paste from SSMS. You would think that they'd have applied some of that old code to the new stuff here. They really need to make it a whole lot easier for people to paste code and have it be somewhat readable.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) - Brandie Tarvin - Thursday, May 4, 2017 6:24 AM
No... I stayed knowing the hammer was coming and even after the hammer fell for a couple of reasons. The first reason was that I mistakenly thought that I could help prevent it by showing people how to analyze the very reports (all on paper back then") that I had helped to create. The second was that was in a position to help and NavSea and SeaBat (two departments of the Navy) loved me because I was the non-standard-parts Committee Chairman (think "DBA" for over expensive materials), an expert on several cabinets of a multi-million dollar sonar system (electronics, installation, troubleshooting, parts sources, etc, etc), had a major impact on cutting costs and preventing waste, design advisor, electronics testing advisor, and was the first person that figured out how to and actually did downloads from the IMS and other mainframe systems to make the reporting on these new fangled things called "PC"s (another fellow and I formed the "PC Support Group") on Lotus Symphony spreadsheets, built and installed more than 1,500 PCs, and created/taught classes on how to use them not only to create their own reports but how to use them to analyze the "going out of business" trend that I saw. I stayed after the layoffs because I continued to have a pretty good impact on the quality and safety of the sonar systems we delivered to the Navy, which helped keep a lot of people that were "at sea" on subs and surface craft ("targets" as I affectionately called them) a whole lot safer. I also thought that my efforts in the computational world and the trust I was building for the company with the Navy might help win more contracts so that the people that did get laid off might be able to be hired back.
Overall, I was with the company for 15 years before someone made me an offer I just couldn't refuse.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
Viewing 15 posts - 58,426 through 58,440 (of 66,738 total)
You must be logged in to reply to this topic. Login to reply