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

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

Oops its "Crystal Delivery" tool. Sorry!

Hi MJRBIM, I'm not sure if you are familiar with this tool. I have installed a third-party tool "Crystal Decisions" which is free(I think for some time). This tool has solved one of my issue ie I can schedule the reports in HTML format but still the scheduling email comes with attachment. Is...

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.