Recent content by KBCobra

LOLLOLLOL This works ORDER BY ISNULL(@cSortBy, PolicyHolderDataT.PolicyNumber) I was missing an end ")" Sometimes the simplest things get ya

ORDER BY case when @cSortBy = 'PolicyHolderDataT.PolicyNumber' then PolicyHolderDataT.PolicyNumber when @cSortBy = 'PolicyHolderDataT.PolicyHolderName2' then PolicyHolderDataT.PolicyHolderName2 when @cSortBy = '(PolicyHolderDataT.CoverageAIn / MuellerFormT.nReplacementCost)' then...

Here is the current SP SELECT dbo.PolicyHolderDataT.*, MuellerFormT.*, MuellerGlobalData.dbo.JoinedCustomerTable.*, dbo.StateT.*, dbo.UnderwriterAgents.* FROM MuellerGlobalData.dbo.InternetAuthorizedCompanies INNER JOIN MuellerGlobalData.dbo.JoinedCustomerTable ON...

http://ourworld.compuserve.com/homepages/attac-cg/ for pdf, worked good for us

If this report is more than one page (record) you should create an iif() statement in a field on the page header section that evaluates the date and takes action.

I was just sent back a PDF file from a client that took all the spacing out between the words , has anyone seen this before ? Is it a platform or adobe version problem ? font problem ? TIA Pat Davis

We need to embed 30-40 pictures into an access report which gets outputted to adobe pdf. The problem is the 22inch section width height. There is textual report data in the detail and header and currently half of the pictures are in the detail; and the rest in the footer. Is there any way I can...

Background: 70 user access database with sql2K back end 50+ reports Report contains sub reports all right hand margins (the side being cut off set to 0) auto grow enabled font set to arial 12 On all of the reports parts of words are being cut off what seems like at random. Different machines...

Thats not goingto work then, I need to beable to attach color photo's to reports and enable people to email the report, is there a betterway than this ?

Access 97 everytime I output this report without an image it exports fine to snapshot, as soon as I add a bmp or jpg to the report it says it finishes the export and doesnt error, but the report never appears in the dir specified. Anyone seen this or know the problem. Access 97 sr2 Thanks...