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
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...
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.
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.