on 08-12-2017 7:46 AM
Dear Experts,
Greetings from India.
Am learning to create Crystal reports from SAP B1 and trying to create a first layout for a packing label. Though query is good enough and fetching results in SAP, cannot generate code in CR. Can anyone guide me?
SELECT distinct T0.[DocNum], T0.[CardName], T1.[GSTRegnNo], T1.[GSTType], T2.[StreetS], T2.[BlockS], T2.[CityS], T2.[ZipCodeS], T3.[Name], T4.[Name] FROM OINV T0 inner join CRD1 T1 on T0.CardCode=T1.CardCode INNER JOIN INV12 T2 ON T0.[DocEntry] = T2.[DocEntry] INNER JOIN OCST T3 ON T2.[StateS] = T3.[Code] INNER JOIN OCRY T4 ON T2.[CountryS] = T4.[Code] WHERE T0.[DocNum] =[%0] and T0.[Series] =504
User | Count |
---|---|
89 | |
7 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.