I've been working on trying to modify a custom report for almost a week now and I'm about ready to throw my hands up and give up in defeat. I'm trying to group in InfoMaker and this is a new thing for me. I feel like I understand how it should work, but I'm running into a really frustrating issue. One of my groupings is by MOS but when I run the report, I'm getting "gooesoft_report_parameter.data_column" where the MOS should be. I believe this has something to do do with Report Set up, but I can't figure out what is wrong with it. When I run the SP in SQL, it generates what I would expect the report to be displaying. The MOS displays properly. Has anyone else had this happen and can tell me what I may have done wrong with either InfoMaker or my Report SetUp?
In the report in infomaker, have you checked rows ->sort and made sure the MOS is sorted first? That one used to get me when grouping in infomaker...
Teresa,
One thing to check is that the Column Specifications in Infomaker match the output set of the stored procedure, including field lengths. This can cause all sort of mayhem if they don't match exactly.
David