Viewing 15 posts - 181 through 195 (of 309 total)
I ended up adding a non-clustered index and it went from 11000 logical reads to 3 logical reads.
June 27, 2014 at 11:07 am
Resolved. 😀
Had some issues with the network. Network admin had to tweak something, but it is working fine and I am able to connect.
June 25, 2014 at 7:01 am
New Born DBA (6/17/2014)
This is a strange behavior. I don't know what I am missing? It is showing month+year for all the months except January: unsure:See attachment:
I see what the...
June 17, 2014 at 8:36 am
This is a strange behavior. I don't know what I am missing? It is showing month+year for all the months except January: unsure:
See attachment:
June 17, 2014 at 7:52 am
thomashohner (6/17/2014)
Try this in your SQL query then feed it into your report.
DATENAME(MONTH, Requested_Start_Date)+ ' ' + DATENAME(Year ,Requested_Start_Date) AS MonthYear
Can't try that in my query since I...
June 17, 2014 at 7:36 am
thomashohner (6/17/2014)
Try this in your SQL query then feed it into your report.
DATENAME(MONTH, Requested_Start_Date)+ ' ' + DATENAME(Year ,Requested_Start_Date) AS MonthYear
I don't know if I am supposed to...
June 17, 2014 at 7:25 am
pietlinden (6/16/2014)
Like this...=MonthName(Month(Fields!DueDate.Value)) & " " & Year(Fields!DueDate.Value)
just change DueDate to your field name.
Thank you so much. It worked.
June 17, 2014 at 7:03 am
Not being familiar with SSRS
Me Neither
it looks like you just need to concatenate a space and the YEAR value of Requested_Start_Date.
How would I do that. I mean what would...
June 16, 2014 at 12:18 pm
thomashohner (6/10/2014)
June 10, 2014 at 7:49 am
Luis Cazares (6/9/2014)
It's normal that you get an error if you're using distinct and ordering by a column that's not returned in the select.
You...
June 10, 2014 at 7:06 am
Luis Cazares (6/9/2014)
How do you get the parameter list? Is it a query where you could you simply add a DISTINCT?
When I run a query without DISTINCT, it works fine...
June 9, 2014 at 2:24 pm
Luis Cazares (6/9/2014)
How do you get the parameter list? Is it a query where you could you simply add a DISTINCT?
This is what I did. (see attachment)
June 9, 2014 at 2:14 pm
I was able to create a parameter but there are some issues I am running into and wondering if I can get some help from the community? I also included...
June 9, 2014 at 9:54 am
Sure, I will try to give you as much information as I can.
I have this report which I created but my manager wants to be able to sort it out...
June 2, 2014 at 12:32 pm
Viewing 15 posts - 181 through 195 (of 309 total)