Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
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
Join the community of 500,000 technology professionals and ask your questions.