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

    group by grand total in a cross tab report

    crystal version8 pervasive sql 8 I have a cross tab report which summarizes the item information by qty shipped and sales amount by month. 2/2005 3/2005 total item A 120 10 130 qty $235 $240 $470 salesamt item B 12 110 122...
  2. adhhealth

    a new column in cross tab report

    crystal version8. Hi I want to create a sales report in cross tab format. Jan feb MAR ... total qty amt qty amt qty amt Item1 120 1200 20 200 Item2 1 1 2 2 customera 121 1201 22 202 Item3 Item1...
  3. adhhealth

    new crystal version

    Hi, I have downloaded the new crystal server evaluation version 11.. I have only used crystal reports version8 and want to explore the new server functionalities..can someone send me a link or suggest a book that can be good for me to start with?
  4. adhhealth

    group sort based on parameter

    crystal version 8 hi, i have 3 groups in a report and each user needs a group sort by a different group, instead of creating 3 different reports can we sort using a parameter? if user1 selects parameter "group1" then the report should be sorted by group 1 and so on,..
  5. adhhealth

    interview questions

    hi, can someone suggest me what material i have to be in touch to have a broad view of what are the capabilities of crystal reports .i have worked in version 8 but donot know anything about v9,10 or 11.. i have installed the eval version of 11.. but am not sure where to start to look for the new...
  6. adhhealth

    crystal 11 eval version

    currently i have crystal reports v 8 . I use this every day. Now as v11 has come out i want to browse the new version..can i install v11 on the same m/c as v8? will it corrupt my v8 installation?
  7. adhhealth

    create index on a view

    pervasive sql 8 I have created a view from a table in another database. I want to create an index on one of the fields. How can I do that?
  8. adhhealth

    sort by running totals

    crystal reports 8 pervasive sql 8 I have a report like this prodcode description no. of orders 1122 abc 349 1234 def 22 2344 xyz 1289 report is grouped by 1. prodcode 2. batchnumber no. or orders- is the running total of count of...
  9. adhhealth

    crystal reports interview

    Hi, Can someone suggest how i should prepare for a crystal reports interview? i have worked in crystal reports v8 and pervasive sql data base.. i havent worked in any integration of crystal reports with any other softare currently the latest version of crystal is 10 and so many things have...
  10. adhhealth

    learn SAP

    Hi, I want to know where i can get training for SAP. I dont know what SAP is..but would like to have it as a career option. which place is the best to start to understand what SAP is..
  11. adhhealth

    criteria to get data in excel

    hi, my excel workbook format is order-status sch-date act-date i want to get external data, from another excel file-which also has same format- i want to get data which satisfies the condition act-date>sch-date but in ms query i see that we cannot compare one field to the other in the...
  12. adhhealth

    searching in multilple worksheets

    There are many (100 or more) excel workbooks in a folder in the same format- ex: scheduled-date actual-date description and so on.. each file will have different values under these fields. From all these excel files i have to pickup the row where the 1. datediff(scheduled date ,actual date)...
  13. adhhealth

    excel file-save automatically (following a particular filename series)

    Hi, afraid if it is a silly question. One excel file has 5 sheets.(say filename f1) sheet1 is the master, the 5 sheets will have similar content as sheet1 but in a different format. sheet 1 has 5 buttons create s2, create s3 and so on.. when the user clicks on say create s2, sheet 2 should be...
  14. adhhealth

    searching in multilple worksheets

    Hi, There are many (100 or more) excel worksheets in a folder in the same format- ex: scheduled-date actual-date description and so on.. each file will have different values under these fields. From all these excel files i have to pickup the row where the 1. datediff(scheduled date ,actual...
  15. adhhealth

    Display stock for different conditions

    crystal 8 pervasive sql 8 i want a report like id desc stock-abc stock-def stock-xyz 1023 item1 10 11 127 stock-abc is the stock whose item number is F-abc-1023 stock-def -- f-def-1023 and so on.. so first i did a grouping by...
  16. adhhealth

    array

    crystal 8,pervasive sql 8. Hi, How do I get all the values of a database field called item numbers of the "detail section" into an array ?
  17. adhhealth

    btrieve error 22- data buffer length

    I have created reports in crystal version 8 which accesses pervasive sql 8 database. The same database is accessed by another program(accpac-an accounting software)accpac in the new version has changed a few things about the database. But the tables i use for these reports look the same , but...
  18. adhhealth

    page number

    crystal version 8 pervasive sql 8 Hi, Out put of My report is 3 pages,But Page Nof m shows page 1 of 1 in all the 3 pages. I have not given "reset page number" for any sections. Pl. advise.
  19. adhhealth

    Group by parameter

    crystal version 8 pervasive sql version8. Hi, I have 3 reports which have the same information but grouped by different following fields in the database in each respective report: 1.customer 2.product 3.quantity can i have just one report which could take a parameter which groups by any one of...
  20. adhhealth

    for loop

    crystal version 8 pervasive sql 6 Hi, my formula looks like the following: numbervar i:=0; for i :=1 to {#RTotal1} step 1 do i; i; -THis is to display serial numbers starting from 1 till it reaches the value of the running total. But the o/p is starting from 2 till {#RTotal1}+1. I dont...

Part and Inventory Search

Back
Top