Crystal en Antiguedad de saldos de clientes

YesidG · 21 Junio, 2019 17:23

Hola,

Tengo un problema, subi un formato de crystal report al informe de Antiguedad de saldos de clientes y al generarlo no reconoce los parametros los solcicta de nuevo. Describo proceso:

Ingreso parametros para generar informe.

imagen

Este es el resultado:

Escojo el layaout

imagen

pero no reconoce los parametros los pide de nuevo

Agradeceria su ayuda

CJPG · 21 Junio, 2019 17:55

Hola @YesidG por lo que veo tu reporte lo necesitas colocar en el informe nativo del sistema, y por lo que veo no coinciden los parámetros de tu crystal, con los parámetros del informe nativo, ejemplo si realizar un crystal para una factura o un cheque el parámetro seria el docentry, en este caso tendrías que buscar la forma de que coincidiera con los parámetros nativos.

La otra opción es realizar un query que pueda llenar los requerimientos de la antigüedad de saldos, aca te dejo unos ejemplos:
h_tps://answers.sap.com/questions/8111043/antiguedad-de-saldos-en-query-manager.html
h_tps://answers.sap.com/questions/9221151/parametros-en-reporte-antiguedad-de-saldos-crystal.html

Espero te sea de ayuda mi comentario.
Saludos

YesidG · 21 Junio, 2019 19:12

Hola,

Todo lo que me dices ya lo se,

¿alguien que ya haya hecho este porceso sabe como hacer que los parametos coincidan ?

este es el codigo que se ejecuta en el sql profiler

exec sp_executesql 
N'SELECT T0.[TransId], T0.[Line_ID], MAX(T0.[Account]), 
MAX(T0.[ShortName]), MAX(T0.[TransType]), MAX(T0.[CreatedBy]), 
MAX(T0.[BaseRef]), MAX(T0.[SourceLine]), MAX(T0.[RefDate]),
 MAX(T0.[DueDate]), MAX(T0.[TaxDate]),
  MAX(T0.[BalDueCred]) + SUM(T1.[ReconSum]), 
  MAX(T0.[BalFcCred]) + SUM(T1.[ReconSumFC]), 
  MAX(T0.[BalScCred]) + SUM(T1.[ReconSumSC]), 
MAX(T0.[LineMemo]), MAX(T3.[FolioPref]), 
MAX(T3.[FolioNum]), MAX(T0.[Indicator]), 
MAX(T4.[CardName]), MAX(T5.[CardCode]), 
MAX(T5.[CardName]), MAX(T4.[Balance]),
 MAX(T5.[NumAtCard]), 
MAX(T5.[SlpCode]), MAX(T0.[Project]),
 MAX(T0.[Debit]) - MAX(T0.[Credit]), 
 MAX(T0.[FCDebit]) - MAX(T0.[FCCredit]), 
 MAX(T0.[SYSDeb]) - MAX(T0.[SYSCred]), MAX(T4.[PymCode]), 
MAX(T5.[BlockDunn]), MAX(T5.[DunnLevel]), 
MAX(T5.[TransType]), MAX(T5.[IsSales]), 
MAX(T4.[Currency]), MAX(T0.[FCCurrency]), T0.[TransId], MAX(T4.[DunTerm]), MAX(T0.[DunnLevel]), 
T0.[BPLName], T0.[TransId], MAX(T4.[ConnBP]), MAX(T4.[CardCode]) 
FROM  [dbo].[JDT1] T0 
 INNER  JOIN [dbo].[ITR1] T1  ON  T1.[TransId] = T0.[TransId]  AND  T1.[TransRowId] = T0.[Line_ID]   
INNER  JOIN [dbo].[OITR] T2  ON  T2.[ReconNum] = T1.[ReconNum]   
INNER  JOIN [dbo].[OJDT] T3  ON  T3.[TransId] = T0.[TransId]   INNER  JOIN [dbo].[OCRD] T4  ON  T4.[CardCode] = 
T0.[ShortName]    LEFT OUTER  JOIN [dbo].[B1_JournalTransSourceView] T5  ON  T5.[ObjType] = T0.[TransType]  AND  T5.[DocEntry] = T0.[CreatedBy]  AND  (T5.[TransType] <> N''I''  OR  
(T5.[TransType] = N''I''  AND  T5.[InstlmntID] = T0.[SourceLine] )) 
 WHERE T0.[RefDate] <= (@P1)  AND  T0.[RefDate] <= (@P2)  AND  T4.[CardType] = (@P3)  AND  T4.[Balance] <> (@P4)  AND  
