kpwaran (2/18/2015)

---

I've SSRS Data subscription that saves files into Windows Share location. The report runs at various times of the day.

As soon as the file gets saved in the windows...

To do this add a matrix...

polkadot (8/20/2014)

---

can you provide a step by step for pulling in a table item, adding three columns, and getting the group by the one column for the remaining two?

For me...

You can set a parameter to allow nulls.

In the Report Data tab, right click on the Parameter name and choose Parameter Properties. The General screen has the...

rray 44280 (8/11/2014)

---

My users want me to edit an existing report to condition display text in the footer of a report based on what items are listed in the detail...

You can also use a shared Data Source that has credentials stored in it.

In SSIS, you could use the stored procedure sp_send_dbmail from msdb.

http://msdn.microsoft.com/en-us/library/ms190307(v=sql.105).aspx

There are 2 ways I have used it in an SSIS package.

1. Use sp_send_dbmail to run a query and attach...

happy55 (7/11/2014)

---

You are correct here when it is a simple case of just getting the data and emailing the report SSRS works but there are jobs for which I have...

I would suggest using SSIS for this.

First create a subscription for the report that writes the data to a text or csv file.

Create an SSIS package to read the...

We have a function that we use to split out the parameters from Reporting Services. I am not sure how it would handle the quotes. You would have to test...

Kheri (7/1/2014)

---

=iif(Parameters!prm_frequency.Count > 3, "ALL", join(iif(left(Parameters!prm_frequency.Value, 1) = "A", "Annual", iif(left(Parameters!prm_frequency.Value, 1) = "Q", "Quarterly", iif(left(Parameters!prm_frequency.Value, 1) = "M", "Monthly", "Weekly"))), "&"))

=iif(instr(join(Parameters!prm_frequency.Value, "&"), "A") > 0, iif(instr(join(Parameters!prm_frequency.Value, "&"), "Q") >...

is this what you are asking?

http://www.codeproject.com/Articles/195017/SSRS-Series-Part-II-Working-with-Subreports-DrillD#5

Firefox and Opera are not supported by SSRS. There may be a way around it though.

Google Chrome has an Extension called IE tab, which renders like Internet...

I did a test and it wasn't easy. I created a new column and added an expression - "=Q2/60"

You need to have quotes or Reporting Services tries to...

amadeu_j (5/20/2014)

---

I have default to enter a value of the parameters. Only one other table that I wanted to put a fixed parameter, how do I have the following expression

=Fields!qntafter.Value

as...