Maybe #2 knows about the header? Typos courtesy of Apple. Sent from my iOS device.
On Aug 22, 2013, at 6:14 PM, "Sherry Kissinger" <[email protected]<mailto:[email protected]>> wrote: That BDNA reports thing is buried in a 1 pixel footer on the bottom ...I know I changed it on the template that's in my Madison Usergroup .zip. I changed it from 'powered by BDNA" to "Thanks to John Nelson, aka #2".. But obviously, once you have it, you can change it to anything you like. In report builder, highlight the very very bottom; pulldown view, properties, then in the properties on the right that appeared, there is a button for "Property Pages", that's where you change that footer text. Header only on page 1? probably, but I never thought about it. Sherry Kissinger Microsoft MVP - ConfigMgr [email protected]<mailto:[email protected]> ________________________________ From: "Marcum, John" <[email protected]<mailto:[email protected]>> To: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>> Sent: Thursday, August 22, 2013 2:48 PM Subject: [mssms] RE: SSRS Reporting - Style based approach - #2 When the report spans multiple pages is it possible to put the header only on page 1? I have the header and report name and report description on all pages. That's wasting a lot of space. ________________________________ John Marcum Sr. Desktop Architect Bradley Arant Boult Cummings LLP ________________________________ From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Marcum, John Sent: Thursday, August 22, 2013 2:06 PM To: [email protected]<mailto:[email protected]> Subject: [mssms] SSRS Reporting - Style based approach - #2 Where is the value that's setting "Reports powered by BDNA. Visit us at http://sccm.bdna.com<http://sccm.bdna.com/> © 2001-2012 BDNA Corporation. All rights reserved" in the footer and how to change that? That is also a hyperlink to the BDNA website. I found two URL's in the database pointing to bdna.com<http://bdna.com> and changed those to an internal URL but I don't see that actually did anything. The footer still points to BDNA.com<http://BDNA.com> http://mnscug.org/blogs/number-2/206-2-ssrs-reporting-style-based-approach-part-4-template-objects <image001.png> ________________________________ John Marcum Sr. Desktop Architect Bradley Arant Boult Cummings LLP ________________________________ From: [email protected]<mailto:[email protected]> [mailto:[email protected]]<mailto:[mailto:[email protected]]> On Behalf Of Marcum, John Sent: Thursday, August 22, 2013 12:30 PM To: [email protected]<mailto:[email protected]> Subject: RE: [mssms] SCCM2012 Reports Got it setup before lunch. Converting all my custom reports this afternoon. :-) ________________________________ John Marcum Sr. Desktop Architect Bradley Arant Boult Cummings LLP ________________________________ From: [email protected]<mailto:[email protected]> [mailto:[email protected]]<mailto:[mailto:[email protected]]> On Behalf Of [email protected]<mailto:[email protected]> Sent: Thursday, August 22, 2013 8:57 AM To: [email protected]<mailto:[email protected]> Subject: RE: [mssms] SCCM2012 Reports No separate SSRS install needed. From: [email protected]<mailto:[email protected]> [mailto:[email protected]]<mailto:[mailto:[email protected]]> On Behalf Of Marcum, John Sent: Thursday, August 22, 2013 7:15 AM To: [email protected]<mailto:[email protected]> Subject: RE: [mssms] SCCM2012 Reports I don't know how I had not seen it before. We don't need a separate SSRS install right? It looks like we can simply create the style database right in the same SQL server where the CM database and SSRS already live. ________________________________ John Marcum Sr. Desktop Architect Bradley Arant Boult Cummings LLP ________________________________ From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Murray, Mike Sent: Tuesday, August 20, 2013 11:31 AM To: [email protected]<mailto:[email protected]> Subject: RE: [mssms] SCCM2012 Reports This looks pretty cool, Sherry. Looks like there’s a bit of work to get it going, but I like the idea. From: [email protected]<mailto:[email protected]> [mailto:[email protected]]<mailto:[mailto:[email protected]]> On Behalf Of Sherry Kissinger Sent: Tuesday, August 20, 2013 7:49 AM To: [email protected]<mailto:[email protected]> Subject: Re: [mssms] SCCM2012 Reports Yeah, a template will make your reporting infinitely easier. If you want to get fancy schmancy, grab this: http://www.madisonusergroup.com/2012/11/28/octobernovember-2012-meeting-notes/ Routine and Code blatantly stolen from John Nelson (with permission); let's you have really pretty reports, using your company's logos and colors. I start w/the Template based on that for everything, and don't think Report Builder 3.0 is any worse than the .ASP reports. Of course... I'm geeky enough that I build my queries first in Sql Management Studio first anyway... then open RB3.0; the template, Save As New Report, and paste in the query I've already vetted outside of Report Builder. Sherry Kissinger ________________________________ From: Daniel Ratliff <[email protected]<mailto:[email protected]>> To: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>> Sent: Tuesday, August 20, 2013 8:56 AM Subject: RE: [mssms] SCCM2012 Reports Yeah but that was maybe an hour, once, when you first setup. Then you could churn out reports in 15 minutes flat. Now it takes an hour just to do a single report in SSRS with all the design required. I haven’t tried Jason’s ‘save as’ trick to make a template though. Hope to test that later this week. Daniel Ratliff From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of [email protected]<mailto:[email protected]> Sent: Tuesday, August 20, 2013 9:50 AM To: [email protected]<mailto:[email protected]> Subject: RE: [mssms] SCCM2012 Reports I don’t miss it at all. Any idea how many times I had to fight with time outs, too many rows returned and hacking IIS to make it work? From: [email protected]<mailto:[email protected]> [mailto:[email protected]]<mailto:[mailto:[email protected]]> On Behalf Of Todd Hemsell Sent: Tuesday, August 20, 2013 7:17 AM To: [email protected]<mailto:[email protected]> Subject: Re: [mssms] SCCM2012 Reports I miss the old reporting. Management likes the new reporting. It is prettier. Old one was VERY easy to make a new report and publish it. Also very easy to go in and edit it. I might look around for a simple web app that executes SQL and returns it in a table.. On Mon, Aug 19, 2013 at 8:45 AM, Trevor Sullivan <[email protected]<mailto:[email protected]>> wrote: Greg, I agree overall with your analysis. It’s not an ideal solution, but personally I prefer to simply run SQL queries inside of SQL Management Studio (SSMS). It’s the easiest way for me to obtain raw data when necessary. Unfortunately, this doesn’t help for publishing information to end users. Cheers, Trevor Sullivan <image002.gif><http://trevorsullivan.net/> <image003.gif><http://twitter.com/pcgeek86> <image004.gif><http://facebook.com/trevor.sullivan> <image005.gif><https://plus.google.com/106658223083457664096> From: [email protected]<mailto:[email protected]> [mailto:[email protected]<mailto:[email protected]>] On Behalf Of Greg DeGuire Sent: Friday, August 16, 2013 10:53 AM To: '[email protected]<mailto:[email protected]>' Subject: [mssms] SCCM2012 Reports Is there any way to create a simple report the ‘old school’ way (2007)? By this I mean just entering SQL, typing all the joins, etc. and getting a report quickly – like the ‘grey bar’ reports from 2007? It just seems to me like ANY report in 2012 is a lot of needless clicking/width adjusting for even the simplest output… The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information. ________________________________ Confidentiality Notice: This e-mail is from a law firm and may be protected by the attorney-client or work product privileges. If you have received this message in error, please notify the sender by replying to this e-mail and then delete it from your computer. ________________________________ Confidentiality Notice: This e-mail is from a law firm and may be protected by the attorney-client or work product privileges. If you have received this message in error, please notify the sender by replying to this e-mail and then delete it from your computer. ________________________________ Confidentiality Notice: This e-mail is from a law firm and may be protected by the attorney-client or work product privileges. If you have received this message in error, please notify the sender by replying to this e-mail and then delete it from your computer. ________________________________ Confidentiality Notice: This e-mail is from a law firm and may be protected by the attorney-client or work product privileges. If you have received this message in error, please notify the sender by replying to this e-mail and then delete it from your computer. ________________________________ Confidentiality Notice: This e-mail is from a law firm and may be protected by the attorney-client or work product privileges. If you have received this message in error, please notify the sender by replying to this e-mail and then delete it from your computer. ________________________________ Confidentiality Notice: This e-mail is from a law firm and may be protected by the attorney-client or work product privileges. If you have received this message in error, please notify the sender by replying to this e-mail and then delete it from your computer. ________________________________ Confidentiality Notice: This e-mail is from a law firm and may be protected by the attorney-client or work product privileges. If you have received this message in error, please notify the sender by replying to this e-mail and then delete it from your computer. ________________________________ Confidentiality Notice: This e-mail is from a law firm and may be protected by the attorney-client or work product privileges. If you have received this message in error, please notify the sender by replying to this e-mail and then delete it from your computer. ________________________________ Confidentiality Notice: This e-mail is from a law firm and may be protected by the attorney-client or work product privileges. If you have received this message in error, please notify the sender by replying to this e-mail and then delete it from your computer. ________________________________ Confidentiality Notice: This e-mail is from a law firm and may be protected by the attorney-client or work product privileges. If you have received this message in error, please notify the sender by replying to this e-mail and then delete it from your computer.
<<inline: image001.png>>
<<inline: image002.gif>>
<<inline: image003.gif>>
<<inline: image004.gif>>
<<inline: image005.gif>>
