Search results for query: *

Is it possible to suppress a column value based on the user who logged in? I am using CR XI rel 2 and trying to use the following IF Statement in conditional suppress formula: if CECURRENTUSERNAME="xxx" then true else false; but Crystal doesn't like it. it rejects the usage of...

Hi all, I am using CRXI and have a report based on an Oracle based Stored procedure. I need to make the parameter on this report as multi- value parameter which I cannot directly. So, I am doing something like this using a sub-report. Main Report: =============== Empty report with a...

Hi All, We are using BEXI Release 2 and are in need of finding what report is being access by what group[s] or users. Is there any way to build a query and fetch from BEXI Database? If so, does any one has a query available. I am incharge of generating this report and definitley do not want to...

Hi all, I am using CR XI Release 2 and have a report [summarized to Group] that I need to shade it grey or white alternatively. Unforutnately I do not want this on Details but it's on group level itself. Let me explain: I have grouped all the rows I am getting from my query and summarized like...

Is it possible to assign a variable value to go to parameter in CRXI? I am passing a shared value from main report to sub report and my sub report has a parameter which should accept this shared variable value as the parameter value. is it possible? Thanks

Does anyone know how can I capture special fields and pass them onto a formula or to a database? Eg: I want to capture users who log into BEXI [special field-> CEUsername] and using their username, I want to retreive some values from database? Any ideas? Thanks

Hi all, I am using Crystal Reports XI [BEXI] and a report I currently has, is using a parameter [from a view, dynamically] and when a user selects on the parameter, it displays all the values [same for every user]. Now, Depending on the user logged in, is there any way I can restrict values in...

Hi all, I am using CRXI reports designer and built a report that has 2 sub reports [not linked]. My Main report is just a place holder for these two sub reports main report | | Sub report1 Sub report2 in sub report1 I have some strings to be displayed which is...

Hi all, I'm using CE10 and we have bunch of reports already scheduled to run every day at a particular time. Now Is it possible to see for one of those instances [of a one report], what properties were set? eg: Destination properties. I want to check what Server there are being sent to directly...

Can I create a report based on Oracle Synonym? I have some public synonyms in my schema and was trying to base reports on these objects. In Crystal Reports 10 [ODBC -> Options], I have selected Table,Views,synonyms etc..but still only tables and Stored procedures show up. Nothing else. Is there...

I am using CR10 and was wondering if it's possible to display parameter values conditionally. Let me explain:-) My parameter is fetching values from a table. This table has two fields. Description and Active. Currently it's displaying description and would like to display only descriptions who...

Hi all, we are using CE 10 and were running out of space in our production environment [not enough space on server]. So,We want to delete "Output" Folder or alteast its sub-folders from filestore which creates some space. Will it create any problems while we publish reports from Management...

We are currently using CE10 and we have plenty of reports on CMC [in different folders, ofcourse]. We want a copy of all those reports copied onto some temporary folder on a hard drive [another server or same server, but on Harddrive]. Is there any option in Crystal Enterprise to get all the...

Hi all, I am using CR 10 and Oracle 9i Database and trying to create a report based on a stored procedure. Main report and sub reprot uses same procedure and this procedure has 2 parameters. Sub report parameter uses same values as main report parameters. so in sub report link panel, i have...

I am using CE 10 When I schedule a report to run every week or every month, is it possible to find where these jobs listing is stored on CE Server? I see in that report's history, it's scheduled with status recurring, but how do i log into server and see if that job is there? Also, is it...

Is it possible to change sub reports conditionally? I need to display a sub report in group header[on-Demand] on some condition. If that condition changes, it has to display a different sub report [Both reports are already created /Existing] Thanks,

Using CR10 and has a problem copying and pasting layout from one report to another. I have a report[Report1] that has a layout with so many lines and boxes in a group. I am trying to copy the same layout to a new report[Report2] group section. But i am not able to. Then i tried to move all...

Hi all, I am using CR10. I have a report that has two sub-reports placed in it's detail sections. Details a -> Subreport 1 Details b -> Subreport 2 When i run this report, all the pages in subreport 1 runs first and then second subreport show up. What I really need is Page 1 in first sub...

We are using CE10 and we have a bunch of folders with lot's of reports in each. Now, I have a user who should be getting access to all these folders. How can i check if he has access to all the folders and if not how can i give permissions to this user to access them? Thanks for any inputs,

I am using CR 10 and was trying to order my existing Group by a specified order. My group by is on a column name called CODE. It has values like 'a1','a2','a3',...'a45' and sometimes not even in series. So if i have to specify order, the only way i know is, go to change group and click on...