Sage 100

I have a crystal report that is driving me insane (short drive, I know!). The report works fine when I run it in Crystal designer, but if I add it to the Sage100 menu it stops working. Seems like somewhere in my past I've seen this but I don't recall why or what the fix was. it is a pretty simple report only odd thing about the report is that it has the same table in it twice (with an alias name). I thought maybe that was the problem so I tried that in ABCcompany on the same Sage 100 version (2014) and it worked fine there.

What happens? Does it pop up an error or simply quit working?

It won't return any data. but I run it on the same company code and same parameters and it returns data just fine. New information to add: If I let sage do it's conversion after the message ""this report must be converted to the latest version"" then the report won't return data when running it from Sage; AND it won't return data when I run it from crystal. BUT if I ""cheat"" and put ""Converted to version 5.10b"" in the summary info then I can still run it from crystal and get data, but running it from the menu will NOT return data I know that is confusing to read, so to summarize: If I let Sage do its conversion, the report is also broken when running it from crystal designer. if I don't do the conversion it works in designer but not from the menu.

David, I had a similar experience very recently. One of the files had be ""updated"" in Database > Set Datasource Location (so it had the old filename in Field Explorer > Database Fields). The file was replaced with the current one. Have you run Database > Verify Database? Or, is it possible to remove the second file reference, and use a subreport, if necessary?

not following you, if you convert it once you shouldn't have to convert it again. It seems like Sage100 can't save the convert, maybe you still have the report open in the designer?

I had a couple of reports for different clients that wouldn't run from the menu in Sage 2013. All of them had subreports in them. They work if you run from the shortcut and outside of Sage 100 but not from a menu. We ended up just adding a shortcut to the report in Sage 100.

I didn't explain it very well your right I don't have to convert a second time. but when I let sage convert it the first time it ""broke"" the report even in crystal designer, so I replaced it with a previous copy and then did the ""cheat"" of copying the required text in the report summary. when I do that, I'm not prompted to convert the report that time but is still will not work from the menu.

I may do what @MaryJoKrueger suggested, but does that mean the user running it needs to have crystal designer installed? I'm thinking it does.

It was installed in all of my situations so I didn't try it without having it installed. It should be though, because it opens it up in Crystal.

You might try checking the ""Convert NULL values"" checkboxes in Report options if not already checked, then comment out any conditions in the ""Record Selection"" area just to see if you can get data to appear. If data appears after commenting out the Record Section conditions, start adding conditions back one at a time until data disappears again. Other possibilities: One or more data sources used in the report are external to Sage (i.e. Access or SQL table). If you are linking to a company file like Sy_Company or SY0Cmp, sometimes these populate when run externally, but don't from within Sage. Different data sources for different tables in your report.

Thanks @ChrisStAmand and all, I ended up commenting and removing things until I finally determined that the using selection criteria based on the ""alias"" table was causing the issue. so i tried using suppression logic to suppress based on that alias and that caused the same issue. Basically, if my testing is correct, you can use an alias table and still run the report from Sage menu as long as you don't want to select or suppress based on that alias table. I resolved the problem by taking my alias table out of the main report and adding a sub report to pull the information I needed and do all my selection in the sub report. That seems to work just fine