Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Help with complex report
Message
 
 
To
03/09/1998 15:31:24
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00131930
Message ID:
00133034
Views:
21
>>>Well, along those lines, let me ask you this. I have been trying today to see how much manipulation is possible of variables (either local or those defined in the report designer) to create details which are outside of what I get with a cursor. (I hope that makes sense...The cursor as it stands for the report is correct; I'm trying to get a little more blood out of the turnip:) To give you a specific example, I was trying to see if I could create a string of last names (or array if that's possible) at the detail level of the report. I was trying to do this using a report variable, but it seems like those variables are all numeric, so I couldn't get my desired results.
>>
>>Report variables do not need to use the Calculate option group on the Report>Variables menu option. You can create a variable with an "Initial Value " that is any data type, and then update that variable in the Value To Store:
>>
>>ex
>>Report Variable: cAllLastNames
>>Initial Value: ""
>>Value to store: cAllLastNames+","+mytable.cLastName
>
>Thanks Rick - that's basically what I did, but the value type where all the fields were listed seemed to show any variables I created as "N". Is that your experience as well, or am I seeing something different?

I just create a table called bobo with 1 field: cname.
Added a few records and filled in the cname field in each

I went to Report>Variables

Created a variable called lcList
Set Initial Value to "" <-- actually put the quotes
Set the Value to Store to: lcList+","+bobo.cname

I put a field in the detail band: cname
I put a field in the page footer: lcList

Previewed the report and saw a comma sep'd list
Rick Hodder
MCP Visual Foxpro
C#, VB.NET Developer
Independent Consultant
www.RickHodder.com
MyBlog
Previous
Reply
Map
View

Click here to load this message in the networking platform