General information
Category:
Reports & Report designer
Title:
Trying to Move Record pointer in Report
Ok, I've done a lengthy search on this in the UT and I must not be asking the right questions because I can't find anyting. I also know I've done this before but for some reason I'm having a brain fart.
I have a report that pulls data from a temporary cursot that gets built on the fly with a sql statement. The cursor is called tempcur.
One of the fields in the detail band of my report has the following express oApp.GetBval(). GetBval is a method of my application object that that returns a numerical value. To do this, in the method I'm doing a seek in another table based on the value in tempcur.cust_id.
The problem is that record pointer in tempcur does not appear to be moving because I get the same value in that field for all of the records. What am I doing wrong here? Is there a better way to do this, maybe by setting up a relationship from the temporary cursor, into the other table? And if so, will that cause the pointer to move?
I know I'm going to feel dumb when I get the answer to this, because I remember facing this before and the solution was really simple.
Thanks in advance!!!
-Rick
Next
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