Crystal Reports

[kayos592]

Hello All... Ok, here is the situation. We have a stored procedure which creates a User Temp table... ie. user1.FinalTable We then have a crystal report which has a db query in it that accesses this user tables. This worked fine for 6months[where crystal would automatically select the user table of the user who ran the report] ie. user bowser would have his data display from bowser.FinalTable. However, NOW, the report is pulling up the first person with that user table in an alphabetical order. ie. if user bowser runs the report.... his table bowser.FinalTable is created...but the data in the report is from alpha.FinalTable. If we delete alpha.FinalTable he would then get the data from america.FinalTable (again...this is alphebetical). Anybody have any idea why this is happening? The DBA's swear that nothing changed on the server but I think something in the permission realm changed causing this change in the report behavior. -Kay