Search results for query: *

When I drag and drop and view the query, it shows field1 = FileAuthor but when I try this in command, it doesn't like it.

I'm using Crystal XI and writing my on Command. I need to use one of the Special Fields of Crystal as a value. For example: SELECT TABLE.FIELD1, TABLE.FIELD2 ... WHERE TABLE.FILED1 = FileAuthor (File Author is one the Special Fields) Maybe I don't don't have correct syntax? If I don't write my...

I figured it out. Just in case anyone ever had the same problem, just open formulas editor, on the toolbar click on the "Field Tree" icon, you can point the cursor on each icon to find out, or just click ALT+F.

I have no idea what I did but I can't select a field from database to my formula anymore. The "Field Explorer" is now in a separate window and is disable. How can I reset the Crystal report default display? I am using SAP Crystal Reports 2016, Version 14.2.2.1975. I shutdown Crystal, restarted...

Data error. It fails when the filed is blank. I checked for null and missed blank. Thank you for your help!

No, the report runs without error. Error when I try to export to excel. Thanks.

I'm sorry, I'm not sure this is the right forum for this kind of question. I'm using Crystal XI. In a group section, I use a formula to suppress unwanted values. When exporting it to excel, it stops and popups this formula. What is going on here? Thank you.

Never mind, I got it. Just in case someone else needs to know ... On the tool bar, go to View -> Toolbars -> Check "Reset all all toolbars and explorers next restart". Thank you.

I accidentally close Field Explorer on my XR XI and can not figure how to restore it. Can someone please show me how to get back to the default layout? Thank you.

Thank you for your help. I'm not quite there yet. Working with the provided direction.

I have two reports included in one: 1 detail and one summary. How do I reset page number for the summary report? Thanks.