Search results for query: *

Hi, I'm using Crystal Reports 2013 Support Pack 11 on a 64-bit Windows 7 Professional Operating System. I'm creating a new report using an Excel spreadsheet as my data source. I am using the native Access/Excel (DAO) connection. The termination column in Excel is formatted as "Date"...

I'm using Crystal Reports 2013. I've created a formula with three variables which returns absolute values. I need the formula to return the level corresponding to the smallest absolute value. WhilePrintingRecords; Local NumberVar tenK := Abs (ToNumber({@AcctBal}) - 10000); //Level A Local...

Hi, I using Crystal Reports 2013. I am grouping my report by departments. I've created the following two running totals. #ActiveEmployees Field to Summarize: SSN Type of Summary: Distinct count Evaluate: isnull({Termination Date}) Reset: On Change of Group #1 #FiftykEmployees Field to...

Hi, I'm working in Crystal Reports 2013. I have a subreport which is placed in the GF1 section of my main report. I'm using the subreport's GH1 section as a page header and 'Repeat Group Headers on Each Page' is selected in both the subreport and the main report. If the subreport spans more...

Hi, I working in CR 2013 I am looking for a way to ensure my GF1 Summary totals get printed with header information. Below are my sections RH & PH Suppressed GH1a ( Grouped by Fund) {FundName} GH1b {Datefield} GH2 (Grouped by Client Status){ClientStatus} GH3 (Grouped by Client last name...

We are using Crystal Reports XI release 2 (bundled with MAS500). I've added a subreport to the page header section of my main report. I also created a shared variable in the subreport and corresponding shared variable in the main report. The shared variable is placed in my Group Footer #2...

Hi, I'm using Crystal Reports XI with work files created for SAGE MAS 500. When I attempt to view formula expressions (i.e. edit the formula), all that is present is an empty string (""). Anyone seen this before and know if there is any way to access/modify the formula? Thanks!

Hi, I'm using Crystal Reports version 11.5. We're using this version because it is bundled with Sage ERP MAS 500. I'm modifying a report (FSFormat1) and have added a text object into the Report Footer. When I preview the report within Crystal Reports, I see the text object. However, when I...

Is there a more efficient way to write the following code? Basically, I am testing four conditions. Then I want to sum how many of those four conditions are true. Then I'm assigning them values A to E (0 to 4). Once an A to E is returned for each record, I am grouping by this value. Just...

Hi, I've read several posts on grouping on a range of dates entered through start and end date parameters and if I understand correctly this works well when grouping only by the date range. However, I need three groups in my report. I'm grouping by manager, then employee id and then dates...

I am using SQL Server 2005. I have a rate_category and an item_rate table. They are joined by the rate_cat field in each. The rate_category table contains unique rate_cat (varchar(12) and description (varchar(40)) fields for each record. I have two new items whose item_id (integer)values are...

I have a view with the following fields: cust_subtotal, last_cust_sub, branch_code, cust_id and cust_name. I need to group all records in which the cust_subtotal + last_cust_sub is less than 2500 under the name "Others" and the sum of all those records to be included in the cust_subtotal and...

I'm using Crystal XI. I need to filter my records and get only last year's records up to the last day of the last full month. There is a handy lastfullmonth function I can use if I wanted records up to June 30, 2011. I need to filter them for records with an invoice date between January 1...

I am using Crystal XI on SQL Server. I've created an SQL Expression to get the sum of sub_amts for last year to date. However, every time I save it, Crystal freezes. Anyone have any suggestions and what I can do to resolve this issue? Thanks! ( select sum(ivc2."sub_amt") from invoice ivc2...

I'm using Crystal XI on SQL Server 2005. I've seen a couple of posts on the topic but need some help. I don't use SQL Expressions often, so may just need an example or two there. I was attempting to sort on my variance formula: Sum ({@Current}, {sales_register.cust_name})-Sum ({@LastYear}...

I am attempting to subtotal all amounts with dates in the current year (year to date) and dates last year by this time. Crystal reports has a yeartodate function in which I can simply say invoicedate in yeartodate. Need to accomplish same goal in the view. Is there a similar function in TSQL...

I am using SQL Server 2005. I am attempting to find the last work order that was used for each rate category. I can find the date last used for a specific rate category, but am not able to get the ONE work_no associated with that date. The code below is still yielding multiple work orders for...

I'm sure I'm just drawing a blank here, but any help would be appreciated. I'm using Crystal XI with SQL Server. I have created a report of all of my employees who have clocked in during the week. Let's say this week there were 18 employees who clocked in. I have a view of all of my active...

I am using Access 2007. I am working with a database I DID NOT design and realize that it is designed poorly. However, I am not able to recreate it at this time. Here is my dilemma. The Workflow table has records of work done on workorders. One workorder can have multiple repairs. There...

Hi, I am using Access 2007. I have a text field on my form (txtPartNumber) that is correctly populated based on the choice in a combo box. The txtPartNumber field is locked so user can't change it. I need to update the part number field in another table which is also on the form [Part No]...