Viewing 15 posts - 91 through 105 (of 118 total)
In the report parameters dialog box, you can set the label and the value to be different. The label is what people see, the value is what is used.
For example,...
Leonard
Madison, WI
July 8, 2011 at 10:59 am
It sounds unlikely but could the data region on the report have some kind of filter within it, causing it to filter out records that are being returned from the...
Leonard
Madison, WI
June 27, 2011 at 10:28 am
Glad you got it figured out - thanks for posting back.
Leonard
Madison, WI
June 27, 2011 at 10:26 am
A wild guess, but whenever I can't get SQL 2005 to install, it's because of the MSXML component and the 'Microsoft Fix It: Fix This Problem' button on this page...
Leonard
Madison, WI
June 24, 2011 at 11:32 am
I'm enjoying the T-SQL questions this week!
Leonard
Madison, WI
June 23, 2011 at 8:15 am
Assuming your 2nd report has a parameter for the client...
In your first report, right click on the Field Country and select Properties. Select the Navigation tab. Where you have the...
Leonard
Madison, WI
June 14, 2011 at 8:31 am
I don't know how to do that specifically, but could you have 2 parameters (1 that is populated via a drop-down, and one that is a plain text box) -...
Leonard
Madison, WI
June 14, 2011 at 8:26 am
Click 'show details' and then click the 'edit' icon next to the folder.
Leonard
Madison, WI
June 9, 2011 at 9:07 am
I see no problem with more safety nets. Honestly, it's not that hard for wizards to provide more contextual information about how you might want to configure different options. (E.g....
Leonard
Madison, WI
June 9, 2011 at 8:52 am
You'll want to use a matrix (which allows for a variable number of columns). You should be able to find lots of resources/free tutorials by searching.
What is SSRS 2003 out...
Leonard
Madison, WI
June 6, 2011 at 10:57 am
Our primary system (not SQL server) has an encrypted password key table which keeps the archive of old passwords. When we do a backup, we select which key we want...
Leonard
Madison, WI
May 27, 2011 at 8:26 am
Honestly my approach would be trial and error. Take the flat file, split it in half and try doing each half separately. If one half works and the other doesn't,...
Leonard
Madison, WI
May 26, 2011 at 8:43 am
Could it be a problem with the flat file? E.g. a record without enough columns or where the columns are mis-aligned causing text to appear in the integer column...
Leonard
Madison, WI
May 25, 2011 at 1:17 pm
I've started using T-SQL Unit to create tests of assumptions about the data (since most of our data comes from 3rd party applications that I have no control over). I'm...
Leonard
Madison, WI
May 20, 2011 at 9:29 am
Viewing 15 posts - 91 through 105 (of 118 total)