Ok... I tried this. I created this view... which appear to work.
SELECT PCONO, PCSNO, CONVERT(char(1), PCONO) + '-' + CONVERT(char(10), PCSNO) AS cvcust
FROM dbo.PRFITM
Then I added it to this view.... to select the new view ... so that I could then link within the crystal...
Just began using CE and have already scheduled a number of reports. Is it possible to generate a report with the following info: Name of report, schedule,format, and who gets it....??
Thanks for help
I need help with developing a formula for a fiscal period that begins December 29, 2002 and ends December 27, 2003. Each qtr is made up of 4-4-5 wk periods. Where do I begin??? Desperately seeking an answer soon..!!! I need to be able to use the results with different datasets to determine...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.