Viewing 15 posts - 1,171 through 1,185 (of 2,278 total)
For each table, go to the grouping pane (not grouping properties), go into the advanced mode, highlight the appropriate row(s) and set the "RepeatOnNewPage" property to True.
May 26, 2011 at 8:33 am
I don't know why this might happen outside of data issues.
--Have you tried to run the dependent parameter query in SSMS with the exact same inputs?
--Try trimming both...
May 26, 2011 at 6:55 am
SQLRNNR (5/25/2011)
Brandie Tarvin (5/25/2011)
SQLRNNR (5/25/2011)
restartretread
retreat
Run away!! Run away!!
May 25, 2011 at 12:09 pm
I wasn't suggesting that you hard code the file name, merely that their might be file naming conventions that you can exploit. If all of one type of file...
May 24, 2011 at 2:50 pm
When you are talking about the app log, are you referring to the Windows log?
What does the Execution Results tab in SSIS say?
May 24, 2011 at 12:42 pm
If you can distinguish between the files by their name or something obvious. Create parallel datastreams that join in a union.
File1Source >> DerivedColumn to add missing columns...
May 24, 2011 at 12:39 pm
I would only return records 1 - 20 from the dataset to SSRS. If you do not want to restrict your sp to the top 20 records in each...
May 24, 2011 at 11:21 am
Long vacation weekend is over. :crying:
Fortunately (here in the US) another long weekend is coming right up this weekend. 😀
May 24, 2011 at 7:18 am
Use ROW_NUMBER(), partitioned by your group. Return only rows numbered 1 - 20.
May 24, 2011 at 7:10 am
There are bar code fonts available for download or puchase. Get the fonts, develop the report with the font, make sure the font is installed where the rdlc will...
May 24, 2011 at 7:07 am
Kiara (5/19/2011)
Ray K (5/19/2011)
WOTD: ark(as in [in his best Bill Cosby voice], "NOAH!!! I WANT YOU TO BUILD . . . ")
"Who dat?"
Lord, what's a cubit?
May 19, 2011 at 8:19 am
Personally I would not delete anything from the Catalog table. That is where your report definitions live and you may end up damaging your reports.
Microsoft does not support any...
May 18, 2011 at 12:13 pm
I am still not sure what you are trying to get here but I think this is it:
=IIF(Parameters!Product.Value<>"ABC",IIF(Parameters!Product.Value<>"XYZ","Whitesmoke",iif(max(Fields!Status.Value) = 1,"White",
iif(max(Fields!Status.Value) = 2,"White",
iif(max(Fields!Status.Value) = 3,"#BFBFBF")))),
iif(max(Fields!Status.Value) = 1,"White",
iif(max(Fields!Status.Value) = 2,"White",
iif(max(Fields!Status.Value) = 3,"#BFBFBF")))))...
May 18, 2011 at 9:09 am
dbmehta (5/18/2011)
I want to know how to handle parameter passing, below is a similar to what I need to do:
=IIF(Parameters!Product.Value="ABC" AND IF EXAM_STATUS =1 , "White"
...
May 18, 2011 at 8:23 am
Why not just add a very thin row for the interactive sort control below your label headers?
May 18, 2011 at 7:11 am
Viewing 15 posts - 1,171 through 1,185 (of 2,278 total)