Search results for query: *

Hi, We are using Crystal Reports v10 with SQL Server 2000. Currently the reports are distributed over the web using a .NET applciation. I am trying to find a way where a user can click on the column header and the results of the report will be sorted by that column. Is there a way to do...

I am trying to integrate CR 10 with ASP.NET using Visual Studio 2005 on a Windows 2003 server running IIS 6. I have tried to install every merge module provided by Business Objects. Default.aspx page only has a report viewer object and when this page is accessed from the delpoyed site .NET...

Hello, We have some reports which were created in CR 10 and currently being distributed using CE 10 in a .NET application. The issue we are facing is that everytime a report is executed from the web browser and we click on the envelope sign to export the report and when we type the name and...

Hi, I am using SQL Server 2000. I have a field in the table which has value "do not close". In some cases the data is lower case and then in other cases it is upper case. I want to write a query to only return the upper case instances. Can someone please help me with this? Thanks, Kchaudhry

I am using CR 8.5 with SQL 2000 backend. I am facing a problem of getting duplicate records. I have "select distinct records" checked. Basically my joins I think are causing the problem. we have a participant table with 2 rows. id=1, name=smith id=2, name=chaudhry we have a formula...

Hi, I have window XP professional. For some odd reason I had to unistall the Net Meeting from my computer. I used the following command: RunDll32 advpack.dll,LaunchINFSection C:\WINDOWS\inf\msnetmtg.inf,NetMtg.Remove Now I am trying to install it again but the system would not let me install...

Hi, I am using CR 8.5 with SQL Server 2000 backend. I have created a main report and grouped it by Manager ID. Then I have created a subreport for all the people that work this manager and grouped it by the Manager ID too. Now when I try to insert the subreport into the main report's...

I am using CR 8.5 with SQL 2000 backend. I have a formula which matches one record in the entire database. My problem is that when I put that formula field in the group footer it shows me "0". If I place this formula in the details section then I get the correct value. I have to get...

I am using CR 8.5 with SQL 2000 backend. I am facing a problem while comparing dates. I have to show certain records if the year and month match. I am using the following formula: if {Participant_Move_in_Trans.Term} = "L" and {Participant_Move_in_Trans.International_Indicator} =...

Hi, I am using CR 8.5 with SQL server 2000. I am using the following formula for date conversion. cdate(val(mid({Participant_Move_in_Trans.Reservation_Date},3,2)), val(mid({Participant_Move_in_Trans.Reservation_Date},5,2)), val(mid({Participant_Move_in_Trans.Reservation_Date},7,2))) I am not...

I am using CR 8.5 with SQL server 2000. I have a formula which inlculdes a String field and a Number field. Here is what I have so far. if {Participant_Move_in_Trans.Trans_Category} = "Local" and {Participant_Move_in_Trans.Tier_Level} = 1.00 and...

I am using Crystal Report 8.5 with SQL server 2000 database. I am trying to acheive the following. I need to write a formula where {table.Commission_Qualify_Date} (Month & Year only) equals {table.Period_Date} (Month & Year only). Both these fields are present in the same table. The problem is...

I am using CR 8.5 with SQL Server 2000 database. Here is what I am trying to get in the group summary. *Current Month (CM) Local Outbound Inbound ------- ------- -------- CM Tier 1: 000 000 000 CM Tier 2: 000 000 000 CM Tier 3: 000 000...

I am using CR 8.5 and have published reports on the web. The pages are setup in a way that if a person is viewing them for the first time and does not have CR installed, an activeX viewer is installed. This way they dont need the actual CR software. For some reason this viewer is not being...

I am using the following formula to calcuate a summary field. (Sum ({@LocalTransCurrentMonthT1}, {participant.id}) + Sum ({@OutTransCountCurrentMonthT1}, {participant.id}))/{@TotalProdCurrentMonthT1}*100 I get an error message as the value in the denominator is sometimes zero. Can someone...

I am using CR 8.5 and creating a report which includes summary for the selected group. The records are grouped by Sales person ID. I am trying to create a summary table which includes fields from current month and a Year to date field. The YTD information is stored in an archive table. When I...

I have five main tables. 1. Participant_Move_in_Trans 2. Participant 3. Archive_Participant_Move_in_Trans 4. Measure 5. Formula I have linked the tables using the primary and foreign keys. When I run the report I have a field called {Participant_Move_in_Trans.Trans_Category} which contains...

I am trying to perfrom the COUNT for records with a certain word. I am trying to generate a Transaction count field, but for that field I only want the records which have the word LOCAL in them. Currently I am using the following formula: if {Participant_Move_in_Trans.Trans_Category} =...