Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.
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
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Crystal Reports 2008||6||47|
|Selection between two dates and time range.||21||53|
|Parameter Values Crystal Rep. XI release 2||6||60|
|Crystal Reports issue - getting blank sheet (While Printing or Reading Records needed?)||3||23|
Join the community of 500,000 technology professionals and ask your questions.