Search results for query: *

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

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

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

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

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

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.

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

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

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

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

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

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

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

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

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

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

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