CE Username pass to CR

[michelemm]

We have Crystal Enterprise and I want to pass the username from CE to the crystal report select expert to show the user only their information (owner="CEusername&quot. For example, If John logons then I want crystal reports to show all records that have Owner=John. The question is how to pass that info from CE to CR. I also do not want this to be a global change that will affect all reports.I hope someone can help me out!
TIA!!!
Michele

 

[reply]

In CE8.5 you may use Processing Extensions to accomplish what you are asking.

 

[reply]

In CE8.5 you may use Processing Extensions to accomplish what you are asking.

 

[michelemm]

Thanks. Do you know when 8.5 will be out? Is there a solution for 8.0 users?
Thanks!!!

 

[reply]

CE8.5 has been released for a few months now. In 8.0, you may have to resort to adding parameters to your reports and passing in the CE user name that way.

 

[basil3legs]

I have created a simple workround for this...

Bearing in mind CSP is all but glorified ASP, I have put the reports in numbered folders and then created an access user database containing their username, password and access level. When they first go to the reports, they only see the reports in the default folder but when logged in, the CSP (ASP) file uses their access level to display the list of reports in the relevant folders. It also changes the default report to show more detail for dirctors etc.
The user database and the CSP are located on the NT report server so security can be set up reasonably.

You can use the SQL Query:

SELECT SI_ID, SI_NAME FROM CI_INFOOBJECTS WHERE SI_PARENTID = 123 AND NOT(SI_OBTYPE = 1 OR SI_OBTYPE = 18)

to give you the last successfully run version of reports in the folder whose parent ID is 123 (in this example). You can get the ID from checking the properties of the links to the folders from the Crystal Management Console.

I hope this helps.

If you need more info, let me know.

 

[hkvijay]

Hi,
I do have the same kind of requirement. But the problem is Can I access CI tables directly using VC++ code?.

Thanks
Rgds
Vijay