The module "Web Reporting" F-Secure uses FireBird, installed as a "super server". By default, a "Super Server" does not correctly handle positions with either multi-core processors or multiple processors. This results in MyReport by slow loading times during the models ETLS Datawarehouse. Solution: Disable the Windows service "F-Secure Web Reporting"

The launch of MyReport Builder from Microsoft Excel can be prevented by blocking macros by Kaspersky. To unlock, right click on the icon "Mail Kasperski> Tab Settings> Display settings> security settings," then select "low".

Macros toolbars can be blocked by Bit Defender. Bit Defender in 2009, select the "Advanced". In the tab "Antivirus"> "Exclusion", added the file. Xla corresponding to the toolbar, then apply.

By default, NOD32 is blocking access to databases when Firebird is installed as Server Classic. It should be added fb_inet_server the list of exclusions in IMON. IMON -> Setup -> Misc -> Exclusions. Then restart the machine or service Firebird.

Select the ODBC (ADO). -> The ODBC driver can handle accented characters. The tab "SQL Syntax" must be set as follows: -> Text Delimiter left ' -> Right Delimiter text ' -> Delimiter Date left: ' -> Right Delimiter Date ' -> Date separator: - -> Date format: DMY or -> Text Delimiter left ' -> Right Delimiter text ' -> Left delimiter Date: (d ' -> Date Delimiter right: ') -> Date separator: - -> Date format: YMD.

In a 4D model, it is best not to join any source models in a matter of time ETL. As a source model corresponds to a source table and data warehouse models are created to be able to connect with their joints.

It is recommended to use the ODBC (ADO).

The delimiters texts left and right '. Delimiters dates left and right '. It is advisable to use the ODBC driver (EasySoft). If the driver odbcstand takes too many resources, it is advisable to check the option "Close the connection at the end of the insertion data" on all models of the connection. For information: http://www.codebase.com/support/kb/?article=C01102.

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

Date Left Delimiter: (d ' Date Delimiter Right: ') Date separator: - Date Format: YMD Left Field delimiter: Right Field delimiter:

InterBase can not read a CASEWHEN on a digital indicator. Example: CASE WHEN Sum ([Unit]) = 0 THEN 0 ELSE sum ([CA]) / Sum ([Unit]) END.

There are various ODBC drivers to connect to a data source PROGRESS OpenLink, CLINK, and MERANT (free). Specificities of different drivers: -> The MERANT ODBC can not read array of fields. -> With CLINK, uncheck the option "Alias fields" in the properties of the connection. In MyReport Data in 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 always be placed after a numeric field in the destination fields. If you select ODBC (ADO), you can have an error message during an ETL if the date fields have values not filled. When the tables must be prefixed in SQL queries (eg "pub."), You will need to prefix the tables. To do this: -> Configure your login Progress, then retrieve the list of tables -> Put yourself in the list of tables, then ask "Any prefix with" pub. ".

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

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

Restart the service "Server5.exe".

On the client, verify that Host is the server name or IP is the IP of the server. Check this information by opening a command prompt and type "ping ServerName" or "ping IP" (where IP is the IP of the server). On the server side, verify that the service MyReport Server is installed. Verify that the service MyReport Server is launched (either by the list of services or by the administrative console). Verify that the port 9098 for MyReport Builder or port 9097 for MyReport Viewer are available Creating an exception in Windows Firewall: Control Panel> Windows Firewall. Check "Do not allow exceptions" is unchecked. In the Exceptions tab, click on "Add Program ...", select the program MyReport Server 5 or click" Browse ... " and return to the installation folder MyReport Server 5.

The syntax required depends on the database to which you want to connect. In the line "HostName" properties of the connection, enter: * For Firebird: [MyServer] / [Port] (eg SERVEUR/13050 if the port used by Firebird is 13,050). * For MySQL: [MyServer]: [port] (eg SERVER: 3307 if the port used by MySQL is 3307).

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

If Microsoft Excel Viewer 97 is installed on the machine, please uninstall it and restart the job. Check if an Excel process is not invisible.

