Multiple CMC and Report problems

[Former Member]

Hello all,

I've got problems and I'm not sure if they are related. I've got reports that I developed in Crystal Reports XI. I just installed Crystal Server 2008 on our development machine. I published a report (lets call it r1) and logged on to InfoView as the end user to test it. On refresh, an error was given, log on info incorrect or incomplete. After much research I made a small test report to see what would happen, and it worked fine. I saved r1 under a different filename and changed the database connection, published, and it worked on refresh.

I don't know what's going on, but another report (lets call it r2) I've tried to do that way simply won't work. It will open as it was saved and published. I've tried to match the permissions to r1, everything looks the same, but it won't refresh. I finally decided to just run the reports overnight after the data load, and r1 shows success, but r2 failed with the incomplete or incorrect logon credentials. Looking at r1 in InfoView shows it as it was yesterday, instead of how it is supposed to be today. Clicking refresh gave today's data, but it's supposed to do that without refreshing. r2 wouldn't even load, clicking it had no effect.

I've been struggling with this all week, changing permissions all over the place, changing data sources in the designer, so many things. I've been trying the repository route this afternoon, but trying to save a file to it gives invalid file handle errors.

So the designer is on Vista, the server is on Server 2003, hooking up to SQL Server 2000, using OLE DB. Tried ODBC, couldn't even connect in designer. Tried to make a universe, but I don't know anything about how to use it if I were to get it going. Double clicked on that in the data source window in the designer, but the window that popped up had nothing to choose, so I had no chance to figure it out.

I'm sorry if I sound a little scattered, it's been a very frustrating week. Let me know what other info you need, and thank you for reading my plea for help.

[joshua_kuhn]

There was a lot in your post, so bare with me.

"log on info incorrect or incomplete" - This message occurs because the report lacks the correct database login info to connect to the datasource. If this is a crystal report object you are refreshing, the database login has to be set in the CMC for this particular report object. In the CMC, navigate to and right click on the report object. Add the username & password to the database credentials.

The issue about the report showing yesterday's data and not the recent data sounds like you were viewing the scheduled instance. When you view the latest instance or another instance from the history window, you should only see the data that the report was scheduled with. If you click the 'refresh' button in the report toolbar, then the report will fetch new data. If you are logged into InfoView and choose "View", this should fetch the most up-to-date data from the database. - again, assuming this is a crystal report document.

[Former Member]

I was having trouble following your post as well but can also happen if there is some sort of problem connecting to the database.

So, are you using sql server authentication? Do this rather than Windows Authentication. Try and run the report in Crystal Reports on the server. What happens then?