Viewing 15 posts - 301 through 315 (of 2,278 total)
I would do this in a single table with grouping and a visibility toggle.
August 10, 2012 at 6:46 am
Ray K (8/10/2012)
opc.three (8/9/2012)
SQLRNNR (8/9/2012)
JAZZ Master (8/9/2012)
Cliff Jones (8/9/2012)
Scott D. Jacobson (8/9/2012)
Daniel Bowlin (8/9/2012)
Ray K (8/9/2012)
55(as in, number of days until I depart for my Hawaiian vacation!!! :w00t::hehe:)
Double nickels
On the...
August 10, 2012 at 6:43 am
Ray K (8/9/2012)
55(as in, number of days until I depart for my Hawaiian vacation!!! :w00t::hehe:)
Double nickels
August 9, 2012 at 7:00 am
I suggest you set up a framework to log SSIS package progress. It will make troubleshooting these issues much easier. Andy Leonard may have a blog on the...
August 8, 2012 at 2:09 pm
This is a sin in terms of query optimization but you could use
WHERE LEFT(Agency,1) IN (Your 1 character values here)
You could also do this with an additional query in your...
August 8, 2012 at 2:04 pm
If you use something like
MAX(Budget) OVER(Groupname column) AS GroupMax
as an additional column in your existing query ( not a new query, just a modification) you should be able to sum...
August 8, 2012 at 1:57 pm
You might be better off using the visibility propery of the sub report.
August 8, 2012 at 9:12 am
SSRS is a great tool for canned reports, and reports that need a variety of parameters. It is not a what-if tool. Most people understand Excel, so I...
August 7, 2012 at 12:02 pm
Then there is the other end of the spectrum. I once had an interview that was 8 x 30 minute sessions with a total of 13 people where they...
August 7, 2012 at 11:30 am
weston_086 (8/6/2012)
=round(Fields!MegaBytes.Value,0).ToString() & " " & (round(Fields!MBPerSub.Value,0).ToString())
it is giving...
August 7, 2012 at 8:33 am
Company details would be your detail row data. Above that you want a parent group with the company. Above that you want another parent group for the unit, and...
August 7, 2012 at 8:30 am
opc.three (8/7/2012)
JAZZ Master (8/7/2012)
Scott D. Jacobson (8/6/2012)
Rob Schripsema (8/6/2012)
Revenant (8/6/2012)
JAZZ Master (8/6/2012)
crookj (8/6/2012)
SQLRNNR (8/6/2012)
salt n peppaSuga n Spice
Snips n Snails
Nips and Tucks
Fits and Starts
Bangers and mash?
Fish and chips
Sausage and Peppers
Lunch
August 7, 2012 at 8:25 am
Unless you need the extended international character set, you should probably stay with varchar.
To change all the reports I would open the reports code (view code) and do...
August 6, 2012 at 11:13 am
Viewing 15 posts - 301 through 315 (of 2,278 total)