Viewing 15 posts - 1 through 15 (of 28 total)
IKm looking for two columns to in SSRS as Parameters.
So @StartD needs to be a column A in a Table and @EndD needs to be Column B in the same...
June 9, 2016 at 11:46 am
This is a date between statement do you read I said I am looking for a way to do something like this? I have
no idea if it possible? I need...
June 9, 2016 at 11:16 am
I thought I did. I am trying to find a way to use a Between statement with two different columns. The database I am working
with is highly encrypted and fractured....
June 9, 2016 at 11:06 am
There are no Dups in the original database as all of these are considered Key Values,
how would you begin to eliminate the dubs if they are key values.
Luis Cazares (4/29/2016)
April 29, 2016 at 1:12 pm
Correct. Except I have it working if you select just one. I am looking for it to select all of the values and give the option of all.
Thom A (4/29/2016)
April 29, 2016 at 1:01 pm
Your best bet would be Microsoft SQL Managment Studio with Visual Studio and SSRS
April 29, 2016 at 12:53 pm
In an Expression
pietlinden (4/28/2016)
multiple values where? In a multi-select parameter? In your report somewhere?
April 28, 2016 at 2:59 pm
"MSC000000002"&"C00303582"&"MSC000005747"&"MSC000006211"&"MSC000000067"&"C01938137"&"MSC000000061"
Still returns a blank set. Where as Just one value returns data
April 28, 2016 at 12:52 pm
John Rowan (4/22/2016)
April 22, 2016 at 3:04 pm
pietlinden (3/23/2016)
oh, use "" instead.
That works to display a Null however I now need it to remove the
record from the report all together it was doing this befor but...
March 23, 2016 at 9:56 am
pietlinden (3/23/2016)
oh, use "" instead.
That works to display a Null however I now need it to remove the
record from the report all together it was doing this befor but...
March 23, 2016 at 9:49 am
Update- I got the error fixed. Not entirely sure what it was. However I can tell you the @StartD and @EndD are correct. It is my mistake for not listing...
March 23, 2016 at 9:43 am
The Value expression for the textrun ‘Fund_Name.Paragraphs[0].TextRuns[0]’ contains an error: [BC30822] 'NULL' is not declared. 'Null' constant is no longer supported; use 'System.DBNull' instead.
March 23, 2016 at 9:20 am
Msg 156, Level 15, State 1, Line 15
Incorrect syntax near the keyword 'join'.
Michael L John (3/22/2016)
Select
pc.accountnbr 'account number',
qf.description 'Fund Name',
pc.checknbr 'Check Number',
p.fullname 'Pay Provider',
pc.amountpaid 'Amount...
March 22, 2016 at 3:03 pm
Really?
You said: You're missing the closing parenthesis for your cte.
You also have an additional semi-colon at the start and a missing semi-colon at the end of your query.
While...
March 17, 2016 at 2:19 pm
Viewing 15 posts - 1 through 15 (of 28 total)