Viewing 15 posts - 481 through 495 (of 497 total)
Two options:
1. Use a footer with conditional visibiltiy
2. Just put the textbox after your tablix. It should print at the end of the report.
Gerald Britton, Pluralsight courses
April 21, 2014 at 8:29 am
I regularly pass many parameters to Stored Procedures in Execute SQL tasks or OLE tasks in the Data Flow. Adding two is just as easy as adding one
Gerald Britton, Pluralsight courses
April 10, 2014 at 1:28 pm
I think you'd be better off to either design the job in BIDS (SSDT in 2012) or build a Sql Agent job with the steps you want. You could...
Gerald Britton, Pluralsight courses
April 10, 2014 at 11:25 am
I was able to get the desired output by adding a row to the sample data when the end date is outside the range in the sample data, like this:
;with...
Gerald Britton, Pluralsight courses
April 10, 2014 at 8:37 am
Try your query on some test data rather than live data. Experiment with various lengths of input. It smells like and even/odd problem, but without real data to...
Gerald Britton, Pluralsight courses
April 10, 2014 at 6:28 am
You don't have any constraints on the CustomerName column, so SQL doesn't know where to look specifically so it has to look everywhere.
Also, this is really fake partitioning. Have...
Gerald Britton, Pluralsight courses
April 10, 2014 at 6:23 am
miles_lesperance (4/9/2014)
Gerald Britton, Pluralsight courses
April 9, 2014 at 12:45 pm
jeffhibbert (4/9/2014)
Gerald Britton, Pluralsight courses
April 9, 2014 at 12:19 pm
One thing you could do is define two datasets that share the same datasource -- one for "34" and one for "35". Then it's no problem adding the totals...
Gerald Britton, Pluralsight courses
April 9, 2014 at 12:08 pm
Well, if you run the report interactively and save it in Excel format, you're prompted for a location and filename. You can put in anything valid.
Gerald Britton, Pluralsight courses
April 9, 2014 at 12:03 pm
mcfarlandparkway (4/9/2014)
I have an SSRS report where I am grouping the table with system Name
when I click on ALL in...
Gerald Britton, Pluralsight courses
April 9, 2014 at 12:01 pm
What formatting have you specified for the TextBox under the Number tab?
Gerald Britton, Pluralsight courses
April 9, 2014 at 11:58 am
SSRS designer caches query results by default. So, if it has cached results, it won't rerun the query at all
Gerald Britton, Pluralsight courses
April 9, 2014 at 7:10 am
mcfarlandparkway (4/8/2014)
Here is my stored procedure;I am trying to use ReimbursementTypeID column in top select statement but its showing error...
Gerald Britton, Pluralsight courses
April 8, 2014 at 11:42 am
Try using the CountRows() function in the row visibility tab
Gerald Britton, Pluralsight courses
April 8, 2014 at 11:38 am
Viewing 15 posts - 481 through 495 (of 497 total)