When the password is changed from the menu MyReport Builder, the user has access to more models. This problem is encountered with version 5.7.0 to version 5.7.1.1. To submit directory and the models available, you must go to models management shown in MyReport Data, then delete and recreate the parameters.

Check the SQL delimiters in the connection properties of the model - It is often necessary to change the delimiter "in" or vice versa.

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

Delete images in the source workbook. Remove the automatic filters in the source workbook. Remove the filter list (objects of type "combo box").

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 the license from the user's account - Activate the license on the Windows account that runs the scheduled tasks.

If the main interface MyReport Datarun opens, click on "Connections", then "View models", select "List". If the main interface MyReport Datarun takes too long to open in Windows Explorer, the directory MySystem project that is the problem, open the file Datarun.ini, then change the line ModeAffichageModele = ModeArborescence by ModeAffichageModele = Model.

To start the execution of scheduled task in Windows releases, call: (MyReport versions prior to 5.5): the executable "Messenger5.exe" with parameter "/ run". (From MyReport 5.5): the executable "MessengerRunWin5.exe".

What are the SMTP settings to use a mail box hosted by Google? The parameters are as follows: * SMTP server: smtp.gmail.com * Port: 587 * User: full address (incorporating the '@ domaine.com-name' example '@ gmail.com') * Password: password * Tick the box to use authentication * Sender address: complete address (incorporating the '@ domaine.com-name' example '@ gmail.com') RESTRICTION: Avast anti-virus software MUST be installed on the computer (with optional scan outgoing mail enabled). This setting is compatible with MyReport Messenger5 this anti-virus. .

Develop a frequency of update to "Daily" on models to update manually - Do not throw MyReport Datarun - Start MyReport DatarunWin whenever you want to load the data warehouse, and do not plan in the Windows Task Scheduler.

To optimize queries, it is recommended: Make the joints on identifiers and not labels. Index the fields used in joins. Index the fields used in filters. Avoid outer joins when they are not needed.

1 - Open WordPad 2 - Enter your text 3 - File -> Save As -> Format MS-DOS.

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

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

Sometimes the macro associated with a drop comes into conflict with the My Documents folder synchronization, which results in displaying an error message on the screen. To avoid this behavior, simply disable the macro associated with the drop down as follows: * Go into the options of deferral, "General" tab. * Uncheck the option "Create the macro associated filter list" and click OK * Run the postponement so that it takes into account the change.

This message occurs when the automatic recording of information retrieval starts Excel and creates a conflict with the products MyReport. The solution is to disable this automatic recording. * Open Excel. * Go to Tools> Options> Save tab. * Uncheck "Save AutoRecover info every". * Click OK. When this happens, you may receive an error message displayed by MyReport Builder indicating a problem when assigning borders, formatting cells, or the police format.

To update the toolbar Builder5 (or Viewer5) in Excel: - Right click on "Builder5" in the main menu - Click on "Customize ..." - In the "Toolbars", select "Builder 5" - Click on "Delete" - Confirm deletion - Keep the window open Customization - Again, right click on "Builder 5" in the main menu - Click on "Delete" - Close the customization window - Close and restart Excel Excel.

This reflects the fact that you do not have the fonts used by the product MyReportBuilder. To correct this, please download this zip file. Then add these fonts in the control panel in the Fonts folder.

When the field was calculated as a mask display text, Excel does not the formula but displays as text. It is in this case as a mask to Standard display the formula so that Excel interprets and displays the result.

This error is because of using a spreadsheet cell that is outside. To resolve this problem, just insert a column before the table.

