Search results for query: *

I am using views created in the SQL db to pull certain information The only other feature that may be causing the problem is that the report contains several sub reports in order to concatenate certain information How do I run the report in query analyser? Thanks for the reply - much appreciated

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

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

Thanks for the help James, doesn't need to placed in a view now Only needs to concatenated on a Crystal report (so different forum for me to search through ) I wish some people would make up they're minds, prior to annoying others Thanks anyway

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

Thanks - James Excellent work - It didn't matter which date that was pulled after - they were all the same anyway so your code worked perfectly Thanks for the time and effort Much appreciated

Thanks James Is there any way I can also pull the Effective Date for that policy into the report as well ANy help much appreciated

Sorry James piece of info left out of original thread The code you gave worked fine But I would like to report on clients so the selection for clietns would be based on weather the policy status was archived something like this appended to the statement WHERE Policy.Status LIKE 'Archive'...

Thanks for replying James I don't want to display the policy information per say I just want to create a list of clients that have archived policies so that I can export a list of archived clients So the policy information is secondary I just want CLient details name, address etc for all...

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

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

Sorry, Found out what the problem was - i neglected to actuaally build the subreport and just manually linked the master - child fields and run the report - jumping the gun was always one of my forte's Still sorted now!!!

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

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

That worked perfectly thanks Dgillz overlooked the null 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...