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!

  • Congratulations TouchToneTommy 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: sultan123
  • Content: Threads
  • Order by date
  1. sultan123

    Using RAS with CR9

    Hi I have CR 9 advance, however I am facing quite a bit of problem trying to get to know 'The Crystal Web Report Server'. First: How do I install The Crystal Web Report Server? Does it refer to RAS? If so how do i install RAS? Becuse during installation there are no references...
  2. sultan123

    CR9 advance RAS

    Hi I have CR 9 advance, however I am facing quite a bit of problem trying to get to know 'The Crystal Web Report Server'. First: How do I install The Crystal Web Report Server? Does it refer to RAS? If so how do i install RAS? Becuse during installation there are no references...
  3. sultan123

    Help with using CRPEAut32 !!!!!!

    Thank you in advance.. I am using CRPEAut32 .dll Crystal Automation Server.. cr engine 6 object library... Done followings: Dim app1 As CRPEAuto.Application Dim rpt1 As CRPEAuto.Report Dim strapppath As String strapppath = App.Path Set app1 =...
  4. sultan123

    GroupOptions.ConditionField

    Thank you in advance.. I am using CPEAUT32 Done followings: Dim app1 As CRPEAuto.Application Dim rpt1 As CRPEAuto.Report Dim strapppath As String strapppath = App.Path Set app1 = CreateObject("crystal.CRPE.Application") Set rpt1 = app1.OpenReport(strapppath & "\Last Year's...
  5. sultan123

    parameter has invalid structure size

    Thank you in advance.. I am using CPEAUT32 Done followings: Dim app1 As CRPEAuto.Application Dim rpt1 As CRPEAuto.Report Dim strapppath As String strapppath = App.Path Set app1 = CreateObject("crystal.CRPE.Application") Set rpt1 = app1.OpenReport(strapppath & "\Last Year's...
  6. sultan123

    cpeaut32.dll

    Can anyone please tell me where to download CPEAU32.dll for Crystal report engine automation server? I got version 6 for net but i need version 7, I can't find one with CRW 9 but I need to use it. Any help would be appreciated.
  7. sultan123

    Crystal OCX - Group Tree and export button

    Thank you all in advance.. I have just started using crystal ocx in VB I got the following report Last Year's Sales.rpt which i display. However, AT RunTime 1) I want to disable Group Tree. 2) I want export button hidden. 3) Assign a Title For 1 i can only see the following which carry the...
  8. sultan123

    SQL for SQL Query Designer

    I have the following SQL which works as SQL statment however it need to do a little bit more as mentioned below: SELECT Customer.Country, customer.[customer name], SUM(Orders.[Order Amount])AS [Sum Of Orders Placed] FROM Customer JOIN Orders ON customer.[Customer ID] = orders.[Customer...
  9. sultan123

    Join and Aggregate Problem

    I have the following SQL which works.. SELECT Customer.Country, customer.[customer name], SUM(Orders.[Order Amount])AS [Sum Of Orders Placed] FROM Customer JOIN Orders ON customer.[Customer ID] = orders.[Customer ID] GROUP by Customer.Country,customer.[customer name] HAVING...
  10. sultan123

    CRW 9 Subreport returns wrong 0.00 Currency value

    Thank you in advance.. In subreport: =========== WhilePrintingRecords; Shared currencyVar RegSupSubTotal := sum({@RegSupRsale}, {COMPANY.STATE}); RegSupSubTotal; (placed in GF of subreport) In Main report: ============== WhilePrintingRecords; Shared currencyVar RegSupSubTotal; RegSupSubTotal...
  11. sultan123

    Help..Customer with 3 Orders over 500 in the same year

    Thank you in advance.. I have situation where i need to write a note based on condition where A Customer has placed at least 3 Orders over £500 in the same year. GRouped by: Customer Name. Detail section: OrderID, OrderDate, OrderAmount, Running Total(for customer with order over 500)...
  12. sultan123

    How do i extract year, month and day from datetime field

    I want to increase employee salary according to information chart shown blew. I have a hire.date field as datetime format for employee and I am increasing their salary field value by: Date of hire Salry Year Range Raise ===== ======...
  13. sultan123

    Suppressing Pie-Chart with only one city

    I have graph reflecting sales by city Grouped under Region. I would like to suppress this chart when a region has only one City in it. I know it sounds like a conditional suppress format,but anyone please please show me how? Thank you

Part and Inventory Search

Back
Top