T4.[CardCode] >= (@P5)  AND  T4.[CardCode] <= (@P6)  AND  T2.[ReconDate] > (@P7)  AND  T1.[IsCredit] = (@P8)   GROUP BY T0.[TransId], T0.[Line_ID], T0.[BPLName] HAVING MAX(T0.[BalFcCred]) 
<>- SUM(T1.[ReconSumFC])  OR  MAX(T0.[BalDueCred]) <>- SUM(T1.[ReconSum])   
UNION ALL 
SELECT T0.[TransId], T0.[Line_ID], MAX(T0.[Account]), MAX(T0.[ShortName]), MAX(T0.[TransType]), 
MAX(T0.[CreatedBy]), MAX(T0.[BaseRef]), MAX(T0.[SourceLine]), MAX(T0.[RefDate]),
 MAX(T0.[DueDate]), MAX(T0.[TaxDate]),  - MAX(T0.[BalDueDeb]) - SUM(T1.[ReconSum]),  - MAX(T0.[BalFcDeb]) - 
SUM(T1.[ReconSumFC]),  - MAX(T0.[BalScDeb]) - SUM(T1.[ReconSumSC]), MAX(T0.[LineMemo]), 
MAX(T3.[FolioPref]), MAX(T3.[FolioNum]), MAX(T0.[Indicator]), MAX(T4.[CardName]), 
MAX(T5.[CardCode]), 
MAX(T5.[CardName]), 
MAX(T4.[Balance]), 
MAX(T5.[NumAtCard]), 
MAX(T5.[SlpCode]), 
MAX(T0.[Project]), 
MAX(T0.[Debit]) 
- MAX(T0.[Credit]), 
MAX(T0.[FCDebit]) 
- MAX(T0.[FCCredit]), 
MAX(T0.[SYSDeb]) 
- MAX(T0.[SYSCred]), 
MAX(T4.[PymCode]), 
MAX(T5.[BlockDunn]), 
MAX(T5.[DunnLevel]), MAX(T5.[TransType]), MAX(T5.[IsSales]), MAX(T4.[Currency]), MAX(T0.[FCCurrency]), T0.[TransId], 
MAX(T4.[DunTerm]), MAX(T0.[DunnLevel]), T0.[BPLName], T0.[TransId], MAX(T4.[ConnBP]), 
MAX(T4.[CardCode]) 
FROM  [dbo].[JDT1] T0  
INNER  JOIN [dbo].[ITR1] T1  ON  T1.[TransId] = T0.[TransId]  
AND  T1.[TransRowId] = T0.[Line_ID]   
INNER  JOIN [dbo].[OITR] T2  ON  T2.[ReconNum] = T1.[ReconNum]  
 INNER  JOIN [dbo].[OJDT] T3  ON  T3.[TransId] = T0.[TransId]   INNER  JOIN [dbo].[OCRD] 
T4  ON  T4.[CardCode] = T0.[ShortName]    
LEFT OUTER  JOIN [dbo].[B1_JournalTransSourceView] T5  ON  T5.[ObjType] = T0.[TransType]  AND  T5.[DocEntry] = T0.[CreatedBy] 
 AND  (T5.[TransType] 
<> N''I''  OR  (T5.[TransType] = N''I''  AND  T5.[InstlmntID] = T0.[SourceLine] )) 
 WHERE T0.[RefDate] <= (@P9)  AND  T0.[RefDate] <= (@P10)  AND  T4.[CardType] = (@P11)  AND  T4.[Balance] 
<> (@P12)  AND  T4.[CardCode] >= (@P13)  AND  T4.[CardCode] <= (@P14)  AND  T2.[ReconDate] > (@P15) 
 AND  T1.[IsCredit] = (@P16)   GROUP BY T0.[TransId], T0.[Line_ID], T0.[BPLName] HAVING 
MAX(T0.[BalFcDeb]) <>- SUM(T1.[ReconSumFC])  OR  MAX(T0.[BalDueDeb]) <>- SUM(T1.[ReconSum])   
UNION ALL 
SELECT T0.[TransId], T0.[Line_ID], MAX(T0.[Account]), MAX(T0.[ShortName]), 
MAX(T0.[TransType]), MAX(T0.[CreatedBy]), MAX(T0.[BaseRef]),
 MAX(T0.[SourceLine]), MAX(T0.[RefDate]), MAX(T0.[DueDate]), MAX(T0.[TaxDate]), 
 MAX(T0.[BalDueCred]) - MAX(T0.[BalDueDeb]), 
MAX(T0.[BalFcCred]) - MAX(T0.[BalFcDeb]), 
MAX(T0.[BalScCred])
 - MAX(T0.[BalScDeb]), MAX(T0.[LineMemo]), 
 MAX(T1.[FolioPref]), MAX(T1.[FolioNum]), 
 MAX(T0.[Indicator]), MAX(T2.[CardName]), 
