Recent content by cutiger93

When a different username is used it created objects in the database with that username. In SQL Server if cognosuser is used to login and then cognosadmin is used then it will create another set of objects with the same name and different owners.

Run Profiler to see the exact SQL Statement

This may help or start you in the right direction if you are using SQL Server convert(varchar(10),[Model].[ImageSentLogTbl].[sentdate],101) Also look at the Functions in the Cognos and read the help on them. This will begin giving you what you want.

Did you ever get an answer on this one. I am in need of the same thing.

Did you ever get any advice on this or were you able to get it to work?

I thought I had the correct information setup for the System DSN on both my workstation and the server. Just for gigggles I deleted the dsn on both and then recreated them. It worked. Thanks for pointing me in the right direction Turkbear. Sometimes it is just getting that nudge in the right...

I am using ODBC connection type and I cannot preview it from the CMC.

Crystal Enterprise 10.0 When I run the report on my production database it works fine in CE 10, but when I try to run it against the MOCK database it gives me the following error. I have checked the database setup information and it seems to be correct. I actually created the report in CR...

mdyer, I had this same issue and I was able to resolve it by deleting my cookies. This allowed the proper viewer to be show. I do not think there is a way to turn off the Crystal Report Preferences link. I had to modify the code.

I would be interested in how you were able to export the info that you list into an excel spread sheet?

Problem: Shortcuts are showing up users but the abiltiy to view, schedule or look at history is not available. I have been able to duplicate and resolve this issue. You have to set the security on the report itself and not the shortcut. Once you set the security on the report, you can then...

You may want to delete your cookies. I have found that even though you switch the browser on the Admin side it will not change until you delete the cookies.

I have created shortcuts for some of my reports. Their is not an option to view them when I run the portal. When I log in as an administrator they work so I know this has to be some type of security issue. Crystal 10 Enterprise IIS 6 Windows 2003

Thanks for your suggestions. I am not getting across what I needs to be said. All I want is a listing of the reports when a user logs in that he/she has access to with out any folders. For example: User1 logs in and instead of seeing the folders and then drilling down into the reports I want...

We have had no problems and I have been running it for a few weeks. IIS 6 Windows 2003