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!

Register Log in
  • Congratulations Chris Miller 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. ebell1

    ERROR [07002] [Microsoft][ODBC Excel Driver] Too few parameters. Expected #

    I am using the lookup function to place data into my main report. I have 9 additional datasets and everything is working fine. However when I added my 10 dataset I need to sort the data so that just the last date would show on the report. I wrote the query as SELECT [Task_Type]...
  2. ebell1

    Syntax for an expression

    I have a Crystal Report that I am converting to SSRS. In a formula in Crystal Report it uses a not one of. See the example below: whileprintingrecords; numbervar sample; if {pr_proj_job_pay.a_job_class_code} <> "XXXX" and {pr_proj_job_pay.a_pay_type}in [10, 20, 30] then sample := 0 else if...
  3. ebell1

    IIF statement does not work as anticipated

    I am using a tablix. I get just the Fields!line1.Value. If the Fields!line1.Value is blank I see nothing. I did get this to work I made the iif statement as follows: =iif(Fields!db_bud_desc_line1.Value < "A",Fields!a_account_desc.Value,Fields!db_bud_desc_line1.Value)
  4. ebell1

    IIF statement does not work as anticipated

    I am new to SSRS and trying to write an IIF statement. My Crystal If Then statement is as follows:if {Field_line1} = "" then {Field_account_desc} else{Field_line1}. This works fine. In SSRS I wrote an IIF statement=iif(Fields!line1.Value = "",Fields!account_desc.Value,Fields!line1.Value)...

Part and Inventory Search

Back
Top