Search results for query: *

Hi guys, i'm looking for some help. I've searched this and other forums to no avail, so it could be me thats not looking for the right thing or something that isn't possible. Here goes.. We have a number of centres that are geographically diverse (i.e. miles apart). To help improve our...

Many thanks to everyone who provided assistance :) Craig

I think that i may have a solution for this. I've been playing about this morning and i think that the problem has been caused by the sheer amount of data in the project table. I think that my query was correct, but when Crystal was pulling the records back it was finding records for each...

Hi lbass, If i place all of the fields from both tables into the report, it lists all of the matching records, the nulls don't appear. I'm afraid that I can't attach a screenshot/ output as I don't have access to a web server to share the image. I've tried to verify the database and all seems...

Hi lbass I've taken the null conversion off, but it makes no difference. All of the fields are on and i've tried just the id's. I've also tried re-creating the report from scratch several times. Its just plain weird, that something that should be so easy is so hard to do!!

Hi I've tried the formula in the detail section - is that right? I've also included two fields - the project id and objective id, one from each table in the detail section. The null's still aren't appearing. Thanks for your help cw

the data is showing only the matched data, the nulls aren't being produced at either the top or bottom of the list cw

hi defo no record selections or criteria in place. i've also tried the same links etc... as a view in SQL Server and this doesn't include the blank rows either. Perhaps its a driver or SQL issue rather than Crystal? thanks craig

Hi Definatley no groups, no sorting and no group selections are in place. I've managed to change the join to left outer, the link type is = and enforced is "not enforced". Here's the SQL... SELECT "projects_strategic_objectives"."project_id"...

Thanks for the formula, the output doesn't seem to change. I'm still a bit confused as to where i'm going wrong, is it because the table containing the project/ objective ID "Table B" contains multiple rows for each project and that the lookup table, "Table A" services many rows in "Table B"...

Hi dgillz Thanks for the reply. I've made sure that the arrow is pointing toward the project table, checked the "Left Outer" option. I've also had a play with the enforced links. But for some reason it won't show the unmatched entries. C

Hi This problem has been driving me potty for some time now! I have an SQL Server 2005 database and am using CR XI. I need to produce a report that is printed copy of the information held on the database. The report will show all of the valid options that are available to be selected and...