Search results for query: *

I came across a good how to blog on this subject at the link below http://www.bidn.com/blogs/kylewalker/ssis/657/how-to-create-a-single-column-multiple-group-grouping-in-ssrs

oops forgot Oracle does not use the + to concatenate select * from mytable where name like '%' || :myparam || '%'

select * from mytable where name like '%' + @myparam + '%' or in case of oracle i think use this select * from mytable where name like '%' + :myparam + '%' i'm not sure this is what you are looking for

So here is the situation, I understand that when writing a sql statement using MySql that the parameter value is ?: Select column from some_table where column in (?) However I have not been able to successfully pass a multi value parameter in SSRS 2008r2 using the Allow multiple values...

This particular Stored Procedure is actually an interesting one as it is dealing with a linked server connection. Could that possibly be adhering the connection as the SSRS process is opening the connection to the stored procedure and then waits for the connection to the linked server? But that...

correction it is set to ON instead of OFF.

Yes I do. Could that possibly be the hang up?

The error message that I am receiving has got me stumped as it is almost humorous. I am using SSRS 2008r2 and have had quite success with it up until now. The error message I am receiving in is: ExecuteReader requires an open and available Connection. The connection's current state is closed...

The error message that I am receiving has got me stumped as it is almost humorous. I am using SSRS 2008r2 and have had quite success with it up until now. The error message I am receiving in is: ExecuteReader requires an open and available Connection. The connection's current state is closed...

I am currently using CR08 and have a question regarding the formula use in the Chart Expert area. using the Chart Expert, i clicked on the Data tab then on the TopN feature for the chart. I noticed a formula button and was wondering if i could exclude certain grouped fields using this tool. Or...

First off I am using CR08 connected to a MySQL db. My question is simply this, in using sub-reports passing parameters to the sub-report, the Parent(main report) has to execute first before the sub-report correct? If this is true then the report would stop if the Parent was null or would it...

If you have any Group Footer's you can hide or suppress them so that the Report Footer is right after the Details line. Otherwise I am not sure what you mean.

it sounds like you need to be using DrillDownGroupLevel but i could be wrong as there is not enough information to give a valid answer.

look into something like an OPENQUERY from Oracle to the MS Access ... again this is something like Turkbear suggested.

when you group by a date field there is an option for each day for each week for each two weeks for each etc. etc. Make sure that you have the right option checked as this sometimes will make the difference.

This will take some playing around but it consists of using Section Expert and then using the correct section that you want suppressed. Section Expert then formula box for Suppress (No Drill Down) where you would type DrillDownGroupLevel = 0; at this point you would need to see if that...

very close but modify the first line of both formulas as this should fix your problem. not expired: if {v_asset1.warranty_end} <= currentdate+30 then "Less than 30 days" because <= is the conditional operator. and for the warranty expired: if {column.warranty_end}= currentdate OR...

thanks but figured it out!!

I am trying to find out whether the last contact was between 7 and 14 days or 14 days or greater. If it was 7-13 then display 1 ... if it was 14 or more then display 1. however it appears that the formulas are looping, i have placed them both in the report footer and various other places but to...

Using CR 2008 OK here is the desired result: Total 7 days Total 14 days John Jones 1 0 Mike Smith 0 1 What's currently happening Total 7 days Total 14 days John Jones 6 0...