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 Mike Lewis 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. klkuab

    VS2015 / SSRS - ORA-01008 Not all variables bound

    Yes it is an Oracle error. The parameter is preceded with an ':' as that is what Oracle wants as opposed to the '@' which is a SQL Server thing. Thanks! '
  2. klkuab

    VS2015 / SSRS - ORA-01008 Not all variables bound

    We are converting our VS2008 reports to VS2015 and have come across an issue where some (not all) reports that have parameters are throwing an error ORA-01008 Not all variables bound. I have banged my head against the wall trying to figure out what is causing this. I ended up creating a brand...
  3. klkuab

    how to populate values when "not found" occurs

    I have 2 tables (table-A & table-B). They are defined as such: TABLE-A DEPARTMENT ACCOUNT TABLE-B DEPARTMENT ACCOUNT SPEND BUDGET TABLE-A is my driver for my query as it has all the departments and accounts, whereas TABLE-B only has records for the departments and accounts that have either...
  4. klkuab

    Trying to create a Report Totals page/fields

    I'm a newbie using Crystal Reports 10. I am in the process of creating a report and have come across an issue that has stumped me. My report needs to consist of 2 parts. The first part being the detail lines which is working fine, and the second part being the report totals page which is where...
  5. klkuab

    Problem with FULL OUTER JOIN

    I am trying to run the following sql but am getting an Oracle error ORA-00918: column ambiguously defined select b.acct_unit, sum(b.budget_amount), sum(s.spend_amount) from uabhssd.vwuabbudget b full outer join uabhssd.vwuabspend s on b.fiscal_year = s.fiscal_year and...

Part and Inventory Search

Back
Top