If you are in Excel 2007 - Show Developer tab (Windows Button -> Excel Options -> Basic 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 Visual Basic Editor In the Visual Basic Editor - In the left tree, all leaves are starting with mr_ leaves backup - Select the sheet to remove - In the property grid, change the Visible property of 2 - xlSheetVeryHidden in 0 - xlSheetVisible - Go back to Excel and delete the sheet that was displayed.

To learn more values, they must be separated by a ; - To fill a range of values, we must separate the two terminals by .. Example: FRANCE, GERMANY 64 .. 6499999, 66500000

There is 4 ways to incorporate a toolbar in Excel: 1. Add Builder5.xla file in the folder C: \ Program Files \ Microsoft Office \ Office11 \ Xlstart \ 2. Add Builder5.xla file in the folder C: \ Documents and Settings \ UserName \ Application Data \ Microsoft \ Excel \ XLSTART \ 3. In Excel> Tools> Add-Ins> Browse ... > Select the file and validate Builder5.xla 4. Double click on the file Builder5.xla When integrating a toolbar in Excel using several methods, there may be a conflict of macros. In this case, it must cancel by integration method and make an update to the toolbar in Excel.

To change the default chart type: 1. Create a chart. 2. Select the chart. 3. Right click> Chart Type ... 4. In the "Standard Types", select the new default type. 5. Click on the button "Default". 6. Click OK.

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.

Update to version 5.7.1.1 MyReport products or higher. For versions 5.7.1.1 MyReport below: In the Format Report: Do not put borders to the labels of rows and columns. In the properties of an indicator and / or a dimension: remove custom borders. Note: these are set automatically when it makes "active" format.

Click the Windows Excel - Go into the options of Excel - Go to the tab Supplements - Select "Disabled Items" from the dropdown menu Manage the bottom of the window - Click Go - If the file Builder5.xlam appears, select it and click Enable.

Close Excel. Delete the file located in Documents Builder5.xlsm. Move the file Builder5.xlam the C: \ Program Files \ Microsoft Office \ Office12 \ Xlstart \ to the desktop. Double-click the file Builder5.xlam. Click on "Enable Macros". Close Excel. Move the file Builder5.xlam the desktop to the folder C: \ Program Files \ Microsoft Office \ Office12 \ Xlstart \.

1. Right-click on the menu Builder 5, delete the custom command 2. Right-click on the toolbar Builder 5, delete the custom toolbar 3. Click the Office 4. Click on Excel Options 5. Select Supplements 6. In the Manage menu, select Disabled Items, click Go To 7. Enable MyReport Builder 5 8. Close Excel and reopen.

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

In the tape "Developer", code, click on "Macro Security". Check "Enable all macros". Check "Trust access to the object model of the VBA project."

In the options of Excel 2007> Standard tab, check "Show Developer tab in the Ribbon".

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

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 is included in the format of the cell). It is therefore not possible to run an extension with fusion or with a format. In addition, to run (or update) in a protected sheet, you must authorize: * Editing of objects, so we can insert the comment. * The column format, so we can resize the columns.

If the display is less than 100%, you must mount to 100%.

If you want to hide columns in a report, it should consider unchecking the option "Resize columns. This option is located in: Tools> Options report> General Tab.

Firebird uses port 3050 TCP. Sometimes you have to add an exception in Windows Firewall so that it does not block this port: Control Panel> Firewall. "Exceptions" tab, "Add Port ...". In "Name", put Firebird. In the Port Number ", type 3050. Select TCP Confirm.

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

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

There are two solutions. First solution: In the preferences of 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 name of the field. Write the correct name of the field and confirm. Second solution: In the connection properties, check "debug mode (only use for explicit error messages). Make right-click the table that owns the field, then "Update Fields". Return the connection properties and uncheck the option "debug mode (only use for explicit error messages).

Check if the PC which is running Firebird manages the multi-threaded - If yes, install Firebird Classic Server (See the document Installing Firebird).

Go to the properties of the data connection / Builder, and then check "debug mode".

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

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.

Delete the file Datawarehouse.mrd - Copy / paste the file and rename Database_Empty.mrd Datawarehouse.mrd This removes the data warehouse and creating a new one. - Restart all ETLS to insert the data into the data warehouse. Cause: The message is that the table in the data warehouse for the template is corrupt.

When you use version 2.0.3 of Firebird, if you run an ETL on a model after asking to see the data in the query, ETL hangs when removing from the table. Proposed Solution: Update Firebird installing version 2.0.5 or higher. Keywords: Firebird, ETL, blocking, data visualization, query data, delete, table.

