Master-detail link subreport on GUID field?

Permanently deleted user

25 octobre 2019 03:27

I am unable to get a subreport to work using a GUID parameter in the filter... is there a trick to this? 

 

I can get the subreport working using other field/parameter types from the master, but not using a GUID.

 

Any help or hints appreciated.

 

Cheers

0

• 

  Belinda Kerr

  25 octobre 2019 04:14

  You may have already done this, but when I've had issues with the parameter binding its because I needed to change the parameter type from a number 16 bit to 32 bit. Have you tried using the GUID parameter type in both the master and subreport??

  0
• 

  Permanently deleted user

  25 octobre 2019 04:53

  Thanks Belinda for your reply.

   

  Actually to solve this I used string types instead of GUID, and in the filter I had to use "Like" not equals, and I also had to use wildcards at the start and end of the parameter... so I made a calculated field being like '%' + [guidfield] + '%' and fed that to the filter parameter. "field LIKE calcfield"

   

  mind bending and I dont like it, but it worked!

   

  Cheers

  0
• 

  Permanently deleted user

  21 novembre 2019 21:42

  I've ran into this same issue, very frustrating. I will try your solution David.

  0
• 

  Patrick Fingler

  3 décembre 2019 20:37

  I'm sure there are multiple ways to accomplish this.

   

  For example, I've been able to join a GUID from a parent data source to a GUID within a sub-report using the following process.

   

  My sub-report has the following parameter (Notice type is Guid):

  

  My subreport data source query filter is:

  

  And the globalIds parameter is setup as the following (Notice it converts the GlobalId to a String):

  

  Lastly, my parent report has the following subreport parameter bindings:

  

   

  Hope that helps!

  0

Vous devez vous connecter pour laisser un commentaire.