Using General fields in reports on Windows 11 - Simple Registry Fix! 3

[TamarGranor]

@GriffMG, can I suggest that you add this information to the Visual FoxPro Wiki. I'm sure lots of us are going to be running into this.

Tamar

 

[GriffMG]

Thank you Tamar, I'll have a look at the Wiki, never done that before, so that'll be interesting.

I am absolutely sure many of us will be looking at exactly this problem, at least this gives us all a
bit of breathing space. The APPEND GENERAL side can be accomplished using another machine running
an older version of Windows I would think.


Regards

Griff
Keep [Smile]ing

There are 10 kinds of people in the world, those who understand binary and those who don't.

I'm trying to cut down on the use of shrieks (exclamation marks), I'm told they are !good for you. ​

 

[Chris Miller]

Tamar, Griff,

surely a good though about the Wiki, I think a FAQ post here would also be appropriate and a download can also be made available on

https://www.levelextreme.com/

(former universalthread) and foxite.

And on the APPEND side of the problem, it would be nice to know if only adding an image by APPEND GENERAL is problematic and these keys are not enough, or APPEND GENREAL doesn't work, well, I won't try to avoid the pun, in general.

Chriss

 

[GriffMG]

Tamar

Are you talking about fox.wikis ? it seems to be unavailable

Regards

Griff
Keep [Smile]ing

There are 10 kinds of people in the world, those who understand binary and those who don't.

I'm trying to cut down on the use of shrieks (exclamation marks), I'm told they are !good for you. ​

 

[Chris Miller]

It's on and off at times. Currently I see

http://fox.wikis.com/wc.dll?wiki~VisualFoxProWiki

So just give it a few tries, it's also not generally abandoned.

Recent changes are from 10th and 17th, not as active as the forums, but as far as I know Steven Black lacks the time to scale it up, so it's mostly just conserved the way it is.
But that's okay, as it's a Wiki and therefore still possible to add to on the level of the Wiki functionality.





Chriss

 

[TamarGranor]

Yes, there are occasional problem with the Wiki. I tend to check it every weekday and shoot Steve an email when something needs fixing.

As for not having updates, that's because it's a Wiki and has been around for a couple of decades, so has been loaded with a ton of information. It's not meant as a Q&A site, but as an encyclopedia.

It's the first place I look after the Help file when I need VFP information.

Tamar

 

[Chris Miller]

As for not having updates,...It's not meant as a Q&A site.

Well, for one thing it could have modernization of the interface. But more urgent fixes that make it more stable, as the outages are quite regular.

I said myself, as it's a Wiki, of course the wiki functionality is sufficient to update articles and create new ones. In this case of some lengthy reg files, you can post them as code, as Griff did, but it also is more convenient to have a download and a download section doesn't exist in the wiki - or does it? I don't remember downloading anything from the wiki.

There are good places to post into the wiki, though, as it has the most comprehensible bug lists and bug fixes list. I'm surely not saying avoid to update the wiki ínformation.

Chriss

 

[tomk3]

Hello,


we had to test Win11, so I did an additional test on this problem , just for info (we do not use general fields) :

build a table with a general field appended an image in win10
build a form and a reports with and without using general field, no problem with any reports

Win11
Download creation tool from MS, stored Iso
installed win11 pro 64 bit fresh into a new VMWARE machine.
Installed VFP9 runtime with github runtime installer
Reports using filename work.
report using the general field did not work "OLE ERROR 08004006a Invalid clipboard format" (translated from german)
double click on both registry patches (as admin), accept using regedit, UAC ...
Now report with general field works, too.

HTH
Best regards
tom

Even on the fresh installed system, there is mspaint.exe but with 0 size

 

[GriffMG]

It's a good temporary fix

Regards

Griff
Keep [Smile]ing

There are 10 kinds of people in the world, those who understand binary and those who don't.

I'm trying to cut down on the use of shrieks (exclamation marks), I'm told they are !good for you. ​

 

[Chris Miller]

tom,

thanks for checking. Now what about print from blob? If printing from a file works, it should also do, and be an alternative in case paths to files are subject to change for every user.
And what about APPEND GENERAL with something else, like RTF, for example?

By now the features of VFP9 used and made accessible easier with foxypreviewer can replace RTF usage, but then that's also just the second of many OLE object uses in a report.

Chriss

 

[GriffMG]

I have never posted on the Fox Wiki, but I have given it my best shot

Regards

Griff
Keep [Smile]ing

There are 10 kinds of people in the world, those who understand binary and those who don't.

I'm trying to cut down on the use of shrieks (exclamation marks), I'm told they are !good for you. ​

 

[tomk3]

Hello Chris,

sorry, we only have reports with a logo and footer which are stored into a varianle clogo, cfooter which is referenced in report as option 3, expression or variable name.
We never had an application handling reports with graphics from a table (like maybe a pricelist).

With a general field it was easy for imagecontrol in report, option 2, general field name.

But how to do it with a blob ?
I thought that you can only store filename/path there ?
Option 3 with table.blobfield does not work

If you can give me a simple example I can try.


Regards
tom

 

[GriffMG]

For the blob approach, you need to write the blob out as a temporary (most likely) file, then put the path to that
file in your image object.

Be careful to use CLEAR RESOURCES as needed to avoid changes in the file not being shown

Regards

Griff
Keep [Smile]ing

There are 10 kinds of people in the world, those who understand binary and those who don't.

I'm trying to cut down on the use of shrieks (exclamation marks), I'm told they are !good for you. ​

 

[tomk3]

Hello Griff,

thanks, as I feared it would be

But where to do that during report processing ?
Put a functionname (getmypic() saving, clear resource and return a passname) and set source to expression getmypic() ?
The on.. cannot work I think ?

Regards
tom

 

[Chris Miller]

Tom,

I actually thought setting the blob file name with option 3 (expression or variable name) is enough and forgot there's more to it.
You create an image control with blobimage=Createobject("Image"), use the report band run expression "on Entry" and set it to EXECSCRIPT("blobimage.PictureVal = repotttable.blobimage").
So actually you print the image control and make use of its pictureval property.

Chriss