The connection to the database is not good. Check the path to the database. If the database is on a server named SRV and the database is located on the server at C: BDDDatabase.mrd. Up to version 5.2.1.x in Database, you must specify the following path: SRV: C: BDDDatabase.mrd. Warning! It 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. Verify that Firebird is installed on the computer that hosts the database. Check the Firebird service is launched. If the connection does not work, try connecting to another database, such as the empty base Database_Empty.mrd.

The installation of Firebird can bugue the Control Panel in Windows Vista. During the installation of Firebird, you have to uncheck "Install the application of the control panel?". This problem exists with the installation of Firebird as Super Server. The installation of Firebird Classic Server as poses no problem. This option does not exist in version 1.5 of Firebird, it must therefore install a version 2.0 or higher Firebird.

In the case of a machine with multiple CPUs, the default Firebird 2.x uses only the first. This setting can be changed in the file "firebird.conf" located in the installation directory of Firebird. Search in this text file "CpuAffinityMask", then delete the "#" so that this line is no longer comment. In the case of a dual-CPU machine, enter the following: "CpuAffinityMask = 3". In the case of a quad-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=admin&topic=8"

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

The consignment may be blocked by the firewall. With the old version of MyReport Messenger, you must configure it to allow incoming connections to MyReport Messenger.

1. MyReport Data / MyReport Datarun. Minimum Processor: Intel CoreDuo or equivalent RAM: 1 GB Operating System: Microsoft Windows XP SP2 * Recommended Processor: Intel Core 2 Duo or equivalent RAM: 2 GB Operating System: Microsoft Server 20003 2. MyReport Builder / Viewer MyReport / MyReport Messenger * Minimum Processor: Intel Pentium 4 Prescott 3Ghz or equivalent RAM: 512 MB Operating System: Microsoft Windows XP SP2 Spreadsheets: Micorsoft Excel 2000 or OpenOffice.org Calc 2.0 * Recommended Processor: Intel CoreDuo or equivalent RAM: 1 GB Operating System: Microsoft Windows XP SP2 Spreadsheets: Micorsoft Excel 2003 or OpenOffice.org Calc 3.2 These settings are purely indicative and should be tailored to the needs of customers. For installation soWindows Server 2008, please refer to the FAQ: The release does not work via a scheduled task, what to do? An application launched by a scheduled task on a Windows Server 2008 can not use Excel without open session. An error message "OLE 800A03EC" will appear in the error log. The solution is to keep a session open on the server and locked by password. Articles providing information on the subject: http://support.microsoft.com/kb/257757

Launching the Viewer MyReport Builder or TCP / IP, it is possible that the service has no rights access the folder MySystem. * On the server where MyReport Server installed in Windows Explorer, select the MySystem folder, then right click "Properties". * Select the Security tab, then click "Add ... . * In the "Select Users or Group", click "Advanced", then click "Search". * Select NETWORK SERVICE or does not exist, select SERVICE and click "OK". * Confirm again by clicking on "OK". * Select NETWORK SERVICE and check "Allow Full Control. * Confirm by clicking "OK". For more details on the procedure, you can refer to the installation process, "Managing rights to files MySystem.

Launching the Viewer MyReport Builder or TCP / IP, it is possible that the service has no rights access the folder MySystem. * On the server where MyReport Server installed in Windows Explorer, select the MySystem folder, then right click "Properties". * Select the Security tab, then click "Add ... . * In the "Select Users or Group", click "Advanced", then click "Search". * Select NETWORK SERVICE or does not exist, select SERVICE and click "OK". * Confirm again by clicking on "OK". * Select NETWORK SERVICE and check "Allow Full Control. * Confirm by clicking "OK". For more details on the procedure, you can refer to the installation process, "Managing rights to files MySystem.

Upon installation of Firebird, a file named Firebird2Control.cpl moved into C: / Windows/System32/directory and sets the control panel. By removing the control panel works again.

The error message is: "Unable to start service MyReport Server 5 on Local Computer. Error 5: Access denied. " In the data explorer, right click on the application Server5.exe, then Properties. In the Security tab, click on "Add ...". Click on "Object Types ...", does that leave checked" Integrated Security Features ", then press OK. Click "Advanced ...", then click" Search ". Select "NETWORK SERVICE", then press OK. Close the window "Select Users or Groups" by clicking OK. Add entitled "Full Control" to "NETWORK SERVICE", then confirm.

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

