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.
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.
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...
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.
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...
Sorry everyone. I did not do a good job describing what I want. So here we go.
Currently we have this layout
Home
|_ Favorites
Folder1 ---You can click on the folder to go the report.
Folder2
Folder3
Here is what I wish to have:
Home
|_ Favorites
Report1
Report2
Report3
Report4...
I would like for my users to be able to logon and see only their reports that have been assigned to them in a list view form. I do not want to use the folder view that is currently in CE.
Anyone have any experience or advice. I was able to do it in CE 8, but I have been unable to figure it...
I had a similar issue on CE 10. I changed the preference for each user to Advanced DHTML and then changed them back to Active X but it would not work, it stayed in HTML view. I finally was able to look through some code and see where it was looking for the cookie. I deleted my cookies and...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.