Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.
Is there a way in crystal that instead of returning a formatted data from the query, I return the raw data and add those spacing on the report.
select REPLICATE(' ',26)+ REPLICATE(' ',9 - LEN(residentnumber)) + residentnumber + REPLICATE(' ',29)+ TransactionID+ REPLICATE(' ',16-LEN(TransactionID)) + REPLICATE(' ',30) + cast(Quantity as varchar) +REPLICATE(' ',12-LEN (Quantity)) + cast(sum(UnitPrice) as varchar) + REPLICATE(' ',12-LEN (sum(UNITPRICE))) + REPLICATE(' ',13) + DATE + REPLICATE(' ',8-LEN(DATE))+ REPLICATE(' ',37) AS RECORD from @t group by ResidentNumber,TransactionID,date,Quantity
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.