Search results for query: *

I am using Crystal 11 I am trying to get the difference between dates based on the approver of an invoice. Approver 1 approves invoice on 12/3/14 Approver 2 approves invoice on 12/6/14 Approver 3 approves invoice on 12/15/14 I need to get the number of days between approvals. My fields are...

Im using SSIS 2012. This is the expression that I have on my field. The paymethod field is char field of length 1 I am trying to say if it = C then put "CHK else "EFT. How can I write this expression when I want the output to be 3 char. The following give me an error [Flat File Destination [35]]...

I was wondering if someone can help me with some of the flow for this project. I am farily new to SSIS and seems like there are several way to accomplish what I want to do. Just trying to get some input before I go in the wrong direction. Here is what I need to accomplish. We need a fixed length...

I need some help on how to consolidate my formulas. I was thinking I could use CASE but not sure how to put it together. I'm using Crystal 11.5 Here is an example of two of my formulas. I am then using Print to put them on the report. Everything is working but I have 7 different classes. Then I...

I am using crystal 11.5. I have a group that runs off of this formula which gives me hours by month for 2014 if {PRJC.PREndDate} in cdate(2014,01,04) to cdate(2014,01,25) then 'January' else if {PRJC.PREndDate} in cdate(2014,02,01) to cdate(2014,02,22) then 'February' else if {PRJC.PREndDate} in...

I am using Crystal version 11 I am trying to create a report that will subtotal multiple groups. Exapmple Fed Tax FICA Tax FUTA Tax Subtotal State TAx SUI Tax Subtotal I'm not sure if this is the right approach but I created a group for each tax type and put all my fields in the Group...

I'm using crystal 8.5. My report has a group header, detail that is suppressed, and 3 group footers a, b and c. From reading some of the other keep together questions, I see that the keep together function is only used within a section. How do I keep the group header from printing on the...

I am using Crystal 8.5. I am trying to group on part of a field. I have a field cost category which holds the following data 0114000001 0114000002 0114500001 0114500002 0115000001 I want to be able to group on the first 9 characters of the field. So my groups should be as follows 011400000...

We are selling our company as of April 12th. We will be doing the accounting work for the new company starting April 13th. They need all of our history for billing purposes. Does anyone have suggestions on how to we can handle this in the system. If we do a year end close as of April 12th for...

Is it possible to join 3 tables. I created a SQL view that joins 2 tables using full join but is there a way to join a third one to that view? Thanks Gina

I am using Crystal 8.5. I have a field called PACOSTCATID. I want to group on part of that field as shown below. PACOSTCATID 0100000010 this is used for budget $ 0100000011 this is used for actual $ 0100000012 this is used for actual $ 0100000020 this is used for budget $ 0100000021...

Has anyone out there worked with creating an AP aging report (preferrably in Crystal) that was able to link project numbers from project accounting? I can get the tables to link but the problem I am having is when there is a partial payment in AP. Since Project AP Invoices can have multiple...

I have a form that a user will enter budget information. They will enter Quantity and unit cost based for each line item listed. That is all they see on the form. This part is done. This may be very easy, but my programing skills are a little rusty. My question is I want to be able to update...

I have 2 tables one with project information and the other with project budget info one to many relationship. The main form has the project number is a combo box used to find the project. The only other field displayed on the main form is the project name. When I pull up the project, the...

I have an excel spreadsheet that has a column with a date and one with a dollar amount. I would like to put summaries by month at the bottom of the page. I would like to list each month January $$ February $$ March $$ etc... If the date falls in January add the amount field...

I am using crystal reports 8.5 with sql data. I have 2 subreports with totals on each of them. Here are the 2 subreport totals: Subreport 1 total: WhilePrintingRecords; Shared CurrencyVar June :=Sum ({@June}) Subreport 2 total: WhilePrintingRecords; Shared CurrencyVar JuneEE :=Sum ({@June})...

I am using crystal 8.5 with sql tables. My main report has 2 tables a project table and timesheet table. The subreport has the same project table and expense table. I am linking the reports by the contract number within the project table. I have to use a select statement on the main report...

I am using Crystal 8.5 I have a numeric field that formatting is set to Decimal 1.0 Rounding 0.1 The numbers on the report are: 1.3 2.3 2.6 1.2 The total of this field is also rounded the same as above but the answer I am getting is 7.5 and it should be 7.4 If I use rounding as Decimal 1.00...

I'm using verison 8.5 linking to sql tables I have a main report with a start and end date parameter field that I want to link to the date field of the subreport. When I go into the subreport link and select the start date parameter field and insert it, the Select data in subreport based on...

I have a report with multiple detail sections and a group total for each detail section. Right now is shows: detail section detail section group total section group total section Is there any way to link the detail section to the group total to show on the like this: detail section group total...