By default, the directory is in MySystem executable directory. By default, the executable directory is C: Program FilesReportOneMyReport5 In the directory MySystem, are: * Model containing the directory itself: - A folder containing the connection models. Mdl and setup the connection. Inf - A directory containing the configuration data warehouse connection datawarehouse.inf and directories models models. * Correspondence folder containing correspondence tables. Horn * The directory containing the upcoming release (MyReport Messenger). Dff * The file containing logs of Log.txt ETLS. * LogErreur.txt file containing logs of errors ETLS. * The file containing the configuration of Datarun.ini Datarun. * The file containing GestionModele.inf management models. * Utilisateur.inf file containing the user management.

It is not possible to host the file MySystem on a Linux server using Samba to share files with Windows machines. It is not possible to host the file on a MySystem NAS (Network Attached Storage). The record MySystem be hosted on a Windows machine and preferably one that hosts the service Server5.

SmartCase Logon + software blocks the display of the login window. We must close the software before launching an application MyReport.

Note: - MyReport products do not work on Mac OS10. - Need an INTEL and not MOTOROLA processor on the Mac. There are two ways to use products MyReport: - Install "boot camp" (which allows you to install two operating systems) and select the system boot Windows to install Microsoft Office Excel and products MyReport. - Through a virtual machine (Parallels or VMWare) that you install in Mac OS10. Then, install Windows on the virtual machine and then Excel MyReport products.

In Windows Explorer, find the file C: \ Windows \ inf \ Mdac.inf *** The inf folder is a hidden folder => in the folder options, check "Show hidden files". Right click the file, then "Install". If you have messages that indicate that some files are not found, insert the Windows installation CD or locate the file on the disk, then enter the path in "Browse". Alternatively, download the components from the Microsoft site by following this link: http://www.microsoft.com/downloads/details.aspx?displaylang=fr&FamilyID=6c050fe3-c795-4b7d-b037-185d0506396c.

The prefixes kilo, mega, "giga" represents a multiple of 1000. Out for bytes is a misnomer to use: they are multiples of 2 power 10 = 1024. The unit of measure of file size "Mio" rectify this abuse and actually represents a multiple of 2 power 10.

In a query containing an aggregate on a date field, version 4.1.7 MySql back untyped value. You should check which version of MySql and update to version 5.1 or higher. If the update MySql is not possible because of the work environment, it is possible to go through an intermediate model. Create a model with loading up the table data corresponding to the calculation and aggregation of the date from the data entered in the Data Warehouse.

This error comes from a security because you use the MySQL root login to connect remotely to a MySQL database. To correct this, please create a user "defer" with password "defer". You assign the rights to work on the MySQL database for this user. In the properties of the data connections, use this as a user login and password for connection. Also be sure to fill the parameter "HostName" by the server IP.

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

You must run MyReport Data as an administrator, to do this: * Either, right-click on the application and "Run as administrator". * Either, right-click on the application, properties, compatibility tab: check "Run this program as administrator".

To avoid having to use a system DSN, you must fill in Database settings in the database. It is possible to use a data source file to recover these parameters. 1. Go to the ODBC Administrator, under "Sources of Data file". 2. Click "Add". 3. Select the correct driver and then click "Next". 4. Click "Browse" and choose a directory and a file, for example test file on the desktop and click "Save." 5. Click "Next" and then "Finish". 6. Set the data source, then confirm. 7. Edit the file Test.dsn located on the desktop, delete [ODBC] and replace all line breaks by and then copy the text. 8. In MyReport Data, in the properties of a connection, select ODBC Database in, paste the copied text file Test.dsn. 9. Learn User_Name and Password. 10. Test the connection.

Procedure for a new connection: 1. Create an ODBC connection (ADO). 2. Create a simple model. This step up the list of tables. 3. Change the driver for the ODBC connection (EasySoft). Steps to an existing connection: 1. Change the driver for the ODBC connection (ADO). 2. Put you on a model and update the list of tables. 3. Change the driver for the ODBC connection (EasySoft).

