sqlcentral2 (2/21/2012)

---

with this query am getting months only for a single year - 2012 if user selects from

march to dec

i would get

march - 3

april-4

........

till december...

Daniel Bowlin (2/21/2012)

---

If you need all rows for some reason (you have a chart or something else that uses all rows) then a filter as Martin suggests is probably the...

Apply a filter on the table itself?

Martin Thomas-357229 (2/15/2012)

---

I would love to upgrade to 2008!

I have attached a screenshot with some dummy data in it to show the layout I have gone for where the vertical...

Thanks for the feedback. Pity you are not using SSRS 2008, because strip lines (in 2008) would have made it so much easier.

If possible, could you please post a screenshot...

devin.sills (2/14/2012)

---

OK so here is what I am doing:

create variable named test --- no value assigned, string datatype

right click flatfile connection, properties, expression, add expression as ConnectionString to the test...

Martin Thomas-357229 (2/14/2012)

---

Hello all.

I am looking for some help in creating a 'target line' on a bar chart in Reporting Services 2005. I am creating in-line bar charts in...

schwing2 (2/10/2012)

---

This might be a really stupid question, but I am building a few reports for a customer based on thier requirements. I am building them locally on my...

Wow...then I guess we apologize for trying to give you as much help and...

mike.welborn (2/9/2012)

---

Thanks Martin, but I am not certain that is the case. What I have done for an immediate "fix" is to simply delete the file rather than renaming it....

It could be that the handle on the file has not yet been released when the file system task is executed.

To see if this is the case, add a script...

You will need to cast your variable to String if it is any other data type, because you are building a string object here. You may also have to ensure...

Sorry not using windows authentication, so AD Groups would be out too.

Now I think you can follow better why I want to do such a complicated implementation of SSRS. Just...

The template issue is also an interesting challenge. A possibility that comes to mind, is to limit the available connections in Report Builder to a Dev/QA instance with less data....

Jon MM (2/3/2012)

---

You may be missing my point. My users are all coming...