General information
Category:
The Mere Mortals Framework
I started this report with a very simple view so that I could put my first MM report together simply first to understand what is going on. Here's the view:
SELECT Taxentry.iid, Taxentry.clientid, Taxentry.company, Taxentry.checkdate, Taxentry.approved, Taxentry.approvedby, Taxentry.approveddate, Taxentry.unapprovedby, Taxentry.unapproveddate FROM cbstax!taxentry ORDER BY Taxentry.clientid
What's really strange it that when I instantiate the bizobj that loads this view outside the report as you suggest, it returns all records in taxentry (as it should) along with a first record where each field contains .null.
The taxentry table does not contain this record and does not allow nulls in any fields.
Have you ever seen this?
I will continue to poke around in the ProjTask.frx.
Thanks
>Sally,
>
>>I'm following the "Setting View Parameters for Reports" instructions but I'm not getting anywhere. Even if it wasn't returning any records, it should still do something like show a blank report, no?
>
>Not necessarily, by default, if your report has no data, VFP's print preview window opens up quickly and closes down again.
>
>>I'm sure I've got everything screwed up now with this report. I know it has to do with my inexperience with business objects and data environment objects. This way of creating a report is so foreign to me. Do I need a business object on the form that asks for a date range? >
>
>You really only need a business object if you are retrieving data from the back end or updating data.
>
>Here's what I recommend...make sure the business object works properly outside the context of the report. That means, instantiate it from the Command Window and check to make sure it returns data. For example:
>
>DO SetX
>x = CREATEOBJECT("MyBusinessObject")
>** Set your view parameters here
>x.Requery()
>
>If this works fine, have you checked out the sample Project Manager application to see how I'm doing it? If not, open up ProjMgr, go to the Documents tab in the Project, and open the ProjTask.frx report. Right-click on the report, and select "Data Environment" from the shortcut menu. Next, right-click on the form's Data Environment window and select "Code" from the shortcut menu. You'll see I have code in the Data Environment's "BeforeOpenTables", "Init" and "Destroy" methods that you can look at.
>
>I'd like to help you figure this one out...Let me know what you discover!
>
>Regards,
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only