Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.
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
|Crystal Report 2008 script||4||46|
|dynamically populate report text based on command data||7||39|
|Crystal Reports--specifying a specific detail row to select||2||33|
|can i install CR2016 alongside CR2008 without overwriting it?||4||12|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
9 Experts available now in Live!