FAQ MyReport

How an array of overlapping slippery?

sgosavi — 21/02/2012

problematic

January 2007

February 2007

March 2007

How to work on a live database (real time)?

vjain — 21/02/2012

To make a real-time database: - create your connection - create a model with all the tables you want, do your various joints. - Take into destination fields, all fields required for your reporting. - Group , rename, describe. - To create fields transformed into a model without a load, you must check "SQL Formula" in the Fields window and then transformed into SQL type your formula in the language of your database engine. (Eg SQL for SQL server, Oracle SQL for Oracle database ...) - Put your template without loading (Properties of the model, then uncheck Load "). - Post your model. - Manage your users. Attention: * especially make no etl on this model. * that directly solicits the source database and can "disrupt" the operation of the application if bp modeling

Get the duration between two dates in the format year month day

vjain — 21/02/2012

CurrToStr (Trunc (MonthSpan (date1, date2) / 12)) & "years" &
CurrToStr (Mod (Trunc (MonthSpan (date1, date2)); 12)) & "months" &
CurrToStr (DaySpan (date;
IncMonth (date2 ; Trunc (MonthSpan (date1, date2))))) & "days"

What browsers are officially supported and promoted?

sgosavi — 17/02/2012

The browsers officially supported by MyReport Center are:

IE 7 and above
Firefox 4 and higher
Chromium 14 and higher
Safari 5 and above
Opera 11 and higher

We recommend using Firefox.

How to integrate MyReport SDK in a project. net on a 64-bit extension?

sgosavi — 17/02/2012

In Visual Studio:
1. Right click the solution, Configuration Manager.
2. Put x86 in the Platform SDK project that uses MyReport.

Object Reference is incorrect, why?

sgosavi — 23/12/2011

Please check connection of Datawarehouse on MyReport DataRun.

IIS maneger settings? or How to configure IIS so that MyReport Center is working properly?

sgosavi — 16/12/2011

IIS configuration for Center:

Set write permissions for the user and modification of IIS_IUSRS:
- All MySystem that will be accessible from the Center
- If the Center crashes when validating login, go to IIS, open the advanced properties of the application pool used by the Center, in the advanced properties, to Load User Profile to True.

For 64-bit platforms:

In IIS, open the advanced properties of the application pool used by the Center
Change the setting Enable 32-bit applications to True

If you have installed. NET Framework 4 before installing IIS, perform the following operation:

Open a command prompt in administrator mode.
Go to C:>> Windows >> Microsoft.NET >>Framework >> v4.0.30319
Run aspnet_regiis.exe-i

If you have any concerns, you can go to application pools in advanced settings, you change identity to LocalSystem

What if we have the message Incorrect file version when connecting to the server 100 of payroll in 2008?

sgosavi — 13/12/2011

With the ODBC v16.02 Server 2008 in, copy the file pms1lib.dll (dated 26/04/10) in c:>>windows>>SysWOW64 on the server.
The installation of pay not doing so, we must make the copy manually.

[hr/]Note: The error message is completed with The version of the ODBC driver does not support the requested behavior.

What are the user group?

jcsoliveres — 04/12/2011

Contact Management : Will get strategic news.
Contact Administrator : Can modify his company and all the contact of his company.
Contact commercial : Will get the lead details
Contact Invoice : Will receive the invoices.
Contact license : Will get the license code.
Contact technical : Will get all technical news.
Contact business : Will get all commercial news.
Contact Extend : Will be able to extend trial.

What to do when the toolbar Builder does not work in Excel 2007 or 2010?

sgosavi — 02/12/2011

Right click on the menu Builder 5, delete the custom command
Right click on the toolbar Builder 5, delete the custom toolbar
Click the Office
Click on Excel Options
Select Add-Ins
In the Manage drop-down menu, select Disabled Items, click Go
Enable MyReport Builder 5
Close Excel and reopen

What is password for webadmin user on center page?

sgosavi — 30/11/2011

Solution : password

What client should be used on posts to connect to databases natively?

sgosavi — 15/11/2011

What if I have the error message Access violation\\ when I create a new Excel template?

sgosavi — 15/11/2011

1.Delete the images in the source workbook.

2.Clear filter machines in the source workbook.

3.Clear filter list (objects of type combo box)

Why ETL blocks when deleting the table?

sgosavi — 15/11/2011

When using the 2.0.3 version of Firebird, if you launch an ETL on a model after asking to see the data query, ETL hangs when removing from the table.

Proposed Solution : Update Firebird installing version 2.0.5 or higher.

What to do when I get The connection was completed properly?

sgosavi — 15/11/2011

Server5.exe

How to integrate a toolbar in Excel?

sgosavi — 15/11/2011

It is four ways to integrate a toolbar in Excel:

Builder5.xla add the file in the folder C:>Program Files>Microsoft Office>Office11>XLStart
Builder5.xla add the file in the folder C:>Documents and Settings>UserName>Application Data>Microsoft>Excel>XLSTART
In Excel> Tools> Add-Ins> Browse ... > Select the file and validate Builder5.xla
Double click the file Builder5.xla

When integrating a toolbar in Excel using several methods, it may be a conflict of macros.
In this case, cancel the integration by a method and an update to the toolbar in Excel.

What to do when was the message Can not open file C: ....> Utilisateur.inf. Access Denied?

sgosavi — 15/11/2011

At the launch of MyReport Builder or Viewer TCP/IP, it may be that the service does not have permission
to access the folder MySystem.

On the server where MyReport Server installed in Windows Explorer, select the
folder MySystem, then right click Properties.
Select the Security tab, then click Add ... .
In the Select Users or Group, click Advanced and click Search.
Select Network Service, or if it does not, select Services, then click OK.
Confirm again by clicking OK.
Select NETWORK SERVICE and check Allow Full Control.
Confirm by clicking OK

How to display the ribbon Developer?

sgosavi — 15/11/2011

Click on File then Options.
Go to Customize the Ribbon.
On the right, in Main Tabs check Developer.

What if the conditional formatting is displayed in black or shift?

sgosavi — 15/11/2011

Service Pack for Microsoft Office 2010 ( KB2460049), 32-Bit Edition Service Pack for Microsoft Office 2010 (KB2460049), 64-Bit Edition

I hide columns in Excel but they are redisplayed when updating the report, what to do?

sgosavi — 15/11/2011

If you want to hide columns in a report, think to uncheck the option Resize the columns.

This option is in Tools> Options report> General tab

The update in Excel is slow, why?

sgosavi — 15/11/2011

If the display is less than 100%, you need to climb to 100%.

Can you run a report in a protected sheet?

sgosavi — 15/11/2011

When a sheet is protected, it is not possible to merge or demerge cells.

It is not possible to remove the format of a cell (the protection of a cell being included in the format of the cell).

It is therefore not possible to run a report with fusion or with a format.

In addition, to run (or update) in a protected sheet, you must allow: * modification of objects, so we can insert the comment. * the format of the columns, so we can resize columns.

How to integrate a toolbar in OpenOffice.org?

sgosavi — 15/11/2011

How to Add a toolbar:

Open OpenOffice.org Calc
Open Tools> Extension Manager ...
Click Add ...
Select the file Builder5.zip located in the installation directory MyReport.
Starting with version 3.0 of OOo, answer the question Who do you want to install this extension?
Restart Calc.

How to remove a toolbar:

Open OpenOffice.org Calc

Open Tools> Extension Manager ...

Select the extension to delete, then click Delete

[*]Restart Calc.

What to do when I receive an error message when closing the session?

sgosavi — 15/11/2011

The problem is the Quick Start OpenOffice. Org, the solution is to remove it from the start of the operating system.

What to do when saving a workbook with drop-down list in xls file corrupted?

sgosavi — 15/11/2011

It is a known bug in OpenOffice.org.

It is fixed in version 3.3.0.
The solution is to update OpenOffice.org. Link to issue:
http://www.openoffice.org/issues/show_bug.cgi?id=105461

What if MyReport Builder does not create more comments?

sgosavi — 15/11/2011

This problem arises from the version 3.1 of OpenOffice. Org.

The solution is to update the products MyReport version 5.6.0.4 or higher.

on a TSE server, what if the toolbar does not work?

sgosavi — 15/11/2011

The TSE session should be in the group Power Users.

Keywords: builder5.exe viewer5.exe found Open Office OOo OpenOffice

on a TSE server, what if the communication between OpenOffice.org and MyReport Builder does not work?

sgosavi — 15/11/2011

If the user is logged on the TSE server with a session that does not have administrator rights:

Open the C:>Windows>system32
Right click on the file ole32.dll, and then Properties.
On the Security tab, select the TSE session user or user group that contains the TSE session.
Add Rights Amendment and Scripture, and confirm with OK.

I want to insert in Power Point report and update from PowerPoint

sgosavi — 15/11/2011

In Excel:

Building Arrays with MyReport Builder.
Save the Excel workbook.

In MyReport Messenger:

Create a diffusion source is the Excel workbook.

In PowerPoint:

Building the presentation.
Insert Table Builder
- Select Table in Excel, and make copy.
- Go to the slide and Power Point to edit, Paste Special and select Paste Link.
Create a macro in PowerPoint (on the home page, insert a button called update data) which will launch the update tables created with Builder.
To do this, insert the following line marcro in Power Point:
- CheminMessenger.exe> Project: ProjectName >Distribution: NomDiffusion
  (see Help MyReport Messenger, choose The implementation of the broadcasts,>chooseRun Command Line)

The user will only have to click the update data found, for example on the first slide in PowerPoint, so that the full slides are updated.

How to display in a cell, the list of values of an area?

sgosavi — 15/11/2011

Function valuel (aList As Range) As String
For Each c In aList
If InStr (valuel, Trim (c.Value)) = 0 Then
If valuel = \"\" Then
valuel = Trim (c.Value)
Else
valuel valuel + = ; + Trim (c.Value)
End If
End If
Next
End Function

Set and How to combine Totals computed from the formula?

sgosavi — 15/11/2011

How a weighted average?

sgosavi — 15/11/2011

When an indicator is an average, totals and subtotals are an average of averages, not a weighted average.

For the weighted average, create a calculated field whose formula contains the field to be average, then check Totals computed from the formula.

Example: To view a report by product family and the average amounts per invoice, create a calculated field named average amount of which the formula is the quantity of the model, with total calculated from the formula. Then select the main interface aggregation average.

What if floating licenses are activated but the product remains in evaluation period?

sgosavi — 14/11/2011

In the options in the login window, check TCP / IP is checked products MyReport Builder and Viewer or Floating License is checked for the product MyReport Data.
Launch the Administration Console, then stop and restart the service Server5.
In the list of Windows services, if the service account is noted as Local System account and not as Network Service, uninstall then reinstall the service.

Where can I host the file MySystem?

sgosavi — 14/11/2011

Can you host the file on a linux server MySystem?

sgosavi — 14/11/2011

MyReport 5 Server can not access to files hosted on a Linux server using Samba for sharing files with a Windows PC.

Can I install the game MyReport Server in a network directory?

sgosavi — 14/11/2011

No, you must install and activate the server part in a local directory on the server. For example, we can not use the\\Server\\defer\\MyReport5

Why can not I start the service MyReport Server 5?

sgosavi — 14/11/2011

The error message is:

Unable to start service MyReport 5 Server on Local Computer.
Error 5: Access is denied.

In the Data Explorer, right click on the application Server5.exe, then Properties.

In tab Security, click Add .... Click on Object Types ..., ticked do not let that Entities integrated security , then press OK.

Click Advanced ... and then Search .

Select NETWORK SERVICE, then press OK.

Close the Select Users or Groups by clicking on OK. Add right Full Control to NETWORK SERVICE and validate.

What to do when I get Server 5 MyReport launched the session NetworkService has no rights Access Demonstration Project ?

sgosavi — 14/11/2011

At the launch of MyReport Builder or Viewer TCP / IP, it may be that the service does not have permission
to access the folder MySystem.

On the server where MyReport Server installed in Windows Explorer, select the
folder MySystem, then right click Properties.
Select the Security tab, then click Add ... .
In the Select Users or Group, click Advanced and click Search.
Select Network Service, or if it does not, select Services, then click OK.
Confirm again by clicking OK.
Select NETWORK SERVICE and check Allow Full Control.
Confirm by clicking OK.

How can we trust to the VBA project?

sgosavi — 14/11/2011

On the Ribbon Developer, Code, click on Macro Security. Check Enable all macros. Check Trust access to the object model of the VBA project.

Where is the manager names?

sgosavi — 14/11/2011

The manager names (which allows you to view all zones created in Excel) is available in the Ribbon Formula.

What to do when the message Microsoft Excel has stopped working appears systematically closing Excel?

sgosavi — 14/11/2011

You will need:

Open Excel
Open the tab Developer
Click on the menu Visual Basic to open VisualBasic
Close VB
Close Excel

What to do when the tape is no longer displayed MyReport Builder?

sgosavi — 14/11/2011

- Click on the windows of Excel
- Go to Excel Options
- Go to the Add-Ins tab
- Select Disabled Items in the Manage drop-down menu at the bottom of the window
- Click Go
- If the file Builder5. xlam appears, select it and click Enable

What to do when you have the error message: Unable to set the Weight property of the class Border?

sgosavi — 14/11/2011

Update products MyReport version 5.7.1.1 or higher. MyReport For versions below 5.7.1.1: In the Format Report: do not put borders to the labels of rows and columns.

In the properties of a indicator and / or a dimension: remove custom borders. Note: these are set automatically when it makes Active format.

What if the update is launched several times in a row?

sgosavi — 14/11/2011

The solution is to disable the toolbar Eurotool.

Click the Office button.
Click on Excel Options.
Go to Supplements.
In Manage: Excel Add-ins, click Go ...
Uncheck Tools for the euro and confirm.

What if we have the message A file named Builder5.xlsm already exists in this location. Do you want to replace it? opening Excel?

sgosavi — 14/11/2011

Close Excel.
Delete the file found in Documents Builder5.xlsm.
Move the file Builder5.xlam the file C:\\Program Files\\Microsoft Office\\Office12 \\XLStart\\folder or C:\\Program Files\\Microsoft Office\\Office14\\XLStart\\to the desktop.
Double-click the file Builder5.xlam.
Click \"Enable Macros\".
Close Excel.
Move the file Builder5.xlam the desktop to the folder C:\\Program Files\\MicrosoftOffice\\Office12\\ XLStart\\or C:\\Program Files\\Microsoft Office\\Office14\\XLStart\\

Where can I download SQL Server Express?

sgosavi — 10/11/2011

http://www.microsoft.com/express/Database/InstallOptions.aspx

We recommend that you download the Database with Management Tools

What if I have a field of type DateTime2 that does not return data?

sgosavi — 10/11/2011

When a field of a source database is typed DateTime2, sometimes the ETL back a blank value.

To overcome this problem, use a transformation via a SQL formula:
CAST (AS ChampSource datetime)

What is the port used by default?

sgosavi — 10/11/2011

The default port used by SQL Server is TCP 1433.

What are the limitations of SQL Server Express?

sgosavi — 10/11/2011

http://msdn.microsoft.com/en-us/library/ms165672

http://www.microsoft.com/express/Database/Default.aspx

How to convert a field of type TIMESTAMP dated?

sgosavi — 10/11/2011

Explications

How to refer to another record?

sgosavi — 10/11/2011

context

solution

Model 1

Pattern2

Warning:

What if my job with planfi�e datarunwin does not work or does not set the right project in the datarun?

sgosavi — 10/11/2011

MyReport Datarun restart with administrator rights, open the main interface and click OK.
If the problem persists, check the scheduled task that the option \"Run with highest privileges\" is unchecked.

I use Windows Vista Home Edition and the opening of a query is extremely slow, what to do?

sgosavi — 10/11/2011

You must install the service pack 1 (SP1), it fixes the problems of slow opening applications.

What to do when opening MyReport Datarun is very long?

sgosavi — 10/11/2011

If the main interface of MyReport Datarun opens, click on Connections, then View models, select List.

If the main interface of MyReport Datarun takes too long to open, in Windows Explorer in the directory MySystem project that is the problem, open the file Datarun.ini, and edit the line ModeAffichageModele = ModeArborescence by ModeAffichageModele = Modeliste

What to do when MyReport Datarunwin starts from the explorer but not from the scheduled tasks?

sgosavi — 10/11/2011

Explanation :
The scheduled task is probably launched from a Windows account other than the user, and MyReport Datarunwin was activated with the Windows User

Solution : - Disable license from the user\\\'s account - Activate the license on the Windows account that runs the scheduled tasks

What planif�e check if a task has no run-time error in closed session but MyReport DataRunWin did not run?

sgosavi — 10/11/2011

If a scheduled task, running MyReport DataRunWin, runs correctly when launched manually, but when it is launched closed session it has no runtime error but that did not work MyReport DataRunWin it can perform the following test:

create a monTest.bat
place a file (text, doc, xls, ...) in the same directory as the monTest.bat
write the command to copy this file as follows monTest.bat (by editing the file with Notepad):
COPY fichier.extension copie.extension
(eg COPY document.doc copie.doc)
create a scheduled task the same as running MyReport DataRunWin who will call monTest.bat
schedule the task to run in closed session

What to do when ETLS launched by MyReport Datarunwin run from the explorer but not from the scheduled tasks?

sgosavi — 10/11/2011

Windows 7 and Windows Server 2008, options MyReport Datarun must be run with administrator rights in order to write to the registry (HKLM) projects to be loaded.
To do this in the Start> All Programs> Report One, clquez right MyReport Datarun Options , then the Compatibility tab check Run this program as administrator.

What to do to load the data warehouse only on order?

sgosavi — 10/11/2011

Daily

What if MyReport Datarun is no longer active as I have already activated 5.5.0.0 or 5.5.0.1?

sgosavi — 10/11/2011

Call the agency in Paris 01.53.24.20.29 so that reactive profile.

What if the scheduled task DatarunWin5 not start.

sgosavi — 10/11/2011

If the scheduled task does not start when it is configured as that can run even if the user is not connected.
Follow these steps:

Change the configuration and mark: Only run if the user is connected.
Trying to run the task.
If the job runs. Is that the user has no right to perform tasks in closed session.
Further amend the configuration of the task and select: Run even if the user is not connected

See the Microsoft site to allocate the necessary rights: http://technet.microsoft.com/fr-fr/library/cc755659 (WS.10). aspx

How to disable the zoom to a viewer?

sgosavi — 10/11/2011

In the latest version to prevent a viewer zommer must:

- apply the \"master\" on the report and not to details.

How to start broadcasting in Windows scheduled task?

sgosavi — 10/11/2011

To start the execution of scheduled task in Windows releases, call:

(MyReport versions prior to 5.5): the executable Messenger5.exe with the run.
(From MyReport 5.5): the executable MessengerRunWin5.exe

What if the workbook has come in cells # NAME?

sgosavi — 10/11/2011

The problem is that the workbook uses Excel formulas appeared in 2007 and is in XLS format.
The solution is to move to the xlsx format for example, or another format introduced with Excel 2007

What are the SMTP settings to use an inbox hosted by Google?

sgosavi — 10/11/2011

The parameters are:

smtp server: smtp.gmail.com
port:587
User: complete address (incorporating the @ domaine.com-name example @ gmail.com)
password: password
check the use authentication
Sender address: address (by including the @domaine.com-name example @gmail.com)

RESTRICTION : Avast anti-virus MUST be installed on the computer (with optional scan outgoing mail enabled). This setting MyReport Messenger5 is only compatible with this virus.

What does the message Unable to open xlsx file format or as its extension is not valid. [.. .] when opening a file generated by MyReport Messenger?

sgosavi — 10/11/2011

The message Unable to open xlsx file format or as its extension is not valid. Verify that the file is not damaged and that the extension matches the format of the file is displayed at the opening of a file generated by MyReport Messenger when the source file contains too many characters

(eg. spaces after the extension of the source file).

Why send an FTP server crashes?

sgosavi — 10/11/2011

The shipment can be blocked by the firewall. With older version of Messenger MyReport, you must configure it to allow incoming connections to MyReport Messenger.

I can not use the PDF export, what can I do?

sgosavi — 10/11/2011

Please check the version of PDF Creator:

version 5.2.1 to version 5.5.0 of MyReport Messenger, PDF Creator must be version 0.9.3.
version 5.6.0 to version 6.0.1 of MyReport Messenger, PDF Creator must be version 0.9.6.
From version 6.0.2, you can use all versions of PDF Creator.

If you are not using the correct version of PDF Creator, please uninstall it and install the correct version. PDF Creator 0.9.3 Setup Setup PDF Creator 0.9.6

MyReport Messenger generates Why does the file extension. pdf.pdf?

sgosavi — 10/11/2011

No pdf viewer is installed on this post.

Install a PDF viewer (Acrobat Reader, Foxit, ...) to fix the problem.

What to do when the distribution blocks when exporting to PDF ?

sgosavi — 10/11/2011

The solution is to uninstall PDF Creator, to the question Clear settings?, Answer yes, then reinstall PDF Creator using the setup installation MyReport.

What if the PDF export only prints the first page?

sgosavi — 10/11/2011

The solution is to put the same print quality on all the worksheets in the workbook. How do I change the print quality of a sheet:

Open the spreadsheet.
Click the Office button, then Print, then Print Preview.
Version 2007 and higher in the print preview, click on Layout.
Version 2003 and less in print preview, click on Page ....
The drop down list Print Quality, select the correct value.

Warning :
The print quality does not apply to the entire workbook but just for the selected sheet.

Link to the Microsoft website giving more information: http://support.microsoft.com/kb/168563/fr

USED The distribution does not work through a scheduled task, what to do?

sgosavi — 10/11/2011

An application launched by a scheduled task on a Windows Server 2008 can not use Excel without open session.
An error message OLE 800A03EC appear in the error log. The solution is to keep an open session on the server and locked with a password. articles giving details of the issue: http://support.microsoft.com/kb/257757

I have Bit Defender 2009 macros and toolbars can not run

sgosavi — 10/11/2011

Macros toolbars can be blocked by Bit Defender. In 2009 Bit Defender, select the mode Advanced.

In the Antivirus>Exclusion, added the. Xla corresponding to the toolbar, and then apply.

Kaspersky and I MyReport Builder does not launch when I click the button on the toolbar

sgosavi — 10/11/2011

The launch of MyReport Builder from Microsoft Excel can be prevented by blocking macros by Kaspersky.

To unlock, right click on the icon Sentinel Kasperski> Tab Settings> Display Settings> Security Settings and check low.

I can not put an aggregate sum over a field, why?

sgosavi — 10/11/2011

The field is noted as a dimension of analysis, you must qualify as an indicator in MyReport Data.

What to do when I receive an error message when I add a filter in my report?

sgosavi — 10/11/2011

What to do when the message size too big comment ?

sgosavi — 10/11/2011

From version 6.0.1.0: report of the options -> General tab -> select Optimize the size of the comment
Make up Calculated Fields in calculated by the spreadsheet
If it is not possible, can you try the following operation:
Create the fields in the model (MyReport Data) and make available to the Builder.

What if I lost my models after changing my password from the toolbar MyReport Builder?

sgosavi — 10/11/2011

When the password is changed from the menu MyReport Builder, the user no longer has access to the models.

This problem is encountered with version 5.7.0 to version 5.7.1.1. To put the records available and models, we must go in the management of distributed models in MyReport Data, and then delete the repost.

What if the application crashes during the creation of interfaces?

sgosavi — 10/11/2011

How to change the default chart type?

sgosavi — 10/11/2011

To change the default chart type:

Standard Types

Default

How do I remove the leaves backup in Excel?

sgosavi — 10/11/2011

If you are in Excel 2007
- Show the Developer tab (Windows Button -> Excel Options -> Standard Tab -> Show Developer tab in the Ribbon)
- Click on Visual Basic If you are in an earlier Excel - Display the Visual Basic toolbar (View -> Toolbars -> Visual Basic) - Click on the Visual Basic Editor In the Visual Basic Editor - In the tree on the left, all the leaves that begin with mr_ are sheets of backup - Select the sheet you want to delete - In the property grid, change the Visible property of 2 - 0 in xlSheetVeryHidden - xlSheetVisible - Go back and delete the Excel sheet that was displayed

Why am I a cell of a field calculated filled with # REF

sgosavi — 10/11/2011

This error is because of using a spreadsheet cell that is out. To solve this problem simply insert a column before the table.

Why fields calculated by Excel displays the formula and not the result of the formula?

sgosavi — 10/11/2011

When the field was calculated as a mask display text, Excel does not interpret the formula but the displays as text.

It is in this case as a mask to Standard display so that Excel interprets the formula and displays the result.

fields Why symbols are not displayed correctly?

sgosavi — 10/11/2011

This is because you do not have the fonts used by the product MyReportBuilder. To fix this please download this zip .

Then add these fonts in the Control Panel in the Fonts folder.

What to do when the toolbar Builder does not work in Excel prior to 2007 ?

sgosavi — 10/11/2011

To update the toolbar Builder5 (or Viewer5) in Excel:

Customize

Toolbars

Builder 5

Delete

Build 5

Delete

What to do when I get the message Unable to connect to Excel?

sgosavi — 10/11/2011

1 - Start the Visual Basic Editor from the toolbar Visual Basic

2 - When Excel 2007 has not yet been validated, it is not possible to work with MyReport Builder can not connect to it and displays the error message Interface not supported.

This problem also happens when Microsoft Office 2007 Primary Interop Assemblies is installed on the machine.
If you purchased Office 2007, just validate the license of Excel 2007.
If you have a demo version of Office 2007 and work with an earlier version (2003), you must uninstall the trial version of Office 2007.

What to do when I get the message [The macro Builder5.xla found] or [The macro Viewer5.xla found]?

sgosavi — 10/11/2011

- Update the toolbar in Excel
http://www.myportal.fr/faq_edit.php?modifier_faq=14

What to do when I have the error message [Call was rejected by callee]?

sgosavi — 10/11/2011

This message occurs when the automatic recording of data recovery starts Excel and creates a conflict with the products MyReport. The solution is to disable the automatic registration.

Open Excel.
Go to Tools> Options> Save tab.
Unchecking Save AutoRecover info every.
Click on OK.

When this happens, it may be an error message is displayed by MyReport Builder indicating a problem when assigning borders, formatting cells or assignment of the policy.

What if I have an error message when I select a value in a combo?

sgosavi — 10/11/2011

Sometimes the macro associated with a drop-down list conflicts with the timing of the My Documents folder, which results in displaying an error message on the screen. To avoid this, simply disable the macro associated with the drop down list as follows:

Go to the options report, [g]General tab.
Uncheck the option Create the macro associated with the filter list and click OK
Run the report in order to take into account the change.[/g]

What if a new blank workbook appears when I use MyReport Builder?

sgosavi — 10/11/2011

Close MyReport Builder.
Close all Excel workbooks.
Open the Windows Task Manager, go to the Processes tab.
Find EXCEL.EXE process and complete the process.
Restart Excel and MyReport Builder.

What does the message [This workbook has lost its VBA Project, ActiveX Controls and other programmability-related features.] ?

sgosavi — 10/11/2011

This message appears when Excel was installed without VBA part. It should reinstall Excel in this case by checking the VBA.

How to display the ribbon [Developer]?

sgosavi — 10/11/2011

In Excel 2007 Options> tab, check Show Developer tab in the Ribbon.

Progress

sgosavi — 09/11/2011

There are several ODBC drivers to connect to a data source Progress: OpenLink, clinker, and MERANT ( free ). specificities of the different drivers:

The MERANT ODBC does not read the fields array.
With CLINK, uncheck the alias the fields in the properties of the connection. MyReport in Data, the list of drivers, you can use either ODBC or ODBC (ADO).

If you select ODBC, and you have Boolean fields in the destination field, the first Boolean field must imperatively be placed following a numeric field in the destination field.

If you select ODBC (ADO), you can have an error in an ETL if fields dates values were not filled.

ATTENTION PROGRESS DOES NOT SUPPORT ORDER BY so do not sort fields. When the tables must be prefixed in SQL queries (eg pub), you must prefix the tables.

To do this:
1.Configure your connection Progress, then retrieve the list of tables.
2.Right-click in the list of tables and click on all prefixed by and then ask pub. For the ODBC Driver Progress Open Edge 10.1A version 5.10.00.39:

In ODBC (ADO), the ETL stops with an error [DataDirect] [ODBC Progress OpenEdge Wire Protocol driver] Error in row.

Solution: put READ UNCOMMITED instead of REPEATABLEREAD in the properties of the ODBC driver.

[Paradox] What to do when I get The External table is not in the expected format ?

sgosavi — 09/11/2011

[/g]With a connection to Paradox with the pilot \\\"ODBC\\\", the addition of a mapping table can cause the message \\\"The External table is not in the expected format.\\\"
This message can occur when the BDE (Borland Database Engine) is not installed.
[g]Solution:
1. Download and install the BDE (Borland Database Engine)
2. Restart Data Report

What is a USB MyReport?

sgosavi — 09/11/2011

A USB MyReport allows the use of software MyReport without being activated.
This allows a partner to make settings in the client with the products even if the customer did not buy the products. This key must be activated every 6 months by the partner via myPortal.

How to set the connection when the database is located on a remote site?

sgosavi — 09/11/2011

You must replace the machine name (Host) with the IP address of the remote site.

How to configure a connection to a database server using a port other than the default?

sgosavi — 09/11/2011

The syntax depends on the database to which you want to connect. In the line \"HostName\" properties of the connection, enter:

1.For Firebird : [MyServer] / [port] (eg SERVEUR/13050 if the port used by Firebird is 13050).
2.For [hr/]MySQL : [MyServer]: [port] (eg SERVER: 3307 if the port used by MySQL is 3307)

What to do when the error message \"Access Denied\" appears when I test the connection to a database on Vista?

sgosavi — 09/11/2011

Check Run as administrator in the properties of the executable MyReport. Windows Vista, MyReport is run as a user (without admin rights) even if the user is an administrator.

Modeling Divalto

sgosavi — 09/11/2011

1.In a modeling Divalto, no joint can be made in the source models. It should be a model corresponds to a table and create models for data warehouse to link them.

2.In a model of a connection Divalto source, it is not possible to see the values of a field. Only the data visualization of the application works. The visualization of the values of a field can be made in the models of the connection data warehouse (see previous point)

How to create a database?

sgosavi — 09/11/2011

If you want to create a database called Database.mrd, simply copy / paste the database Database_Empty.mrd (located in the installation directory MyReport) and rename the copy Database.mrd.

How to define the processors must use Firebird 2.x?

sgosavi — 09/11/2011

In the case of a machine multi-CPUs , the default Firebird 2.x uses only the first.

This setting can be changed in the file firebird.conf located in the installation of FireBird.

Search this the text file CpuAffinityMask, then delete the # so that this line is no longer commented out. In the case of a dual-CPU machine, enter the following: CpuAffinityMask = 3. In the case of a four-CPU machine, enter the following: CpuAffinityMask = 15. Following this change, restart the Firebird server.

More explanations are available at the following URL: http://www.janus-software. com / fbmanual / manual.php? book = 8 & topic = admin

How to install Firebird on Windows Vista?

sgosavi — 09/11/2011

Installing Firebird can bugue Control Panel in Windows VISTA.
When installing Firebird, you must unchecked Install the application of the control panel?.
This problem is only with the installation as Firebird Super Server. Installing Firebird Classic Server as is not a problem. This option does not exist in version 1.5 of Firebird, it is necessary to install a version of Firebird 2.0 or higher

How to start with a blank base Firebird?

sgosavi — 09/11/2011

Following the corruption of a database Firebird, you must restart ETLS on a virgin. Procedure:

1.Copy the file Database_empty.mrd present in the installation directory of products MyReport

2.Paste this file into the same directory as the current data warehouse (called here Nombase.mrd)

3.Rename the old data warehouse as Nombase_old.mrd

4.Rename the file Database_empty.mrd to Nombase.mrd

5.Restart all the ETLS

6.You can delete the old data warehouse Nombase_old.mrd if you wish

When I test the connection, as does the message Error DBX: No correspondence error ?

sgosavi — 09/11/2011

The connection to the database is not good.
Check the path to the database. If the database is on a server called SRV and the database is located on this server at C: BDDDatabase.mrd. Until version 5.2.1.x in Database, you must specify the following path: SRV: C: BDDDatabase.mrd.

Warning! This is not a network path. Starting with version 5.5.0.x in HostName, you need to SRV and Database, the path C: BDDDatabase.mrd. Check Firebird installed on the computer that hosts the database.
Verify that the Firebird is running. If the connection does not work, try connecting to another database, such as the base blank Database_Empty.mrd.

Where to find documentation that helps to choose the type of server in Firebird?

sgosavi — 09/11/2011

http://www.sinatica.com/blog/en/index.php/articles/firebird-superserver-classicserver-or-superclassic

What to do when I receive the error message Internal gds software consistency check (can not continue After bugcheck) ,Unsuccessful metadata update or not Successful metadata for an ETL?

sgosavi — 09/11/2011

1.Delete the file Datawarehouse.mrd

2.Copy / paste the file and rename Database_Empty.mrd Datawarehouse.mrd
This removes the data warehouse and creates a new one.

3.Restart all ETLS to insert the data into the data warehouse.

Cause: The message is that the table in the data warehouse associated with the model is corrupt.

The error Unsuccessful metadata update can also come from a SQL name of a field too long. We must therefore ensure that the size of the names of SQL fields does not exceed 31 characters.

What to do when I receive the error message No current record for fetch operation?

sgosavi — 09/11/2011

This error message appears only with version 1.5 of Firebird.

The solution is to update the engine of the database, version 2.x. The old version must be uninstalled before installing the new version.

What do when the number of rows is inconsistent in data mining?

sgosavi — 09/11/2011

Check in the properties of the connection that the debug mode (use only for explicit error messages) is unchecked.

What to do when my load times are long?

sgosavi — 09/11/2011

1.Check if the PC which is running Firebird manages the multi-threaded

2.If so, installing Firebird Classic server (see the document Installing Firebird)

What if a field of 31 characters is truncated back ?

sgosavi — 09/11/2011

There are two solutions.

First solution:

In preferences MyReport Data, check the option Allow change the name and type of a field source.
Select the source field in the main interface, then right click> Change the field name.
Write the correct name of the field and confirm.

Second solution:

In the connection properties, check debug mode (use only for explicit error messages).
Right click on the table that owns the field, then Update fields.
Back in the Connection Properties and uncheck the option debug mode (use only for explicit error messages).

What does the message The printer is out of paper?

sgosavi — 09/11/2011

The message The printer is out of paper is returned by the database engine Firebird when disk space is insufficient.

What does the message The printer is out of paper?

sgosavi — 09/11/2011

The message The printer is out of paper is returned by the database engine Firebird when disk space is insufficient.

What does the error message invalid buffer clumplet structure ... ?

sgosavi — 09/11/2011

The number of characters from the path of the database (. Bn) is too long. It should not exceed 115 characters.

What is the port used by Firebird?

sgosavi — 09/11/2011

Exceptions tab

Name

Is there a size limit for my field names in Firebird?

sgosavi — 09/11/2011

Firebird limits the size of its columns to 31 characters.

How to manage the sizes of the fields Hyperfile with the ODBC connector (EasySoft)?

sgosavi — 09/11/2011

HyperFile

sgosavi — 09/11/2011

MyReport can connect to that from a version 7.0 of Hyperfile.
Hyperfile For ODBC connections, deselect the option Integrate reading errors in the log file if the source data may contain empty dates.

* A check : * With the ODBC driver Hyperfile v15, it seems that it does not release the process that generated a query on the database. If we start with an ETL DataRunWin Hyperfile on a model, the ETL process works but DatarunWin5.exe remains open. This problem has been reproduced with Data5.exe following a manual ETL and Excel with Microsoft Query.

What files are officially supported as a source of Excel template?

sgosavi — 09/11/2011

Only files with extensions. Xls,. Xlsx and. Xlsm are supported.
The. xlsb is not supported. Currently the Excel 2010 formats are not supported, the file does not contain specific features Excel 2010 such as segments or sparkline. I
f a file that was saved with Excel 2010 has no specific Excel 2010, it will be used as a source Excel template. We are soon to be compatible with Excel 2010.

How to force the use of InnoDB engine for the data warehouse?

sgosavi — 09/11/2011

In the connection properties of the data warehouse, SyntaxeSQL tab, in the Create Table Setting, set: ENGINE = InnoDB

How to use MySQL 4 as Datawarehouse?

sgosavi — 09/11/2011

To use MySQL as Datwarehouse 4, you must use an older version of the dll dbexpmda.dll.

Just replace the dll found in the installation directory MyReport products (eg C:\\Program Files\\defer\\MyReport5) by that found in this paper: Document MySQL 4 - Dll DbExpress .

Tips from a MySQL database configuration

sgosavi — 09/11/2011

The default port used by MySQL is 3306 TCP. It is advisable not to uncheck the option Aliassa fields, as this can cause application errors in computing fields calculated by the base data.

Why do I get an error 42000 when I connecting to MySQL

sgosavi — 09/11/2011

This error comes from a security as you use the MySQL root login to connect to a remote MySQL database. To correct this, please create a user defer with password defer. You assign the rights to work on the MySQL database to that user.

In the connection properties of the data, use this as a user login and password for connection. Also be sure to fill in the parameter HostName with the IP of the server.

What are the prerequisites for using MyVP?

sgosavi — 09/11/2011

Ecrans.exe must be in the directory specified by the file generated by the installation ventpart.ini Sales Partner. This file contains the path to the EXE file (line exe =)
Sales Partner programs (office, tools, screens, traitemnt, consumption) lock access to files needed MyVp. They should not be in use during the outbreak of MyVp.
MyVp generates the descriptionvp.xml\" in the installation directory MyReport, he must have read access and
write to the directory.

To test the recovery of your labels, you can use this command.
MyVP.exe Create a shortcut and place in the / FEN_TEST = YES This will open a window where you will see all the fields that have a description. If this is not the case, check your installation of VP, including the file VentPart.ini. Ex command line: C :/..../ MyVP.exe / FEN_TEST = YES

How to back up the list of tables EasySoft an ODBC connection?

sgosavi — 09/11/2011

Procedure for a new connection:

Create an ODBC connection (ADO).
Create a simple model. This step up the list of tables.
Change the driver for the ODBC connection (Easysoft).

Procedure for an existing connection:

Change the driver for the ODBC connection (ADO).
Put you on a model and update the list of tables.
Change the driver for the ODBC connection (Easysoft).

How to connect to a database without using ODBC data source system?

sgosavi — 09/11/2011

To avoid having to use a system data source, you must learn the parameters in Database database.
It is possible to use a data source file to recover these parameters.

Go to the ODBC Administrator, under Data Sources file.
Click Add.
Select the correct driver and
click Next.
Click Browse and select a directory and file, for example test the file on the desktop and click Save.
Click Next and then Finish.
Set the data source and validate.
Edit the file Test.dsn located on the desktop, delete [ODBC] and replace all line breaks with, and copy the text.
In MyReport Data in the properties of a connection, select ODBC Database in, paste the copied text file Test.dsn.
Learn User_Name and Password.
Test the connection.

What if the list of links ODBC is not displayed in the Connection Properties ?

sgosavi — 09/11/2011

You should run MyReport Data as an administrator, to do this:

right-click on the application and Run as administrator.
right-click on the application, properties, Compatibility tab: check Run this program as administrator.

How to connect to an Oracle database natively without using an alias or the TNSNAMES.ORA file?

sgosavi — 09/11/2011

To configure a native connection to Oracle without using an alias or the TNSNAMES.ORA file, find the key Database as follows: SERVERNAME: 1521/NOM_BASEDEDONNEES
Learn User_Name and Password in the conventional manner.

In which case should you install the Oracle client connection when using the Oracle (ODAC)?

sgosavi — 09/11/2011

It is not necessary to have the Oracle client installed on the computer in the following cases:

Data / DataRun: Log Source
Builder / Viewer

However, if Oracle is used as a data warehouse, it is necessary that the position which is installed MyReport Data and / or MyReport DataRun have the Oracle client installed.

Why I can not access Total joint option in the properties of my join?

sgosavi — 09/11/2011

Oracle does not accept total joints. You must be a consolidation of two models that match your request: - one with left join - a join with the right

Why connect to an Oracle database does not work when the connection is configured properly?

sgosavi — 09/11/2011

Connecting to an Oracle database does not work if the installation path of MyReport contains parentheses ().

This problem often happens on 64 bit positions, the installation path C:\\Program Files (x86)\\defer\\MyReport5\\ is not good, it is necessary in this case install the applications in C:\\Program Files\\defer\\MyReport5\\.

Why the size of the database data warehouse does not stop to grow?

sgosavi — 09/11/2011

From the 2nd edition version 10g, a basket is added.
When you delete a table, it is sent to the trash so they can be recovered.
In an ETL, so that the table is finally abolished on , change parameter DropTable connecting to the data warehouse.

Right click on the data warehouse, Properties.
SQL Syntax tab, put PURGE in Parameter Drop Table.
Confirm by clicking OK.

What to do when ETL has an error ORA-00972?

sgosavi — 09/11/2011

Oracle prohibited identifiers (names) of tables, fields, indexes more than 30 characters. This error indicates an identifier exceeds 30 characters. Especially if the name of the table is close to 30 characters (29 or 30), the names of the index based on it may exceed the threshold. If this error occurs during an ETL please rename the table name (or name fields are too large) to have at most 25 characters

What to do when a join is simple when it works, not when it is outside?

sgosavi — 09/11/2011

- Retrieve each table in a separate model, transforming the join field so that it is the same type in both tables
- Join these two models in a data warehouse model. Explanation: Under Oracle 9, it is impossible to make the joints between external fields of different types.

What if the connection does not work on Server 2008 64 bits?

sgosavi — 09/11/2011

The solution is to install the Oracle Client 32 bit. Link to all versions of Oracle customers: http://www.oracle.com/technology/software/tech/oci/instantclient/index.html link releases Oracle Client for Windows 32-bit http://www.oracle.com/technetwork/topics/winsoft-085727.html

What is the port used by Oracle?

sgosavi — 09/11/2011

The default port is 1521 or 1551 in TCP.

What are the compatibility issues?

sgosavi — 09/11/2011

Oracle 8i is incompatible with Windows Server 2003

What is the default port for PostgreSQL?

sgosavi — 09/11/2011

The default port for PostgreSQL is 5432.

Log Sage Line 500 Ultimate, why the connection does not work?

sgosavi — 09/11/2011

If you are in V10 to V12, you must migrate V4 or higher.

How to level the problem of the number of field in the table with ODBC F_BUDGET v16 Sage?

sgosavi — 09/11/2011

- Click Start-> Run

- Type regedit and click Run

- Open the node HKEY_LOCAL_MACHINE -> Software -> ODBC -> ODBC.INI If you are on a 64-bit server, open the node HKEY_LOCAL_MACHINE -> SOFTWARE -> Wow6432Node -> ODBC -> ODBC.INI

- Right-click the name of your data source.

- Add a new value chain: MaxColSupport

- Modify the value data MaxColSupport: 800

Log Sage Payroll 100, why the connection does not work?

sgosavi — 09/11/2011

ODBC drivers Sage Payroll owner only work if the pay is installed on the user.

[hr/]Solution:

Copy manually dll \"C: / Windows/System32/pms1lib.dll\" from a position on which the pay is installed.
Install the software

Why I get user or password incorrect when I test the connection when they are correct?

sgosavi — 09/11/2011

When creating a data source to a database owner Sage, Sage checks the login and password with all the files related to the database.
You must ensure that all applications related to the database have the same user with the same password.

For example, for connection to an account, check the file of payment.

ETLS Why do not work?

sgosavi — 09/11/2011

Sage ODBC drivers may refuse the joints and/or filters. We must create a model table, retrieve the data in the data warehouse and make the joins and filters in models of models. You do not check No Duplicates because the Sage ODBC drivers may refuse the SELECT DISTINCT.

Why is my connection Gescom Sage does not work when I correct ODBC driver?

sgosavi — 09/11/2011

With the Sage ODBC V14.02 should not be put in the path to the file - character.

How to retrieve a numeric field that is longer than 15 characters?

sgosavi — 09/11/2011

We must convert the text fields via a SQL formula. Example in SQL Server : CONVERT (char (20), [MyField]) tranformer [MyField] text of 20 characters.

Caution : Be sure to put the text fields type if Excel will convert it and you\'ll end up with a figure of 15 characters and \"0\" as a result.

How can the journal of the database?

sgosavi — 09/11/2011

Here is a query that reduces the log file to 100MB in seconds:

USE Datawarehouse;
BACKUP LOG WITH TRUNCATE_ONLY Datawarehouse,
DBCC SHRINKFILE (Datawarehouse_log, 100);

You can also permanently reduce the log size by following the steps (you must be a sysadmin):

- The management interface (SQL Server Management Studio) place the server
- down the menu Management
- create a new plan Mainteance
- plan the plan to reduce it to 200 MB the newspaper every day.

In all cases you should check the following:

- The management interface (SQL Server Management Studio) place the server
- down the menu Databases
- right-click on the basis Datawarehouse
- Options menu (top left corner)
- Recovery mode: s\' it is not simple , give the value

How to set up the NOD32 antivirus so that it allows connections to Firebird?

sgosavi — 08/11/2011

By default, NOD32 is blocking access to databases Firebird when installed as a conventional server. fb_inet_server must be added to the list of exclusions in IMON. IMON -> Setup -> Misc -> Exclusion. Then restart the machine or the Firebird service.

J-utlise F-Secure, why ETLS is very slow?

sgosavi — 08/11/2011

The module Web Reporting F-Secure uses FireBird, installed as a super server
default mode Super Server does not correctly handle positions with either multi-core processors or multiple processors.
This is reflected in MyReport by slow loading times during ETLS models Datawarehouse.

Solution : Disable the Windows serviceF-Secure Web Reporting

What if Avira Antivir is a malware in dbexpmda.dll?

sgosavi — 08/11/2011

The editor uses the dll dbexpmda.dll ASProtect as compressor library. If Avira Antivir is the malvar PCK / ASProtect you must perform the following operation:

1.Right click the Antivir icon.
2.Configure Antivir.
3.Go to General> Threat categories.
4. Unchecked Unsual runtime compression.

How do I connect to an Access database?

sgosavi — 08/11/2011

It is recommended to use the native driver Access and ODBC Driver (ADO).

Informix

sgosavi — 08/11/2011

It is recommended to uncheck the Open queries in a separate thread. In the connection properties in HostName, do not put the name of the machine that hosts the database, but the name of the Informix server configured in the setnet.

Modeling 4D

sgosavi — 08/11/2011

In a 4D model, it is best not to make any joint in the source models for a matter of time ETL. And a source model corresponds to a source table and data warehouse models are created in order to connect them with joints

KDP

sgosavi — 08/11/2011

Delimiters texts left and right.
delimiters dates left and right.
It is advisable to use the ODBC driver (Easysoft).
odbcstand If the driver takes too many resources, it is advisable to check the option Close the connection at the end of the insertion of data on all models of the connection.

For more information: http://www.codebase.com/support/kb/?article=C01102

Where can I find documentation on SQL functions?

sgosavi — 08/11/2011

Here are two links that give a partial list of functions according to the different SQL databases Server 2008: http://technet.microsoft.com/fr-fr/library/ms174077 (SQL.100). aspx

Firebird 2.5 10g http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/functions001.htm

Where can I find a comparison of different databases?

sgosavi — 08/11/2011

http://en.wikipedia.org/wiki/Comparison_of_relational_database_management_systems#feat_2

What are the limits of UniVerse ODBC to connect to an IBM Universe database?

sgosavi — 08/11/2011

It is recommended to follow these recommendations:
UniVerse ODBC does not accept more than one external left join in a query
It is therefore advisable to perform a first level of modeling does not contain more than one outer join left. The number of simple join query for the same is not limited.

The keyword DISTINCT and the Aliasing fields are not supported by UniVerse in all cases
When the number of resulting values of a SELECT DISTINCT query is too large, an error is raised by the base. This error is coded 20548 in the coding errors UniVerse. This error may make it unavailable visualization of field values. This error may make it impossible for ETL application when the user has selected the no duplicates. This error makes the response of the database field size wrong. It is possible to solve this problem by setting the parameter ALLOWMARKS to 1 in the server configuration Universe.

Why did I when I want an error condition on a field Interbase?

sgosavi — 08/11/2011

Interbase can not interpret a CASEWHEN on a digital indicator.

Example: CASE WHEN sum ([Unit]) = 0 THEN 0 ELSE sum ([CA]) / sum ([Unit]) END

What are the recommended delimiters for a database Universe?

sgosavi — 08/11/2011

It is recommended not to use any delimiter table and fields.

What are the requirements to connect to a database hosted on an AS400?

sgosavi — 08/11/2011

The client must be installed on iSeries positions where MyReport Data, Datarun Datarunwin or will be deployed.

Visual Fox Pro

sgosavi — 08/11/2011

Up to version 7:

Use the ODBC driver provided by Visual FoxPro.
For later versions: Depending on the mode of indexing tables, in some cases, the ODBC driver provides is no longer able to access some tables. It can be used instead of the driver provides the driver supplied by Sybase, initially developed to a dblink between Sybase and FoxPro. Also, two connections are created:

1.Using the ODBC driver provides.
With this connection, we get all the tables supported by the FoxPro ODBC driver.

2.Using the ODBC driver supplied by Sybase:

See at:
http://devzone.advantagedatabase.com/dz/content.aspx?Key=20&Release=13&Product=14&Platform=6
With this connection you are able to retrieve all Recent tables (above version 7). The connection must be set according to your database. In setting the ODBC connection, you must change the character set and adapt it to the database. In general, it will be: GENERAL_VFP_CI_AS_1252. Otherwise, it is necessary to refer to possible error codes by testing the selection of a table. If you are not using Sybase database, create the file in the ads.ini DATA5.exe directory. It contains the entry: [SETTINGS] MTIER_LOCAL_CONNECTIONS = 1 This file disables the control for the existence of a SYBASE client base. Be careful, use the ODBC driver SYBASE is free through the use of a database Sybase. The use of the ODBC driver SYBASE Sybase database without is under license. See the help file installed with the driver. For more information: http://devzone.advantagedatabase.com/dz/webhelp/Advantage9.0/server1/collation_support.htm

How to turn a USB MyReport?

sgosavi — 08/11/2011

1. If you format your key, download CleUSB.exe on myPortal and save the key in a directory defer \\ MyReport5

2. Double-click on the key CleUSB.exe located in the directory defer \\ MyReport5

3. Click on the link to activate the USB

4. MyPortal starts, log on if you are not connected
Enter the key extension that appears in the prompt myPortal Activation Key

5. Click on Validate the activation key

How does a USB MyReport, and how to use?

sgosavi — 08/11/2011

1. When a USB MyReport is connected to a computer, the products no longer need to be activated on this computer
2. The USB drive serves as a product activation key MyReport How to use - Connect the key USB on the computer on which products are installed MyReport 3. Launch the product MyReport Disconnect the USB end of the use of MyReport

How to use a USB key Citrix / TSE

sgosavi — 08/11/2011

To use the USB drive in citrix or TSE, we must share the drive usb to see it as a shared folder on the TSE or Citrix session. To do this, when connecting TSE, options and local resources and check the usb drive.

FAQ MyReport

How an array of overlapping slippery?

How to work on a live database (real time)?

Get the duration between two dates in the format year month day

What browsers are officially supported and promoted?

How to integrate MyReport SDK in a project. net on a 64-bit extension?

Object Reference is incorrect, why?

IIS maneger settings? or How to configure IIS so that MyReport Center is working properly?

What if we have the message Incorrect file version when connecting to the server 100 of payroll in 2008?

What are the user group?

What to do when the toolbar Builder does not work in Excel 2007 or 2010?

What is password for webadmin user on center page?

What client should be used on posts to connect to databases natively?

What if I have the error message Access violation\\ when I create a new Excel template?

Why ETL blocks when deleting the table?

What to do when I get The connection was completed properly?

How to integrate a toolbar in Excel?

What to do when was the message Can not open file C: ....> Utilisateur.inf. Access Denied?

How to display the ribbon Developer?

What if the conditional formatting is displayed in black or shift?

I hide columns in Excel but they are redisplayed when updating the report, what to do?

The update in Excel is slow, why?

Can you run a report in a protected sheet?

How to integrate a toolbar in OpenOffice.org?

What to do when I receive an error message when closing the session?

What to do when saving a workbook with drop-down list in xls file corrupted?

What if MyReport Builder does not create more comments?

on a TSE server, what if the toolbar does not work?

on a TSE server, what if the communication between OpenOffice.org and MyReport Builder does not work?

I want to insert in Power Point report and update from PowerPoint

How to display in a cell, the list of values ​​of an area?

Set and How to combine Totals computed from the formula?

How a weighted average?

What if floating licenses are activated but the product remains in evaluation period?

Where can I host the file MySystem?

Can you host the file on a linux server MySystem?

Can I install the game MyReport Server in a network directory?

Why can not I start the service MyReport Server 5?

What to do when I get Server 5 MyReport launched the session NetworkService has no rights Access Demonstration Project ?

How can we trust to the VBA project?

Where is the manager names?

What to do when the message Microsoft Excel has stopped working appears systematically closing Excel?

What to do when the tape is no longer displayed MyReport Builder?

What to do when you have the error message: Unable to set the Weight property of the class Border?

What if the update is launched several times in a row?

What if we have the message A file named Builder5.xlsm already exists in this location. Do you want to replace it? opening Excel?

Where can I download SQL Server Express?

What if I have a field of type DateTime2 that does not return data?

What is the port used by default?

What are the limitations of SQL Server Express?

How to convert a field of type TIMESTAMP dated?

How to refer to another record?

What if my job with planfi�e datarunwin does not work or does not set the right project in the datarun?

I use Windows Vista Home Edition and the opening of a query is extremely slow, what to do?

What to do when opening MyReport Datarun is very long?

What to do when MyReport Datarunwin starts from the explorer but not from the scheduled tasks?

What planif�e check if a task has no run-time error in closed session but MyReport DataRunWin did not run?

What to do when ETLS launched by MyReport Datarunwin run from the explorer but not from the scheduled tasks?

What to do to load the data warehouse only on order?

What if MyReport Datarun is no longer active as I have already activated 5.5.0.0 or 5.5.0.1?

What if the scheduled task DatarunWin5 not start.

How to disable the zoom to a viewer?

How to start broadcasting in Windows scheduled task?

What if the workbook has come in cells # NAME?

What are the SMTP settings to use an inbox hosted by Google?

What does the message Unable to open xlsx file format or as its extension is not valid. [.. .] when opening a file generated by MyReport Messenger?

Why send an FTP server crashes?

I can not use the PDF export, what can I do?

MyReport Messenger generates Why does the file extension. pdf.pdf?

What to do when the distribution blocks when exporting to PDF ?

What if the PDF export only prints the first page?

** USED ** The distribution does not work through a scheduled task, what to do?

I have Bit Defender 2009 macros and toolbars can not run

Kaspersky and I MyReport Builder does not launch when I click the button on the toolbar

I can not put an aggregate sum over a field, why?

What to do when I receive an error message when I add a filter in my report?

What to do when the message size too big comment ?

What if I lost my models after changing my password from the toolbar MyReport Builder?

What if the application crashes during the creation of interfaces?

How to change the default chart type?

How to display in a cell, the list of values of an area?

USED The distribution does not work through a scheduled task, what to do?