Recent content by Grouper1138

Well, the process is not the same. I'm using the Add Command so that I can specify a union of the detail and detail history files. The other report only looks at the current detail records and doesn't need to use Add Command. Since I need to see both files contents, that's why I started with...

I finally had time to get back on this issue and got the Add Command correct in version 9. I worked out the syntax problems with the parameter fields and then I could finally save the SQL with the report. I made a simple report of the results, but I can't get any data to show up in the print...

I want to thank LB for helping me get this far! Now my question is this... How do I format the parameters in the SQL statement? - Does the {?parament name} syntax work for that? ----------------------------------------------------- Here's what I've got so far... SELECT GL00100.ACTNUMBR_1...

I found it. Now I'm wrestling with the parameters. Thanks much for the help!

Hi Jason, What I do in that situation is place the item inside a TABLE tag and use the align properties. Haven't tried this with a Crystal Report before, but it may work. We just pop a new browser with the report as the sole contents normally. Dave <table> <tr width="100%"><td...

I have CR 9 running against a Great Plains database. Haven't been able to find where to do the "Add Command".

I have a report that needs to draw data from a history and current detail tables. There was a selection formula that specified only details in a certain date range for the one table. I added the other file in and I'm trying to get the selection criteria fixed to get all the details from both...