How do i pull out user information before generating main report (which uses user information)
Hi Expert,
I want to pull out user information before generating main report, so that i can use user inforamation in generating main report.
I tried
(1) Sub-report with record selection - {USR_Stage.ID_USER} = CurrentCEUserName, and pulled user information. i used shared variables to use in main report, however i could not be able to use shared variables in record selection of the main report.
(2) sql expression able to pull user information, unfortunately i could not be able to use shared variables, niether formulas in it.
Basically, we have many departments in our and the users are allowed to see data for their own department only, because of that i am trying to create a report which identifies an user and then the report will show only data for department which user is belongs to.
Thanks
I want to pull out user information before generating main report, so that i can use user inforamation in generating main report.
I tried
(1) Sub-report with record selection - {USR_Stage.ID_USER} = CurrentCEUserName, and pulled user information. i used shared variables to use in main report, however i could not be able to use shared variables in record selection of the main report.
(2) sql expression able to pull user information, unfortunately i could not be able to use shared variables, niether formulas in it.
Basically, we have many departments in our and the users are allowed to see data for their own department only, because of that i am trying to create a report which identifies an user and then the report will show only data for department which user is belongs to.
Thanks
Kurt Reinhardt
The correct method for accomplishing your goal would be to use a Business View as the data source for your report. Business Views allow both row and column level security. Properly written and filtered against User Groups, a report based on a Business View will allow you to schedule an instance once and whomever views it will only see the data they're suppose to see.
As you found out you can't use a shared variable in the record selection however you can link the subreport to the main report on a formula that returns the CurrentCEUserName as its value. The link can be used for filtering data.
mlmcc
mlmcc
ASKER
HI mlmcc
Please could you be able explain me how to link sub-report to the main report?
with an example if its possible.
thanks
Please could you be able explain me how to link sub-report to the main report?
with an example if its possible.
thanks
Look at this sample
To see the links
Right click the subreport
Click CHANGE SUBREPORT LINKS
mlmcc
Q-27501630.rpt
To see the links
Right click the subreport
Click CHANGE SUBREPORT LINKS
mlmcc
Q-27501630.rpt
ASKER
Hi mlmmc,
Thank you for prompt reply, unfortunately this logic is for sub-report (main report to sub-report), however i am looking users information before generating main report (data from sub-report to main report).
I think I could have not explained in my question, though I will explain my scenario here:
(1) We have existing more than 400 reports all together, and more than 15 different departments, so 400 mutiply 15 = 6000 reports are in the system (Business Object XI)
(2) Each department has 400 reports in the respective folders which shows their own data
(3) Users are been set up with access to their own departments folder, however the reports are exclusively made for their departments only.
(4) I think, instead of maintaining 6000 reports department wise, why can not we maintain 400 reports which identifies user & users department before generating main report.
(5) So I want to know users department before generating main report (which is already exists in the system)
Hope this will clarify more than before.
many thanks
Thank you for prompt reply, unfortunately this logic is for sub-report (main report to sub-report), however i am looking users information before generating main report (data from sub-report to main report).
I think I could have not explained in my question, though I will explain my scenario here:
(1) We have existing more than 400 reports all together, and more than 15 different departments, so 400 mutiply 15 = 6000 reports are in the system (Business Object XI)
(2) Each department has 400 reports in the respective folders which shows their own data
(3) Users are been set up with access to their own departments folder, however the reports are exclusively made for their departments only.
(4) I think, instead of maintaining 6000 reports department wise, why can not we maintain 400 reports which identifies user & users department before generating main report.
(5) So I want to know users department before generating main report (which is already exists in the system)
Hope this will clarify more than before.
many thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Are these reports written in Crystal or BO?
My method would work with the subreport, however in view of thenumber of reports, I agree the effort would be tremendous. I believe rhinok has suggested a viable solution.
mlmcc
My method would work with the subreport, however in view of thenumber of reports, I agree the effort would be tremendous. I believe rhinok has suggested a viable solution.
mlmcc
They're written in Crystal Reports and published in BusinessObjects Enterprise XI R2. Unfortunately, the effort will still be tremendous - you should definitely consider this a project and devote resources, estimate time and expenses, etc... if you decide to do this. This isn't something you can "fix" via forums, unfortunately. It really has to do with how you've designed and deployed your Enterprise reporting system.
ASKER
Hi Experts,
thank you.
I am ready to pay :)
thank you.
I am ready to pay :)
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.