Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: kchaudhry
  • Content: Threads
  • Order by date
  1. kchaudhry

    Sort data by clicking column headers

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

    Cant deploy simple ASP.NET with CR 10

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

    CE 10 Export Issue

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

    Upper Case Query

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

    Duplication Problem

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

    Net Meeting install

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

    Linking subreport

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

    Field not showing up

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

    Date Comparison Formula

    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} =...
  10. kchaudhry

    Eliminate zeros from Date conversion

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

    String Conversion

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

    Date Conversion Formula

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

    Supressing Details Section

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

    ActiveX Viewer Issue

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

    I am using the following formula to

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

    Suppressing Details section

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

    SQL Query and Linking Expert

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

    Formula for Counting certain records

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

Part and Inventory Search

Back
Top