LB, this is exactly what I was looking for. I work all October on various calendar solutions. Is it possible to email me a copy of this crystal report.
Thanks
aud9
rwhetsell@sc.rr.com
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
bdreed35 I saw this FAQ but had some concerns because I was not working with a calendar year fiscal period. I will try this and will let you know what happens. Also, how did you use this formula in the report.
Thanks again,
Aud9
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...
Got any suggestions for calculating fiscal periods where weeks are used instead of months. For ex. 1st fiscal period is 1st 4 wks of the year and then another 4wks then 5 wks, then 4wks, 4wks, 5wks again until the end of calendar year. Meed to be able to group data by this fiscal periods.
Aud9
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.