Search results for query: *

hi, I am having problem with "supress if duplicated" this features of Crystal report. I am using Oracle 9i & CR 10. It's working for one report but it's not working for other. I have used this in past several time. Even I am checking this it's still showing save value in all line. I have tried...

I have created command in CR10. Can I change the command name? By default it say command.

can I concatenate detail data with summary data. let say the data look like group 1 col1 col2 col3 A 5 7 B 8 15 C 8 9 Group1 total 21 31 group 2 col1 col2 col3 A 5 7 B 8 15 C 8 9 Group2 total 21 31 Can I display like...

I have a field which is number data type. Let say the field name is Amount, value is 1,200.00. I want to convert it into string so that the value will display like 1200. I am using totext to convert it. But I am not sure how to remove the "," which is nothing but thousnad eparator. In oracle 9i...

I have a report which is displaying data like this. 12345myreport 3/23/06 abcd12340o87 njioer1245678 njkio190734 wert09876456 oilsir1234890 asnjoih12456789 bbcd12340o87 jjioer1245678 jjioer1245678 iert09876456 lilsir1234890 psnjoih12456789 Can I display data like...

I have to create a report where I have to bring some data which are not exist in the database. Let say I have a field called country where I have 20 records. But for some reason we need 24 countries in the report. But we can not keep that in the database table right now because we don't have any...

Hi, I am planning to store data in Oracle 9i global temp table and retrieve report data from there. I will write Oracle Stored Procedure to insert data into temp table. I will use Crystal 10 for reporting. Now these reports are mostly daily and on demand. User can see data for any day. So...

Hi, I am planning to store data in Oracle 9i global temp table and retrieve report data from there. I will write Oracle Stored Procedure to insert data into temp table. I will use Crystal 10 for reporting. Now these reports are mostly daily and on demand. User can see data for any day. So...

Hi, I have to write Oracle Package ans Stored Procedure using Oracle9i for Crystal Report 10. I was wondering if someone can send me some sample code. Thanks in advance.

Hi, I am working with few reports which have row level security. These reports are running fine for last 10 months. All of a certain for some instances row level securities are failing. If I am rescheduling these reports row level securities are working fine then. I am using CR 10.5, CE 10.5...

I have a report and I am printing letter and landscape format. Let say this report I have a group on each customer. Now I want to display a blank page after each customer. I know how to do that. But what I want, I want to change the print set up for the blank page as leagal and landscape.Is that...

I was using a formula called period to get last month summary data. MonthName(Month (currentdate)-1). It was working fine last year. But this is failing in Jan. I know why it is failing. But is there any alternative??? Basically I want to see last month data and want to display the last month...

I have a column which is holding data like 200601. I want to convert this like 01/06 or 01/2006 or Jan 2006 or any date format. Anyone has any clue.

Hi, I have one report which can be viewed by different internal and external user. External user can only see their data. But Internal user can see one or more than one external user's data. For example internal user IU1 can see external user EU1,EU2,EU4 internal user IU2 can see EU1,EU8,EU7...

Hi, I was trying to create a group on a report instance. I don't want current data. I want to keep the old data but want to see the report in different way. I was trying to insert a group. But after inserting a group I can see the the report is refresing and getting recent data. But I want the...

Hi, I have to create a formula which will convert this 05-123-00 50200500012300. I can concatenate 50 with the exsisting string. I wrote a formula to convert 05 to 2005 or 96 to 1996. Is there a way I can count how many characters are there between two "-" and add zeros accordingly. Thanks in...

Hi, I am trying to do formula3= formula1 + sum(formula2) sum cases this is working but sum cases not. I have few groups. I am displaying formula1 in group header and formula2 in detail section. Let say I have grp1,grp2,grp3,grp4 Now let say group4 has 4 item A,B,C,D formula1=0 for A...

Hi, I have a report where I have used XML data source to designe the report. Now I am trying to export that report to PDF format but it's not working. Any one has any clue? Thanks in advance, RB

Hi, I have one query. All my reports are using Business View. I have created busies view using dynamic connection. Now when I published the report I have set the connectivity parameters. Most of the reports are scheduled reports and external user can view latest instance/history only. Let say...

Hi, I am using Crystal Report 10 & Enterprise 10. I want to use JAVA application for more flexibility. I want to use the exsisting report and reports will be physically store in Crystal Enterprise server. I can use Weblogic or Websphere. Do I need Crystal Java SDK or only weblogic work shop or...