How to pass a data parameter paginated report
Hi I have these 2 parameters as circled in red in the following snapshot: They come from using the Data Source called "RevenueReports_ProfitReport2": My question is how do I pass them to my other dataset "Rates" to the Date field? This is what I have done so far but when I execute my query I get no resuts.
Scheduled Refresh
Hi everyone! I have this issue: [0] -1055784934: DataSource.Error: ODBC: ERROR [08S01] SQLColAttributeW unable due to the connection lost. DataSourceKind = Odbc. DataSourcePath = dsn=AIS_Observatory. OdbcErrors = error "Microsoft.Mashup.Engine1.Runtime.ValueException: [Expression.Error] Value was not specified.#(cr)#(lf) at Microsoft.Mashup.Engine1.Language.ValueCreator.CreateValueForNotImplemented(INotImplementedExpression expression)#(cr)#(lf) at Microsoft.Mashup.Engine1.Runtime.ListValue.DemandArrayListValue.get_Item(Int32 index)#(cr)#(lf) at Microsoft.Mashup.Engine1.Runtime.BufferedListValue.BufferedValueReference.get_Value()#(cr)#(lf) at Microsoft.Mashup.Engine1.Runtime.TableTypeValue.FromValue(ListValue columns, TypeValue defaultColumnType)#(cr)#(lf) at Microsoft.Mashup.Engine1.Runtime.TableTypeValue.FromValue(Value columns, TypeValue defaultColumnType)#(cr)#(lf) at Microsoft.Mashup.Engine1.Library.Table.TableModule.Table.FromRowsFunctionValue.TypedInvoke(ListValue rows, Value columns)#(cr)#(lf) at Microsoft.Mashup.Engine1.Runtime.NativeFunctionValue2`3.Invoke(Value arg0, Value arg1)#(cr)#(lf) at Microsoft.Mashup.Engine1.Language.ValueCreator.<>c__DisplayClass23_0.<CreateValueForRecord>b__0(Int32 index)#(cr)#(lf) at Microsoft.Mashup.Engine1.Runtime.RecordValue.DemandRecordValue.get_Item(Int32 index)#(cr)#(lf) at Microsoft.Data.Mashup.ProviderCommon.MashupResource.TryGetValue(Func`1 getValue, IValue& value, String& errorMessage)#(cr)#(lf)Record". . The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action. The scheduled refresh was working fine and suddenly stop working. Please, I need some help!!!!!!!!!!
