Search results for query: *

SAP CR2003 Hello eg I have 4 records in the result: 1.Cont.NumberX 2.Cont.UnitA 3.Cont.UnitB 4.Cont.UnitC and I need the result in a record: 1.Cont.NumberX 2. Cont.UnitA +' '+Cont.UnitB +' '+Cont.UnitC where 2 = a field Please help.

Hello I have a formula: @extract if isnumeric ({FreightJobs.SpecialCharacter06}) then tonumber({FreightJobs.SpecialCharacter06}) else 0; and when it has to extract from £10,000, the 10,000, it gives me 0, so it says that are not numeric in £10,000. The formula works fine for €500, $30,000, ...

I use SAP Crystal Reports and Microsoft SQL Server Management Studio. I have a select1 which retrieve all the jobs, sales I have another select2 which retrieve only the jobs which have invoices to customs; for taking the invoices to customs, I have to link other tables to the original link; I...

Hello CR2013 I have running total sales in the Group Footer Year and the running totals for each client. I can't use sum. I know that I can't have the running totals in Group Header, but I have to display the Total sales per year first. Is it a way around this? Could I have within the group...

I wrote a basic stored procedure from TableJ, that selects all jobs and I developed a report with Crystal Reports which shows the jobs with missing vessels, missing dates,….. Each job has one vessel, one date, … 1. Some jobs with the field value TableJ.car='F' have one or more containers, 2...

Please help on writing this. I have to combine in one select 2 CTEs: one which count the containers for a job, and one with sum sales for a job. 1. ;WIH Cont_CTE AS ( SELECT CJNo , COUNT(1) AS ContCount FROM Cons GROUP BY CJNo ) 2. ;WIH Sales_CTE AS ( SELECT J.JNo, sum(H.Amount*H. Sign) as...

Hi I have to put in a report details on 11 lines the very same data. Does anybody has an idea? I have to copy/paste in sections 1 to 11 the same fields or is another way? JNo JDate Sales 10 21/01/2015 10 line 1 10 21/01/2015 10 line 2 10 21/01/2015 10 line 3 10 21/01/2015 10 line 4 … 10...

I have the table Jobs: JNo JDate Sales 10 21/01/2015 10 11 21/01/2015 20 12 22/01/2015 30 13 23/01/2015 10 14 26/02/2015 10 15 26/02/2015 40 16 26/02/2015 30 17 27/03/2015 20 18 28/03/2015 40 19 29/03/2015 30 20 29/03/2015 60 40 22/01/2016 0 41 23/01/2015 50 42 24/01/2016 50 43 24/01/2016 60 44...

Hello I have in a report a group based on @Name: if {T.Name}='SUA' then 'A' else if {T.Name}='Europe' then 'B' else if {T.Name}=.... I have to put on A a color -crred, on B another color -crblue.... on 3 fields - in Group Header on Group Name - in Group Footer on the sum(sales) - in Group...

Please help me with this: I have a report Prints Group 1 Via Group 2 Client Group 3 Agent Group 4 jobs Details Job, sales1 Job, sales2 Job, sales3 Prints in Group Footer totals I want to print at the end of the report, in Report Footer totals as Sea Agent1 totaljobsag1sea totalsalesag1sea...

thread183-1719654 I wrote it wrong, sorry. I tested it on SQL Server and it works fine, but when I want to base a report on it, takes too much time - not responding for 20 minutes, and I cancelled it. The report is Crystal Reports. Any ideas, I appreciate.

I have to develop a report. I have: The main report based on: USE [db] GO /****** Object: StoredProcedure [dbo].[SCRIPT_1] Script Date: 14/07/2016 11:53:22 ******/ SET ANSI_NULLS OFF GO SET QUOTED_IDENTIFIER OFF GO ALTER PROCEDURE [dbo].[SCRIPT_1] AS set nocount on; SELECT Headers.Date...

Please help. I have a report in which I group by User and Ourref. At the level Ourref I take minimum date because I have to pick from Logdate from many records the one who has minimum date DATEDIFF('d',Minimum ({T;1.PostedDate}, {T;1.OurRef}), Minimum ({T;1.Logdate}, {T;1.OurRef})) And I have...

Hi I have purchases by suppliers and I have to group by sum purchases: --all the suppliers that have sum purchases >50000 --all the suppliers that have sum purchases <50000 >15000 --the suppliers that have sum purchases <15000 >1000 I sort on sum purchases descending but I can't remember how...

I have in a select and ( t.aDate<=getdate() or t.aDate is null or…year???? ) Can/how to write in the same select year(t.adate) >= year(getdate()) or year(t.adate) is null? Because when I refer the year(t.adate) doesn’t take the null records. Thank you

I had a report in Crystal Reports based on a stored procedure SP_OLD. I had to write a new stored procedure SP_NEW and I’ve updated in Set Datasource Location. Now if I look in the Crystal Reports Database/Show SQL Query appears SP_New, as expected. At the time I couldn’t delete SP_OLD, because...

The result of a selection is: …….. T3012246/1 T3011808/14 T3011808/15 T3012316/3 T3011840/1 T3012316/2CT T3011982/1 T3011982/2 T3012326/1CT...

Hi I have a script (SP) for reports. In the sales, I have to subtract TH.GoodsTotal for the jobs that have TD.Narrative LIKE 'VAT'. My issue is with the select bellow, appear only the jobs which have TD.Narrative LIKE 'VAT', and I need the sales for all the jobs (TD.Narrative has other values)...

Please help me with this. I have to do a report. I have to select in the same column the container number CN: for FJ.crg=’F’ from FC.Number and for FJ.crg=’L’ FM.Number. I have to do the same for the container type. How/Can I write an if/case in a select statement? I mention that in select...

Access 2013 I have a table with the cursant name, course, expiry date, email address of the cursant. I want Access to automatically send to each coursant an email which notifies them about the course expiry date, with 2 months before. Can you help me with this?