If the user is logged on the TSE server with a session that does not have administrator rights: * Open the folder C: \ Windows \ system32 \ * Right click on the file ole32.dll, then Properties. * In the Security tab, select the TSE session user or group of users that contains the TSE session. * Add rights Editing and Writing, then confirm by clicking OK. Tags: OpenOffice.org open office calc right ole

The TSE session must be in the group "Power Users".

This problem arises from the version 3.1 of OpenOffice. Org. The solution is to update the product version 5.6.0.4 MyReport or higher.

How to add a toolbar: 1. Open OpenOffice.org Calc 2. Open Tools> "Extension Manager ..." 3. Click on "Add ..." 4. Select the file Builder5.zip located in the installation directory MyReport. 5. Starting with version 3.0 of OOo, answer the question "Who would you install this extension?" 6. Reviving Calc. How to delete a toolbar: 1. Open OpenOffice.org Calc 2. Open Tools> "Extension Manager ..." 3. Select the extension to delete, then click on "Delete" 4. Reviving Calc.

Oracle 8i is not compatible with Windows Server 2003.

The port default is TCP 1551.

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.

Retrieve each table in a separate model, transforming the field to join 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 do outer joins between fields of different types.

From 10g release 2 edition, a basket is added. When deleting a table, it is sent to the trash to be recovered. In an ELT so that the table is finally abolished on, you must change the parameter DropTable connection Datawarehouse. * Right click on the Data Warehouse, Properties. * In SQL Syntax tab, set "PURGE" in "Drop Parameter Table". * Confirm by clicking OK. In this way, the table will be removed permanently without being sent to the trash.

Connecting to an Oracle database does not work if the installation path of MyReport contains parentheses (). This problem often posts on 64-bit installation path C: \ Program Files (x86) \ defer \ MyReport5 \ is not good, it must in this case install applications in C: \ Program Files \ defer \ MyReport5 \. To learn more about the subject: http://forums.oracle.com/forums/thread.jspa?messageID=1943221 & http://www.oracle.com/technology/tech/dotnet/col/odt_faq.html # ORA-12154: _TNS: could_not_resolve_the.

You must be a consolidation of two models that match your request: - With a left join - One with the right join.

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

The solution is to put the same quality print all worksheets in the workbook. How to change the quality of impressions of a leaf: 1. Open the worksheet. 2. Click the Office button, then Print, then Print Preview. 3. Version 2007 and higher, in print preview, click on "Layout". 4. Version 2003 and lower in the print preview, click on "Page ...". 5. In the combo box "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 site giving more details: http://support.microsoft.com/kb/168563/fr

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

Please check the version of PDF Creator: * Version 5.2.1 and 5.5.0 of MyReport Messenger, PDF Creator must be version 0.9.3. * Version 5.6.0 of MyReport Messenger, PDF Creator must be version 0.9.6. If the version of PDF Creator is not correct, please uninstall it and install the correct version. PDF Creator 0.9.3 Setup : http://www.myportal.fr/doc_edit.php?modifier_doc=424 PDF Creator 0.9.6 Setup : http://www.myportal.fr/doc_edit.php?modifier_doc=445

1. In the options of the login window, verify that TCP / IP "is checked for products MyReport Builder and Viewer or" floating license "is checked for the product MyReport Data. 2. Launch the administrative console, then stop and restart the service Server5. 3. In the list of Windows services, if the service account is marked as "Local System" account and not as "Network Service", uninstall then reinstall the service.

The problem is that the new version is not installed in the same directory or even drive than the previous version. The solution is to uninstall the product and then re-install in the same installation directory that is used during product activation.

This error message occurs when the "DEP data" Windows is activated. To get to an activation / deactivation system, just add an exception. Procedure to follow with a post XP: * Right click on My Computer> Properties. * "Advanced" in "Performance" click "Settings". * Tab DEP data. * Click on "Add ...", select the application, eg "C: \ Program Files \ defer \ MyReport5 \ Data5.exe" and confirm. * Verify that the application is checked. * Close the Window "Performance Options". Procedure to follow with a VISTA position: * Right click on Computer> Properties. * Tab "Advanced system settings" in "Performance" click "Settings". * Tab DEP data. * Click on "Add ... ", Select the application, eg" C: \ Program Files \ defer \ MyReport5 \ Data5.exe "and confirm. * Verify that the application is checked. * Close the Window "Performance Options".