MAX(T3.[CardCode]), MAX(T3.[CardName]), 
MAX(T2.[Balance]), MAX(T3.[NumAtCard]),
 MAX(T3.[SlpCode]), MAX(T0.[Project]), 
 MAX(T0.[Debit]) - MAX(T0.[Credit]), MAX(T0.[FCDebit]) - 
MAX(T0.[FCCredit]), MAX(T0.[SYSDeb]) - MAX(T0.[SYSCred]), 
MAX(T2.[PymCode]), MAX(T3.[BlockDunn]), MAX(T3.[DunnLevel]), 
MAX(T3.[TransType]), MAX(T3.[IsSales]), MAX(T2.[Currency]), 
MAX(T0.[FCCurrency]), T0.[TransId], MAX(T2.[DunTerm]),
 MAX(T0.[DunnLevel]), T0.[BPLName], T0.[TransId], 
 MAX(T2.[ConnBP]), MAX(T2.[CardCode]) 
 FROM  [dbo].[JDT1] T0  
 INNER  JOIN [dbo].[OJDT] T1  ON  T1.[TransId] = T0.[TransId]   
 INNER  JOIN [dbo].[OCRD] T2  ON  T2.[CardCode] = T0.[ShortName]    
 LEFT OUTER  JOIN [dbo].[B1_JournalTransSourceView] T3  ON  T3.[ObjType] = T0.[TransType]  
 AND  T3.[DocEntry] = T0.[CreatedBy]  
 AND  (T3.[TransType] <> N''I''  OR  (T3.[TransType] = N''I'' 
  AND  T3.[InstlmntID] = T0.[SourceLine] )) 
   WHERE T0.[RefDate] <= (@P17)  
   AND  T0.[RefDate] <= (@P18)  
   AND  T2.[CardType] = (@P19) 
    AND  T2.[Balance] <> (@P20)  
	AND  T2.[CardCode] >= (@P21) 
	AND  T2.[CardCode] <= (@P22)  
	AND  (T0.[BalDueCred] <> T0.[BalDueDeb]  OR  T0.[BalFcCred] <> T0.[BalFcDeb] ) 
	AND   NOT EXISTS (SELECT U0.[TransId], U0.[TransRowId] FROM  [dbo].[ITR1] U0  
	INNER  JOIN [dbo].[OITR] U1  ON  U1.[ReconNum] = U0.[ReconNum]   
	WHERE T0.[TransId] = U0.[TransId]  AND  T0.[Line_ID] = U0.[TransRowId]  
	AND  U1.[ReconDate] > (@P23)   GROUP BY U0.[TransId], U0.[TransRowId])   
	GROUP BY T0.[TransId], T0.[Line_ID], 
	T0.[BPLName]',N'@P1 datetime2,@P2 datetime2,@P3 nvarchar(254)
	,@P4 numeric(25,6),@P5 nvarchar(254),@P6 nvarchar(254)
	,@P7 datetime2,@P8 nvarchar(254),@P9 datetime2
	,@P10 datetime2,@P11 nvarchar(254)
	,@P12 numeric(25,6),@P13 nvarchar(254),@P14 nvarchar(254)
	,@P15 datetime2,@P16 nvarchar(254),@P17 datetime2,@P18 datetime2
	,@P19 nvarchar(254),@P20 numeric(25,6),@P21 nvarchar(254)
	,@P22 nvarchar(254),@P23 datetime2'
	,'2019-06-20 00:00:00'
	,'2019-06-20 00:00:00'
	,N'C'
	,0.000000,N'C80024'
	,N'C80024','2019-06-20 00:00:00'
	,N'C'
	,'2019-06-20 00:00:00'
	,'2019-06-20 00:00:00',N'C',0.000000
	,N'C80024',N'C800031524'
	,'2019-06-20 00:00:00',N'D'
	,'2019-06-20 00:00:00'
	,'2019-06-20 00:00:00'
	,N'C',0.000000
	,N'C80024'
	,N'C80024'
	,'2019-06-20 00:00:00'

Willy_Caldero · 23 Junio, 2019 03:56

Por experiencia de tratar de usar otro layout crystal en un reporte estandar de activos fijos te digo que es mejor hacer otro reporte con tus propios filtros.
Esos parametros que ves en la consulta no son parametros del reporte, sino que son parametros para armar el query primeramente, asi que no te sirven para tu layout.
Se que hay un conversor automatico de layout PLD a crystal, pero el resultado es tan estructurado y con tantas variables, que si tratas de modificarlo se daña.

Saludos,

YesidG · 25 Junio, 2019 16:13

Muchas gracias por su aporte.

system · 24 Septiembre, 2019 22:13

Este tema se cerró automáticamente 91 días después del último post. No se permiten nuevas respuestas.