Search results for query: *

Crystal Reports XI SQL database I am trying to filter the most recent score based on a group. My table has customerid, scoretype, score, date created. I have grouped on customerid and under selection formulas - group I added the following formula: {DATECREATED} = Maximum ({DATECREATED}...

I have a string field that I need to split if it is over 30 characters long. I would like to split it inbetween words. How would I write a formula that would split the string at the space before 30 characters. For example: "Please help me with this problem" I would need to split this string...

I am using CR 8.5. I have a table which has the following fields: rates, serviceID, fundingID, and effective date. I need to know how to pull the rate for the latest effective date. For example: $5.00 as of 1/1/2004 and $6.00 as of 1/1/2005. How would I tell my report to pull the $6.00 rate...

I have Crystal Reports 8.5 installed on my machine. I am trying to connect to a remote MS SQL server though VPN. In the new connection menu I select: Create New connection -> OLE DB -> MS OLE DB Provider for SQL Server At the next screen when I try to select the SQL server through the drop down...

I am using CR 8.5. My address field is a memo field and I am trying to split the memo field where there is a carriage return. I know I have to use an SQL expression, however I keep getting the following error message: "Error in compiling SQL expression; invalid field found here". Why is it...

I am on a computer that connects to their database through SCO Termlite. I have an IP address that connects to the database. Is there anyway for me to connect to the database using crystal reports on this computer? Please let me know if I am not being specific enough.

I actually have two questions. 1. I have always used crystal reports 8.5 which allowed you to use the report distribution executables. In version 10 what feature has replaced this or are you not able to create executables anymore? 2. I am on a citrex server and plan to purchase version 10...

I usually don't have any problem with the speed of my reports, but this particular one is giving me a problem. It is a basic grouping report that sums the data. There is a parameter for the dates. I run it weekly and don't have a problem as long as the week is within one month. But when I run...

I am trying to run a yearly report (manual crosstab) that is broken down into weeks. I have to parameters "begdate" and "enddate". The report will start with the begdate and run each week until the enddate. It is summing unit cost. Basically I want it to look like this: Week...

When exporting to excel, is there any way to get the page footer from crystal reports to transfer to the page footer in excel automatically?

I have the following formula called "assessdate": If {tr_assev.avent_desc} = "" then "" else ToText({ta_assm_int.assm_assess_date}) The formula makes me convert the date to a string, however I want to keep it a date so that I can sort by it in my report. As it is...

I changed my options to move to the next record after pressing "enter". Is there anyway to have the cursor move to the first field of the next record after pressing "enter"? I changed the first field tab index to 0 and the cursor still doesn't move.

I have a union query that is combining time fields. The format of the original fields is short time. However, when I run the union query it changes all of the time fields to long time. Is there any way I can prevent this?

I have a form with 8 fields in it. I was wondering if I can have the first two fields (date and employee) automatically default to the previous record when I start a new record. It would make the data entry process easier.

I have a cross-tab report that has service type in the column and month in the row. The summarized field is sum of service units. I want a parameter that filters by employee, however the employees change from month to month. I am trying to add a parameter that states if month{service.date} =...

I have a report that runs fine on my computer but when I run the executable on another computer it changes the format of my date formula. For example, I have a formula that calculates the month name and year of the report using the date they input for a parameter. On my report the result looks...

I have a report that is basically an attendance sheet grouped by department. After each group I would like to fill-in the rest of the page with blank lines without adding an extra page in between groups. My problem is that the number of blank lines will always be different depending on how...

I have a group which is sorted by last name. I need to print a new page after each new letter of the alphabet. So I need all the A's on one page, all B's on one page, etc. What formula should I use?

I'm having a problem with returning records with null values. I have a field called street type, which is null about 15% of the time. I wrote the following formula(streettype) to check for Null Values and assign them a default value. if Isnull ({ta_cla.street_type}) then...

I would like to produce a calandar spreadsheet. In the left column I need to place reords from a table in our database and the rows across the top are the days of the week of a particular month. The actual cells produced are left blank, it is used as an attendance sheet check-off list. I am...