The port used by default by SQL Server is TCP 1433.

The function returns WeekOf week of the year with a value between 1 and 53. WeekOf uses ISO 8601 to define the week of the year: a week is from Monday to Sunday and the first calendar week of the year is one that includes the first Thursday of the year (the first week of the year that includes at least four days). Therefore, if the first calendar day of the year is Friday, Saturday or Sunday, WeekOf returns the last week of the year prior to the first, the first two or three days of the calendar year. Similarly, if the last calendar day of the year is Monday, Tuesday or Wednesday, WeekOf returns 1 (the first week of the next calendar year) for the last, the last two or three days of the calendar year . To learn more about ISO weeks For example, if you want the first day of the year at week 1, you can replace the formula WeekOf ([Date]) by If (And (MonthOf ([Date]) = 1; WeekOf ([Date] )> = 52), 1; WeekOf ([Date])).

StringReplace ( StringReplace ( StringReplace ( StringReplace ( StringReplace ( StringReplace (TEXT; RepeatRight ("";" ", 32);") ; RepeatRight ("";" ", 16);") ; RepeatRight ("";" "8);") ; RepeatRight ("";" "4);") ; RepeatRight ("";" ", 2);") ; RepeatRight ("";" ", 2);")

There are 2 solutions: SOLUTION N°1 http://myportal.fr/docs/video/faq/colonne_ligne.swf Problematic How to turn a record with data in columns in many rows? Constraints The solution proposed here can be applied if and only if the number of columns into rows and their labels are fixed. Solution Three models will be needed to address this problem. Model 1: Purpose: Replace the columns into rows. Content: This model must contain at least N columns into rows. Operations: Create a model with N destination fields as columns, and other elements of the source table to be used for reporting. Model 2: Objective: Create a table containing many rows as columns into rows. Content: This model must include only one field having as value the number of the line. Operations: * Create an Excel file containing at least as many rows as columns to transform. Excel * Create a model containing a single field (the number of the line). * Add a filter in Excel template on the destination field will go to the first N lines, N being the number of columns into rows. Model 3: Objective: To transform the N columns of N rows. Content: This model is the final step of this modeling technique. The N columns will be transformed into N lines, the data initially stored in a column being a single field. Operations: * Create a simple data warehouse model, and walk in the mapping models 1 and 2 created previously. No joins must be created to perform a Cartesian product: the number of rows of Model 1 is multiplied by N lines of Model 2, to obtain the desired number of rows. * Add fields to destination fields of model 1, except those corresponding to the N columns. * Create the field that will contain the converted values of the column. Each model line has been a duplicated N times, we recover the first duplicate the first column, the second the second column, etc.. To do this, create the field turned following: If ([(Model 2). (No. lig)] = 1 [(Model 1). (Column 1)] If ([(Model 2). (No. lig )] = 2 [(Model 1). (Column 2 )];(...))) SOLUTION N°2 http://myportal.fr/docs/video/faq/ligne_colonne.swf A possible solution to complete the transaction ONEPIVOT is as follows: You must first identify the fields that used to create the transaction ONEPIVOT: * The key grouping (fields in line) * field(s) used at the pivot fields (columns) * The value to insert in the columns. To illustrate the methodology, we will start the next case. A table contains sales data by year, month, commercial article and the Turnover. The goal is to create a monthly column. * Key group: Year, Article, Commercial * Field of Pivot Month * Value: Turnover You will then have to create two models. 1st model Objective: To create the different columns Handling: create as many fields as calculated columns to create, affecting the value column via a proper test. 2nd model Objective: aggregate lines Handling: Create a line for each key together.

Problematic How do to create a table containing floating cummulative. Ex: In a table containing the turnover indicator and month online: * Line "January 2007" must contain the turnover February 2006 to January 2007 * Line "February 2007" must contain the turnover March 2006 to February 2007 * Line "March 2007" must contain the turnover from April 2006 to March 2007 Constraints The solution described below can be applied in the case of a modeling star, because the final model (the one used by MyReport Builder) must be "unloaded". Solution Model 1: Objective: Prepare "axis time" used in combination. Content: This model must be traceable to a line every couple years, months, and also include the year / start month accumulation. Ex: In the above example, it takes a cumulative rolling 12 months, so the entry for January 2007 will also be a reference to February 2006. Operations: * Create a model DW calling "A Lap Accumulation", using as source model provided by the time axis Report One. * Select the field "Year", "YearMonth", then create a field turned "YearMonth-11" (StrToCurr ([YearMonth])-If ([Month] <= 11, 99, 11)). * Rename fields in "Year Accumulation", "YearMonth Accumulation" and "Accumulation YearMonth-11. * To go back no further than a line by Year / Month, check the "no duplicates". Model 2: Objective: To provide users Builder in the final model fields to accumulate. Content: The time axis combination must be added to the final model. Operations: * Add the model "A Accumulation Lap" to the final model, without linking it to other fields. * Add fields to destination fields of the model "A Accumulation Tps. Creating the dashboard: Objective: Display for monthly online sales accumulated over the 12 months. Content: The operation carried out in MyReport Builder will allow you to duplicate rows of turnover as many times as necessary to accumulate. Ex: In the case of a combined 12-month rolling a line of turnover dated of 05/01/2007 will be used (ie duplicate) for the cumulative turnover from January to December 2007, but not for cumulative sales from January 2008. Operations: * Add the field "YearMonth Accumulation" line and the turnover indicator. * Create the filter cover: "YearMonth Invoice" between "YearMonth-11 Accumulation" and "Accumulation YearMonth.

A field (digital) TIMESTAMP stores the number of seconds since 01/01/1970. To create from the Timestamp field of type date in MyReport Data, using the formula: trunc ([Timestamp] / 86400) 25569. Explanation: -> Timestamp/86400: number of days since 01/01/1970. -> 25569: numeric value of the date 01.01.1970.

An operation performed by a database returns null if an element of the transaction is null - Should be tested if the fields are null before the operation - Example: If field1 is not null and field2 is not null So Field1 + Field2 Otherwise If field1 is not null So field1 Otherwise If field2 is not null So Field2

When an indicator is average, totals and subtotals are an average of averages and not a weighted average. For the weighted average, create a calculated field whose formula contains the field to be average, then select "Totals calculated from the formula." Example: To view a postponement by product family and the average quantity per invoice, create a calculated field called "average amount", which is formulated in the field "Quantity of the model with the totals calculated from the formula. Select Then in the main interface aggregation average.

You have the CA fields and Budget in your table. Want to add a calculated field = Budget Gap-CA. These two fields from two different queries. You are therefore obliged to create a calculated field in the spreadsheet. Your indicators are in column. The formula of the field deviation is therefore: RC [-1]-RC [-2] Explanation R (Row) corresponds to the line, the deviation is on the same line as CA and Budget C (Column) corresponds to the column, the Budget is a deviation to the left column, then it specifies [-1], the CA is two columns to the left of deviation, so we specify [-2]. If the indicator were online, we have R [-1] CR [-2] C PS: the use of references RC course is not mandatory. It is quite possible to use the names of the indicators in the form of deferral

Click as many times as needed on the Add Filter button in the properties of the calculated field, Formula tab, tab wizard.

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

Windows vista or seven Config panel Programs and Features (To the left) activate or disable Windows features check "Telnet Client"

For example, on a Windows 7 English with French regional settings configured, the dates are not displayed in French but in English. To correct the problem, follow these steps: * Go to Control Panel> Regional Options. * Set a random country in the regional options and confirm. * Back in the regional options and put the correct country and confirm.

An application launched by a scheduled task on a Windows Server 2008 can not use Excel without open session. An error message "OLE 800A03EC" will appear in the error log. The solution is to keep a session open on the server and locked by password. Articles providing information on the subject: http://support.microsoft.com/kb/257757

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