Search results for query: *

We are currently using CR 10 Java Reporting Component (JRC). Currently, it only alows export to pdf and rtf. We need it to export to excel (xls). Does anyone know any way of doing this? Is there any third party application that does that? Thanks in advance!

Hi hoinz, No response from that forum either :( I thought it would be someting very simple but I guess I was wrong.

Hi, I am working with Oracle 9ias and I need to update the Language and Region being used by this server. I know that I have to use the following commands: -D user.language = en -D user.region = US But I am not sure how to implement these. Can someone please tell me how I can update these...

Anyone has any suggestions?

Hi, I am working with Oracle 9ias and I need to update the Language and Region being used by this server. I know that I have to use the following commands: -D user.language = en -D user.region = US But I am not sure how to implement these. Can someone please tell me how I can update these...

Hi everyone! I am creating a report using SQL server 2000 and CR 10. The report is based on a view. My current report design includes two groups (office and status of complaint). The detials section includes the complaint and related info. All group footers are suppressed. There are some cases...

After reading Naith's response, I tried to link the table and the view on a different field. I then modified the record selection statment and that solved the problem. Naith, thank you very much for your respone. Madawc, I will also keep your suggestion in mind for future use. Thanks!

Yes, its the unique identifier for the complaintevents table.

Hi everyone, I am using CR 10 and SQL Server 2000. The report is based on a view and one table joined on on complaintid. When I added the date parameter for range (start and end date), all the rows are repeated 3,4 or 5 times. Here are the details of my SQL: SELECT...

I am consulting my DBA and we might go with the option of creating a view for this. Thanks for your suggestions.

A little modification I dont want to return the date, I want to return the word 'written notification' for first stage and 'investigation' for the second stage. If you need more information please let me know. Thanks!

Hello everyone! I am using SQL server 2000 with Crystal Reports 10. I have to create a formula and then create a group on this formula. Essentially, I need to get the start date from a table based on certain events. For example, the first condidtion would be written_notification is null, fad is...

Yes, you are right. It is working now. I dont know what made it work but hey its working. Thank you for all your help. I can always count on your great expertise.

The reason why I right clicked was because I was not getting any dates for any cases. I know for sure that most of these cases have file date. If I try my regular formula and place it in the details section most the cases come back with file date. Any other ideas?

I have tried both the approaches but dont get any results. Using the first approach when I right click and go to browse field data, it is blank for all three formulas. Using the second approach: Field to summarize = {complaintevents.startdate} Type of summary = maximum Evaluate use formula...

Here are the details of my three formula. @filedate if {complaintevents.eventsubtype} = 9241.00 and {complaintevents.eventtype} = 100.00 then {complaintevents.startdate} @ivestigationreqdate if {event_462_view.keyname} = "f_investigationStart" then {complaintevents.startdate} @hearingdate if...

Crystal Report 10 and SQL server 2000. I have a report with one group (area). Each of these areas have severl complaints and then there are different dates associated to each complaint. For example file date, investigation request date, hearing date, etc. All these dates are based on formula...

Thank you both, it works great!

SQL server 2000 with Crystal Reports v10. I have a string filed called area. I have to add this as a parameter to my report. I created a new paramter and selected the default values. What I need now is to create a value called "ALL" which will select all the values automatically so that the...

Any work arounds for making the list dynamic. My compnay is using version 10 and they dont plan to upgrade in the near future. I was just wondering if anyone has been able to create a work around for this. Thanks and any input!