Thanks for the input jlewis, but the problem isn't with the report displaying the "MMM, YYYY" data (I already have that handled). The problem is getting the CMC to display the that data on the CMC's History page.
I have a Crystal report published on Enterprise. The report itself does not need parameters, but I include what I call a "Display Parameter". The purpose of this parameter is to show what Month and Year the report is for when the report is a historical instance (not the latest instance) on the...
k
I'd be happy to share whatever I know. I just started here so I am still getting the "lay of the land". Its a big organization that is using a number of approaches. We are using HR I believe. If I don't have the answer for something you're looking for, there are a number of people here I...
k
That did the trick, I had to change the 8 to a 9 though.
Must have been the dashes.
I understand about the slowness. That's out of my hands unfortunately.
Thanks again very much.
Brett
Thanks for your input k & LB
k,
I apologize for the lack of detail.
I am using v10.
The data source is an ADO object that provides a resultset of data from Lawson Financials. The database is Oracle, but we are required to access the data through Lawson's Query Builder which builds the ADO...
Thanks for the tip.
I failed to mention before that the date info is a string field. So is the parameter. I tried this:
{Table.StringDate} <
CStr(CDate(DateAdd("m", -5, CDate({?@PostingDate}))))
But the only records it returns have a date of "0000-00-00"
I would like to select only PO records that have a date 5 months prior (or greater) to a given Post Date. I know I can conditionally suppress the records in the details section using the DateDiff function, but I want to do this in the selection criteria.
Any help would be appreciated.
Thanks...
It seems no matter how tight I make my rows in Crystal, they come out double spaced in Excel. Any suggestions would be appreciated. Thanks in advance.
Brett Sheets
I have three tables - Header, Details, & Budget.
Header and Details have an inner join. Details and Budget have a left outer join.
I want to display Budget.Amount when there are related budget records, however, sometimes there are no budget records. In that case I want to display a 0. The...
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.