GUID bug?

[ben789]

Hi,

I'm trying to make a master/detail report using parameters in the sql. Unfortunately it does not appear to work using Guid's as the database keys (i.e. I get a "Specified cast is not valid." exception). It works fine if I'm using int's as the keys.

Example Report

If you could let me know if there are any workarounds I would be grateful.

Thanks.

at Reports.Report.ADataSource.get_A_GUID()
at Reports.Report.GetDataSource1_SqlCommand(Object sender, EventArgs e)
at Stimulsoft.Report.Dictionary.StiDataSource.InvokeConnecting()
at Stimulsoft.Report.Dictionary.StiDataSource.Connect(StiDataCollection datas, Boolean loadData)
at Stimulsoft.Report.Dictionary.StiDataSourcesCollection.Connect(StiDataCollection datas, Boolean loadData)
at Stimulsoft.Report.Dictionary.StiDictionary.Connect(Boolean loadData)
at Stimulsoft.Report.Engine.StiRenderProviderV2.ConnectToData(StiReport report)
at Stimulsoft.Report.Engine.StiRenderProviderV2.Render(StiReport report, StiRenderState state)
at Stimulsoft.Report.Engine.StiReportV2Builder.RenderSingleReport(StiReport masterReport, StiRenderState renderState)
at Stimulsoft.Report.StiReport.RenderReport(StiRenderState renderState)
at Stimulsoft.Report.StiReport.Render(StiRenderState renderState, StiGuiMode guiMode)
at Stimulsoft.Report.StiReport.Render(Boolean showProgress)
at Stimulsoft.Report.Design.Controls.StiDesignerPreviewControl.btRefresh_Click(Object sender, EventArgs e)

[Edward]

Hi.

The issue is confirmed. We will inform you about our progress.

The workaround available for now is only this code for A datasource:

select A.A_GUID,a.A_Name,count(b.b_ownerguid) as c from A
left join b
on b.[b_ownerguid]=A.[a_guid]
group by A.[A_Guid],a.[a_name],b.[b_ownerguid]

Thank you.

[Jan]

Hello,

Problem fixed. Patch will be available in build from 3 August.

Thank you.