Search results for query: *

I'm wondering if this is even possible, as I have multiple one-to-many relationships? Should I use a subreport, since the left joins did not work, the data that is being returned is only returning one instace of the employee name.

I just gave this a try, and it still does not work. When I add the second table, it simply gives me the blank screen. However, the link is identical to the first linking, which is odd.

The formula that I have been trying is: if ({errors.enteredBy} = {Users.user_id}) ({Users.FirstName}+{Users.LastName}) else {Users.user_id} When I use this formula to check my data, it always returns the userid for entereBy, but it returns the same userid for ResolvedBy and CheckedBy -...

dbo.Users KeyID User_ID FirstName LastName 1 001 bob smith 2 002 jack black 3 003 dave sanders 4 004 chris farley 5 005 jane doe dbo.errors errorID EnteredBy ResolvedBy CheckedBy 1...

The equals will join one value, but will not return multiple values. I can link via one of the user_id columns. If I reference by multiple columns, I get a blank report.

I am rather new to Crystal Reports XI, and I have had a few issues with linking the data. I have a report that is linked off of a multiple tables in a T-SQL database (MS SQL 2005) The data that I am entering is from a table which contains user_id's and has a lookup table with the information...