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

    CRYSTAL ARRAY QUESTION

    I am using crystal reports version 11. My task is to do the following. I am working with a database that tracks if a client has a take out for a medication . All the medications are the same. I am going to be running this for a date range and i would like the final output to indicate...
  2. RPOC

    exporting crystal reports to excel automatically

    I am using crystal 11. i want to run a report and automatically have it export to an excel spreadsheet of the 97 to x format. I know this can be done manually. Is there a way to have this done automatically and if so how? I did check posts and could not find this topic. Any help would be...
  3. RPOC

    date groupings ifnot in the data

    I am using crystal reports 11. I have the following situation that i never encountered before so if this is posted in the incorrect area I apologize. The report I am creating will allow a user to enter a start date and end date. for each date in that range i want to have a line item...
  4. RPOC

    isnull check stopped working

    i am using crystal 11, The report I aam working with was written in crystal 9. and is being used by a client base and has not had any issues until now and only on 1 client location. This report runs via an odbc connection to an intersystems cache 2008 database. I am using the below...
  5. RPOC

    selecting data

    I am using crystal reports 9 and am accessing a set of tables via an odbc connection. I am printing a report and it contains a pass thru parameter from another program. that parameter is parsed to look like a series of numbers then a tilde then a series of number tilde etc. Example...
  6. RPOC

    Formatting a lable so it dynamically expands to other labels if needed

    i am using crystal 11. I created a label that has a variety of fields on it. The label will have a notes area and the notes can range from 1 character to a couple of hundred. Since the notes are a variable, Is there a way to make the extra data show up on additional labels if needed.
  7. RPOC

    Crystal 11 Report Summary with formulas

    I am using crystal version 11. with shared variables. I created a detailed report that is working fine. I would like to create a summary report from the same report by hiding or suppressing the detail lines. When i do this my variables do not seem to be passing to the main report. Is there...
  8. RPOC

    printing data over multiple labels

    I am using crystal 11. I created a report that will produce mulitple labels. Currently if there is more data then the label can fit the label will chop that data (baiscally 1 label per item). I want to be able to produce a label so that if more data exists it goes to a second label. For...
  9. RPOC

    sql question

    I have 1 table that used PATid,DISPENESED date,Vamount as well as other fields. The ids can duplicate. I want to be able to find the greatest date per id and then show the amount associated with the date. I then have a second table that has id, dob,enroll date. I want to do a join between...
  10. RPOC

    dpms suspend mode on view sonic

    I am looking for some help. I have a desktop that is using an ati radeon 9600 video card The other day i went to turn the system on and the viewsonic a70 monitor is indicating dpms suspend mode. I researched this and discovered this has somehting to do with power settings. I then took this...
  11. RPOC

    array question

    I am using crystal 11 and am relatively new on using arrays. I found a post on how to populate an array but am having problems on how to print out the values. I have the following I have records with multiple string values in field "x". This string is associated with a "yes" or "no". I...
  12. RPOC

    subreports or another method

    I am using crystal ver 9. I need to create a report that will generate several other reports. I figured that the best method would be to have the user enter 1 set of parameters and pass this information to the subreports. Based off those parameters some of the sub reports will run and others...
  13. RPOC

    Select Case statement

    I am using Crystal 8.5 and am trying to do a nested case statement. I cannot seem to get it to work and am not sure if it can be done. I was looking at a 8.5 book and there is no clear descriptive way of indicating the end of one select case and starting another. the code looks as follows...
  14. RPOC

    TEXT TO NUMBER JOIN IN CRYSTAL 8.5

    I am using crystal ver 8.5. I want to link table1 to table 2 by a field that is common in both of them. The only problem is the data in one table has the field defined as a number and in the other a text. Other then this small issue the field will contain the same type of values. Is there a...
  15. RPOC

    sorting same report in different ways

    I am trying to figure out how to take a report that has an id , and a name on it and sort it based off a user input. The reports will be identical in everyway except by sort order, sometimes I want it sorted by Id others by name. I am using Crystal Reports 8.5. Thanks
  16. RPOC

    Total distinct count record Totals

    I am doing a distinct record count, grouped by date by on a client id. I have totaled the records in a grouping to get a value for each day. I want to then total these totals so I can get a total of all the days. example on day 1 I had 3 unique ids (in the grouping there were 6 line items)...
  17. RPOC

    Summing Number

    I created several formulas basically in the format:if a certain condition exists assign it a zero else assign it a 1 . I then do a sum function on these formulas based on 2 groupings. In my first group when I ran my tests I should be getting values of zeros but they do not appear. The second...

Part and Inventory Search

Back
Top