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

    no rowset returned error

    I have a report set up with CR 8.5 linking to an SQL 2000 DB The report pulls information relating to certain policies - and works fine for certain policies - however when viewing certain policies the error No rowset was returned for this table, query , or procedure Is returned followed by...
  2. Buzzmeister14

    Combine values into single field

    At the risk of soundnig dumb I have read faq183-2146 and am still confused how to apply it in CR 8.5 and SQL 2000 so will start from begining I have the following Data returned when looking at a particular policy inside SQL EndorsementId | PolicyId | EndorsementText...
  3. Buzzmeister14

    Create View from field concatenation

    At the risk of soundnig dumb I have read faq183-2146 and am still confused how to apply it to a view in SQL 2000 so will start from begining I have the following Data returned when looking at a particular policy EndorsementId | PolicyId | EndorsementText...
  4. Buzzmeister14

    No duplicates in query Confusion

    I have multiple tables in an SQL 2k DB The problem lies in creating a view for this database that only contains required information, making it easier to create a report at a later date There are three tables in question Client_Table, Policy_Table, Trade_LU Client Table has a primary key of...
  5. Buzzmeister14

    Parameter query question

    I am running a report on an access 2000 database there is a command button that promptts the user for a start date and then an end date and gives the clients due for renewal between those dates - the report is running fine However, I now want to change the report so that it returns the clients...
  6. Buzzmeister14

    Editing a subreport in access 2002

    I know I am running the risk of ridicule But I cannot for the life of me see where I can edit the fields and display of a subreport in MS Access 2002 Any pointers would be greatly appreciated
  7. Buzzmeister14

    print values from sql if they are not null

    I have a report set up , however Certain values need to be printed only if a the field is populated something along the lines of If {table.column} is not null then "the value is "table.column" " else (i.e when null) no line is printed A complete novice here so any/all help greatly...
  8. Buzzmeister14

    If then staement to enter text value

    I havea report that I'm building in CR8.5 from a DB on SQL2000 And would like to show a fixed text value if a condition is met have tried if {field_name} = 0 then "NOT TAKEN" however it does not display the nto taken when value is 0 Am new to CR any help appreciated ahev tried solutions...

Part and Inventory Search

Back
Top