Search results for query: *

Hi, I have created a report in CRXI with a record selection formula which is as follows ( if cdate({?Start_Date}) <> cdate(1970,1,1) then {LAST_UPLD_DT} >= ({?Start_Date}) else if cdate({?Start_date}) = cdate(1970,1,1) then {LAST_UPLD_DT} = currentdate else if isnull({LAST_UPLD_DT}) then...

Hi, Can I create a report from text file which is stored on a server in CRXI? Thanks in advance.

Hi All, I have created a report in CRXI with 3 GROUP's in it. 1st GROUP BY app_date like Today,1 days,2days,3days...1 week,2week..1month. 2nd GROUP BY date 3rd GROUP BY app_name. Its working fine in CRXI. Apps_date & date are different dates.The report shows data as follows: App_name...

Hi All, I have created a report in CRXI with 3 GROUP's in it. 1st GROUP BY app_date like Today,1 days,2days,3days...1 week,2week..1month. 2nd GROUP BY date 3rd GROUP BY app_name. Apps_date & date are different dates.The report shows data as follows: App_name Apps_date Date aaa...

Hi all, I have created a report in CR with Database Type:Access/Excel (DAO) & tablename:test.txt & text file is on my C: drive. When I published the report on CR server I'm getting error "Failed to open the connection". I have tried to change the database conections in process/database...

Hi all, Not sure if its possible. I have created a report in CRXI from text file. The report shows: Date Count of users 05/11/2007 2 05/12/2007 12 Weekly count 14 05/13/2007 4 05/14/2007 7 I got the count of users as...

Hi all, I have created a report in CRXI with chart. The table is as: Name Date Total PI 5/16/2007 2345 PI 5/15/2007 2300 DI 5/14/2007 0 PI 5/14/2007 2390 DI 5/13/2007 2 PI 5/13/2007...

Hi, I have created a report in CRXI with default parameters. Ex. Start_Date=Today's date as default. It is working fine in CRXI. but when I published the report in CRXI enterprise I saw only two options for setting parameters there. Is there any way I can keep the start_date as default & when...

Hi, I have created a report in CRXI. Is it possible to create a default value for parameters. For Ex, For Start_date parameter I had start_date >= {?start_date}. Now user wants the start_date currently defaults to today but they can also change the Input start_date. Any help.

Hi All, I'm trying to create a report in CRXI. The columns I have for report are in following format: Date Type Model Percentage ===================================== 04/22 Browser A 100 04/23 Browser A 89.09 04/22 Radio A...

Hi All, I need to connect to postgres database through CRXI. Can somebody help me? Thanks in adavnce.

Hi, I have scheduled a package with bunch of reports in Crystal Enterprise XI. Everybdy is getting emails with report attachments in XLS format. 1> Is it possible to have reports in body of emails in html format instead of attachments. Thanks in Advance.

Hi, Is it possible in CRXI to show bar & Line in the same chart?Ex. I have 3 columns APPS DATE COUNT In Bar I'm trying to show COUNT in y-axis & date in x-axis & also trying to add a line which shows APPS. I tried multi axis but it is not working.Any help. Thanks in advance.

Hi, I'm trying to create a bucket by DATE in the following way in CRXI: Today: 0 and -1 (or <= 0) 1 day: 1 2 day: 2 3 day: 3 4 day: 4 5 day: 5 6 day: 6 2 weeks: 7-13 3 weeks: 14-20 4 weeks: 21-27 1 month or more: 28+ (>= 28) Never: null The APPS DATE column shows data as N/W...

Hi, I have 7 reports to schedule for 5 users on everyday 5:00PM in BOXI CMC. I have created a package of all reports & scheduled them. If I select Destination as "Email" & enter 5 emails addresses & "schedule for" myself, the scheduling is success but if keep Destination as "Default" & use...

Hi, I have table as: Id Name 1 Apps 1 Browser_rd 1 Multimedia 2 Browser_sd 2 Multimedia 2 Voice 3 Apps 3 Voice I need to create a sql which shows Rows of "Name" as its columns group by ID Like: 1 Name Apps...

Hi , After installing CEXI on linux server the Process button under Objects(after selecting a report) is coming as grey. I'm not able to select it to change the database connections. Any help! What I did wrong.

Hi All, I have created a package for multiple reports in CEXI. When I schedule the reports from Destination as Email ID's(entering multiple emails)the scheduling is success but if I schedule the same package from "Schedule for" as "Add/Remove Group", the scheduling fails. The group has same...

Hi All, I'm trying to create a report in CRXI from table as Name value apps time apps Browser_rd apps Browser_st MD1 Browser_rd MD1 Time MD1 Browser_st MD3 Time MD3 RC3 I want to report to...

Hi, I have created a report in CRXI with Start_date & End_date parameters as {Command.DATE} in {?Start_Date} to {?End_Date} I have scheduled the report on BOXI in Excel format for EVERYDAY. Is it posiible server can update the END_DATE automatically with "Today_Date" before sending report to...