SQL Server Performance

searc functionality

Discussion in 'SQL Server 2005 Reporting Services' started by PatDeV, May 1, 2007.

  1. PatDeV New Member

    Hi I am trying to create report that can search in database for sertain informaion.

    I have Database souce in Access which has linked table to Oracle dababase. that's only thing i can have access to so have no other choice to go direct Oracle database!

    I have following similiar query to have report

    select dt.test_Name, dt1.address,dt.zip, dt1.contactinfo
    from deadtable dt
    join deadtable1 dt1 on dt.test_nbr = dt1.test_nbr

    where
    dt.test_name like ? --> this is the parameter i am trying to use to pass information in.

    is there a better way that i can use please advise.

    Thanks

    Thanks!!
  2. satya Moderator

    Are you running this query in SQL SErver?
    Have you defined linked server connection to other data sources correctly?.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  3. PatDeV New Member

    yes i am running this query in Reporting services. the Data source to Access which has linked tables of Oralce database is defined correctly. It works fine but when i try to put search parameter, which i have little knowledge about, so i am trying to use ? as parameter since access or oracle does not like named parameters!!

    thanks

    Thanks!!
  4. satya Moderator

    Then as per your other question you have to built a temp.table to extract rows from Oracle to SQL and then use this search functionality.

    I'm not sure how you can achieve but if you have a Microsoft support you might take that route to achieve the task.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  5. PatDeV New Member

    what i have is access database that has linked tables from oracle.

    Now i create data source in reporting service that will have access to the access database.

    and i am creating report. But i am trying to use parameter in the reports that will help me to search for any string in to database using ? parameter. but i want ti make it as that i can search for any letter such as if i type ABS in parameter text box then it would give me all the name that contains ABS just like like function in SQL.

    but i don't know in in this matter what to use?

    thanks

    Thanks!!

Share This Page