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 issues with Crystal Report||10||75|
|Select Cross-tab total||2||69|
|The remaining text does not appear to be part of the formula error||2||42|
|Crystal Reports 7 VB6 'Feature Not Enabled' Error||10||28|