Creating reports and dashboards | Stimulsoft community forum

Hi,

I am new here. I bought reports.fx for php some days ago and the features are great!
But I'm puzzled by a problem with characters which prevents me from deploying my reports.

When I view my report with the viewer of the stand alone designer, all characters are perfect.
However, when I deploy the .mrt file to my local server, parts of the text look strange. As if the webviewer uses a wrong characterset.
But only some databands are wrong, some bands are fine in both standalone viewer and web viewer. (All bands are on the same report page.)

The same happens at my remote server.

Maybe there are some strange characters in my database? But than again, the stand alone viewer does not suffer from anything.
Standalone viewer and (local) webviewer use same mysql, same database and same browser.
My connection string includes charset utf8. I allowed html characters in the text. I rebuilt the report several times.
Configuration files (from quick start folder) in web server have not been changed.
I am running out of ideas where to look...

Does anyone has an idea what to check?

Thanks, André



XAmmp windows 1.7.3/mySql 5.1/Vista/Reports.FxforPHP 2011.2

Hello.

For detailed answer we need :
1. Screen-shots of correct report and not correct.
2. Your connection string.
3. Sample text from database which looks strange.
4. Font name, used in text component which is displayed incorrectly.

Thank you.

Hello Aleksey,

1. I have attached screen shots in my first post.
2. The connection string: server=localhost;database=dbname;charSet =utf8;port=3306;uid=xxxxxx;pwd=xxxxxx;
3. Sample text can be seen in the screen shots. These include regular textstrings, utf characters, url links.
4. Font name: Arial; 8pt. I tried it using with/without using styles, but there is no difference.


Thank you for your time.

Hello,

Please tell us what type of this field used in the database?

Thank you.

Hello Vladimir,

Fieldtype is text.

Ah Vladimir, your question made me try something.

When I change the field type to VARCHAR, the report renders well.

Is field type Text not supported?

Thank you.

Hello, André

Very strange problem. We have checked VARCHAR and TEXT field types, in both cases the text have displayed correctly. The data table created in the utf8_general code page.

Please indicate that you are using a new release 2011.2 or any prerelease build? Also please tell us the PHP version.

Thank you.

Hello Vladimir,

Yes, I run the latest release 2011.2


Web server:

Apache/2.2.14 (Win32) DAV/2 mod_ssl/2.2.14 OpenSSL/0.9.8l mod_autoindex_color PHP/5.3.1 mod_apreq2-20090110/2.7.1 mod_perl/2.0.4 Perl/v5.10.1
MySQL-client version: 5.1.41
PHP extension: mysqli

The table data is utf8_general_ci

So I guess no obvious reasons why it shouldn't work with Text field types.

Anyway, at least I have a workaround. I can change the TEXT field types into VARCHAR. That's ok with me. :feelgood: So I will do that.

Thanks to both of you for your time.

Hello, André

If possible, please send us a small table dump and the phpinfo(), we would like to understand this error.

Thank you.

Yes Vladimir,

I will send it this weekend (I'm not at the office at the moment).

It will be sent to support@stimulsoft.com.

Great support!