Hi all, Thanks for reading me.(and sorry by advance for my english). This is the story from the beginning :) I have a model -> which runs with SQL Server 2008 and 2008 R2. (Report server databases and report server versions) -> and runs too with : Oracle 9,10,11 and SQL Server 2005,2008,2008R2 databases (databases which are used to select datas to show on reports). Nearly all is Ok. I have just one problem with Oracle compatibility on one point : in my model I have a lot of fields which give hundredth hours (decimal type). For each field like that, I have made a calculated field which is a varition of the hundredth hours field ans which gives the equivalent value in Hour/minute (text type). The formula I had written is : right(("00" & TEXT(INT(monHeureCentieme);2) & ":" & right((TEXT(INT(60 * (monHeureCentieme - INT(monHeureCentieme);2) Then I deploy the model and use it with report builder as a datasource, and I create a dataset, with the query builder. I drop the field with hundredth hours (decimal type) and I test with Execute, I do the same with the variation field (text type) : -> when I use a SQL Server database : no problems. -> when I use an Oracle databse : when I add one of this calculated field it doesn't work : I have this error (with a 2008 and 2008R2 report server): Le serveur distant a retourn une erreur : (500) Erreur interne du serveur. I tried to write the formula in the dataset straight and it works very well :'( But I need it in the model, there are a lot of field like this so it have to be shown in the model. So I don't understand why the field from the model dosen't work. Do you have an idea? I thank you so much by advance. See you. Thank you again.Edit : I don't know if it's important b ut the system used are : for 2008 R2 : windows 7 64 bits, for 2008 : windows 2003 server 32 bits. Tell me if you need more informations :)

Hi all :) I would up my subjet because I don't find a solution for it :( Do you have an idea? Thank you by advance. See you.

Hi all ^^ it's me again. I really can't find a solution :/ Would you have a clue or a way to guide me? Thank you by advance :) See you

maybe use ( and ) before concat

Hi all, Thank you :) :) I have resolved my problem for a part : I have added parenthesis : right(("00" & (TEXT(INT(monHeureCentieme));2) & ":" & right((TEXT(INT(60 * (monHeureCentieme - INT(monHeureCentieme);2) But now I have always a problem : I have a semantic query error when the source field is empty. Do you know how I can resolve it? Thank you so much by advance. See you.

Hi all :) So I have news. It dosen't work anymore. But t his is what I have tried : -> I have changed the formula (see last post) : I had a different error message right(("00" & (TEXT(INT(monHeureCentieme));2) & ":" & right((TEXT(INT(60 * (monHeureCentieme - INT(monHeureCentieme);2) -> I have found that was beacause of the provider : so I have installed the latest version of ODP : I had the first error again :'( -> I have found some field with the same formula which works (I have more than 50 calculated fiel with thi formula) : So I made merge between them : between the formulas : no differences... And then, between the xml of the smdl : there was a difference : these lines were in the field which dosen't work : <CustomProperties> <CustomProperty Name="p24:Parentheses" xmlns:p24="http://schemas.microsoft.com/sqlserver/2004/11/semanticquerydesign" /></CustomProperties> So I have deleted all these lines : but no changes. Always the same error : when I launch a report which use these fields : Une erreur s'est produite lors du traitement du rapport. (rsProcessingAborted)chec de l'excution de la requte pour le dataset 'DataSet1'. (rsErrorExecutingCommand) chec de l'excution de la requte smantique. (rsSemanticQueryEngineError) Une erreur interne s'est produite sur le serveur de rapports. Pour plus d'informations, consultez le journal des erreurs. (rsInternalError) Or when I insert this fields ine a dataset : Une erreur s'est produite lors de l'excution de la requte. Une erreur s'est produite lors de l'excution de la requte. Consultez l'exception interne pour plus d'informations. (Microsoft SQL Server Report Builder) =================================== Une erreur s'est produite lors de l'excution de la requte. Consultez l'exception interne pour plus d'informations. (mscorlib) ------------------------------ Emplacement du programme : Server stack trace: Microsoft.ReportingServices.RsClient.RsCommand.ExecuteRsDataReader() Microsoft.ReportingServices.RsClient.RsCommand.ExecuteDbDataReader(CommandBehavior behavior) Microsoft.ReportingServices.RsClient.RsCommand.ExecuteReader(CommandBehavior behavior) Microsoft.ReportingServices.RsClient.RsCommand.ExecuteReader() Microsoft.ReportingServices.DataExtensions.ReportServerDataProvider.RSDPCommand.ExecuteReader(CommandBehavior behavior) Microsoft.ReportingServices.QueryDesigners.MultiThreadedQueryResultsHelper.AsyncExecuteReader(IDbCommand command, CommandBehavior behaviour) System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs) System.Runtime.Remoting.Messaging.StackBuilderSink.PrivateProcessMessage(RuntimeMethodHandle md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs) System.Runtime.Remoting.Messaging.StackBuilderSink.AsyncProcessMessage(IMessage msg, IMessageSink replySink) Exception rethrown at [0]: System.Runtime.Remoting.Proxies.RealProxy.EndInvokeHelper(Message reqMsg, Boolean bProxyCase) System.Runtime.Remoting.Proxies.RemotingProxy.Invoke(Object NotUsed, MessageData& msgData) Microsoft.ReportingServices.QueryDesigners.MultiThreadedQueryResultsHelper.ExecuteReaderHandler.EndInvoke(IAsyncResult result) Microsoft.ReportingServices.QueryDesigners.MultiThreadedQueryResultsHelper.<>c__DisplayClass1.<ExecuteActiveQueryCallback>b__0() Microsoft.ReportingServices.QueryDesigners.QueryResultsGrid.EndExecuteReaderInUiThread(GetDataReaderHandler getDataReaderCallback) =================================== Le serveur distant a retourn une erreur : (500) Erreur interne du serveur. <detail><ErrorCode xmlns="http://www.microsoft.com/sql/reportingservices">rsSemanticQueryEngineError</ErrorCode><HttpStatus xmlns="http://www.microsoft.com/sql/reportingservices">400</HttpStatus><Message xmlns="http://www.microsoft.com/sql/reportingservices">chec de l'excution de la requte smantique. </Message><HelpLink xmlns="http://www.microsoft.com/sql/reportingservices">http://go.microsoft.com/fwlink/?LinkId=20476&amp;EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&amp;EvtID=rsSemanticQueryEngineError&amp;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&amp;ProdVer=10.50.2500.0</HelpLink><ProductName xmlns="http://www.microsoft.com/sql/reportingservices">Microsoft SQL Server Reporting Services</ProductName><ProductVersion xmlns="http://www.microsoft.com/sql/reportingservices">10.50.2500.0</ProductVersion><ProductLocaleId xmlns="http://www.microsoft.com/sql/reportingservices">127</ProductLocaleId><OperatingSystem xmlns="http://www.microsoft.com/sql/reportingservices">OsIndependent</OperatingSystem><CountryLocaleId xmlns="http://www.microsoft.com/sql/reportingservices">1036</CountryLocaleId><MoreInformation xmlns="http://www.microsoft.com/sql/reportingservices"><Source>Microsoft.ReportingServices.SemanticQueryEngine</Source><Message msrs:ErrorCode="rsSemanticQueryEngineError" msrs:HelpLink="http://go.microsoft.com/fwlink/?LinkId=20476&amp;EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&amp;EvtID=rsSemanticQueryEngineError&amp;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&amp;ProdVer=10.50.2500.0" xmlns:msrs="http://www.microsoft.com/sql/reportingservices">chec de l'excution de la requte smantique. </Message><MoreInformation><Source>Microsoft.ReportingServices.Diagnostics</Source><Message msrs:ErrorCode="rsInternalError" msrs:HelpLink="http://go.microsoft.com/fwlink/?LinkId=20476&amp;EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&amp;EvtID=rsInternalError&amp;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&amp;ProdVer=10.50.2500.0" xmlns:msrs="http://www.microsoft.com/sql/reportingservices">Une erreur interne s'est produite sur le serveur de rapports. Pour plus d'informations, consultez le journal des erreurs.</Message></MoreInformation></MoreInformation><Warnings xmlns="http://www.microsoft.com/sql/reportingservices" /></detail> =================================== Le serveur distant a retourn une erreur : (500) Erreur interne du serveur. (System) ------------------------------ Emplacement du programme : System.Net.HttpWebRequest.GetResponse() Microsoft.ReportingServices.RsClient.RsCommand.ExecuteRsDataReader() I don't understand why some of them works well... And why, when I wrote the formula in a calculated fiel in report builder (during a dataset builing) : all works. Would you have an idea? I thank you bay advance. See you.