Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. skaestner

    How to create Access type drill down in SSRS 2008

    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
  2. skaestner

    SSRS 2008 Oracle LIKE with parameter - invalid number error

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

    SSRS 2008 Oracle LIKE with parameter - invalid number error

    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
  4. skaestner

    Multi value parameter SSRS and MySql

    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...
  5. skaestner

    ExecuteReader requires an open and available Connection

    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...
  6. skaestner

    ExecuteReader requires an open and available Connection

    correction it is set to ON instead of OFF.
  7. skaestner

    ExecuteReader requires an open and available Connection

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

    ExecuteReader requires an open and available Connection

    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...
  9. skaestner

    ExecuteReader requires an open and available Connection

    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...
  10. skaestner

    Group Sort Expert

    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...
  11. skaestner

    Clarification on Subreports

    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...
  12. skaestner

    How ro remove empty space in Details section?

    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.
  13. skaestner

    content always displays on the one line under where it suppose to

    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.
  14. skaestner

    Union query from 2 different datasource

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

    Grouping

    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.
  16. skaestner

    urgent: section suppression using true/false flags

    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...
  17. skaestner

    Warranty expiration info formula for --

    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...
  18. skaestner

    Formula Logic Problem

    thanks but figured it out!!
  19. skaestner

    Formula Logic Problem

    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...
  20. skaestner

    Formula Logic Problem

    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...

Part and Inventory Search

Back
Top