Viewing 15 posts - 31 through 45 (of 96 total)
TSQL Tryer (3/23/2015)
So I ended up using the following expressions in my report in order to default dates in SSRS
Work out first monday of the previous month.
=IIF(Weekday(DateAdd("m", -1, DateSerial(Year(Now()),...
March 25, 2015 at 12:48 pm
You need to let SSRS figure out what weekday the first day of the month is. Your formulas have 8 and 9 hard coded into them.
To get the first Monday...
March 24, 2015 at 9:50 am
venkat5677 (3/17/2015)
Hi,I want to know it there a way to open word file in ssrs, documents saved in sharepoint.
Thanks,
Ven
You can upload many types of files to the Reporting Services website....
March 20, 2015 at 9:42 am
kd11 (3/17/2015)
Edit Update. On...
March 20, 2015 at 9:40 am
Here is a link to a Technet article that describes feature availability. There is a table near the bottom that lists the Reporting Services features.
https://technet.microsoft.com/library/cc645993(SQL.110).aspx
March 20, 2015 at 9:29 am
PSB (3/19/2015)
I want to print the address information and country info in the text box(not tablix) when IsAccount field from Account dataset = 0
=IIF(Sum(Fields!Isaccount.Value, "Account") = 0,First(Fields!Primary_Address.Value, "Account"), "...
March 20, 2015 at 9:25 am
It would help to see the DateDiff calculation.
My first thought is to try putting a zero instead of "" for the false part of the statement.
March 20, 2015 at 9:19 am
I found this article on how it works.
http://blog.hoegaerden.be/2012/11/01/creating-multiple-column-reports/
Hope this helps. 🙂
Sarah
March 20, 2015 at 9:12 am
There are 2 things to do.
1.Add the labels for the detail fields
a.Right click on the Drive ID Group Header row, choose Insert Row, Inside...
March 12, 2015 at 2:24 pm
It looks like you need to put the fields in Group Header lines instead of Detail lines.
Right click on the group header, choose Insert Rows, Inside Group - Below.
Move...
March 11, 2015 at 10:27 am
david5515 (3/10/2015)
I have this parameter created
=iif(WeekDayName(WeekDay(today())) = "Friday",dateadd("d",3,Today()),dateadd("d",1,Today()))
However what this is doing currently is pulling through all data.
I only to want to see the data which is either a...
March 11, 2015 at 10:12 am
You can create an expression combining them. You have to be careful of data types.
=Fields!OUTCOME.Value + " " + Fields!OUTCOME_NAME.Value + " " + CStr(Fields!MEMO_FEEDBACK_ID.Value)
The ID field has an...
March 11, 2015 at 9:00 am
At first I thought it might be something to do with the data types and field sizes of the parameters. I looked at a bunch of reports and see that...
March 10, 2015 at 9:31 am
destrogiro (2/13/2015)
I'm developing a report and it has 3 datasets: 1 for a main report and 2 datasets for the subreports. My manager doesn't want to use ACTION to load...
March 10, 2015 at 9:22 am
The user has to have both SQL Access to run the report and access to the file share they are saving the report to. Do they have both of those?
March 10, 2015 at 8:32 am
Viewing 15 posts - 31 through 45 (of 96 total)