Recent content by syncdba

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 Synapse & groogle, I'm able to get the same data in GROUP"Apps_date" in the report which was published on the server yesterday. I was using a small sql in my report with ORDER BY apps_date,date_date. When I took out the ORDER BY clause from SQL & did ORDER BY through crystal report. The...

Hi, I need the groups to see data by Apps_date,Apps_name & by date. Report works fine in CRXI but when I publish the report in Crystal Enterprise XI, the report shows different set of data in Apps_date column. I have published many times many report but this happens first time so really don't...

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...

I can't use this formula coz it gives distinct count of users per week but I want distinct count of users per day and then SUM them per week.

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...

Thanks. Its working now.

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.

When I use Cross-tab I'm having two issues: 1> In Percentage column I need data as it is but after using cross-tab it is doing sum of Percentage data. 2> I want a drill-down. If somebdy clicks on percentage data it will show date,Type,model & percentage. Thanks for 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...