Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Subreport with uniqueidentifier or guid parameter Expand / Collapse
Author
Message
Posted Tuesday, February 26, 2013 4:58 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, June 17, 2014 7:07 AM
Points: 66, Visits: 124
Hi,

I am adding a subreport to a report and I need to pass a uniqueidentifier or Guid to the subreport. However the subreport only allows me to specify the parameter as text/boolean/Detatime/integer/float.

If I use Text, I get th esubreport stating "Data retrieval failed".

What do I need to do?
Post #1424286
Posted Wednesday, March 13, 2013 1:30 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, June 17, 2014 7:07 AM
Points: 66, Visits: 124
Has this never been done before?

Frank Cazabon (2/26/2013)
Hi,

I am adding a subreport to a report and I need to pass a uniqueidentifier or Guid to the subreport. However the subreport only allows me to specify the parameter as text/boolean/Detatime/integer/float.

If I use Text, I get th esubreport stating "Data retrieval failed".

What do I need to do?
Post #1430599
Posted Thursday, March 14, 2013 3:14 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, May 14, 2014 4:10 AM
Points: 23, Visits: 138
http://www.developmentnow.com/g/115_2005_4_0_0_457409/Passing-unique-identifiers-to-subreports.htm
Post #1430827
Posted Thursday, March 14, 2013 5:50 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, June 17, 2014 7:07 AM
Points: 66, Visits: 124
Thanks, I'll see if I can get that to work
Post #1430900
Posted Thursday, March 14, 2013 6:47 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, June 17, 2014 7:07 AM
Points: 66, Visits: 124
dohnfors (3/14/2013)
http://www.developmentnow.com/g/115_2005_4_0_0_457409/Passing-unique-identifiers-to-subreports.htm


Unfortunately I'm still not getting it.

I am using Visual Studio 2010 and have created an RDLC main report and subreport.

Can you recommend a good walk through or book for subreports that I could follow? Everything I am finding refers to menu options or tabs that I am not seeing in my Report
Post #1430927
Posted Monday, March 18, 2013 1:29 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, May 14, 2014 4:10 AM
Points: 23, Visits: 138
http://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/da0d5e37-cb79-456c-9097-6e3c16a7ef3e
Post #1432094
Posted Monday, March 18, 2013 5:23 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, June 17, 2014 7:07 AM
Points: 66, Visits: 124
Thanks I had actually found a book and bought it hoping that it would help me despite it being for VS 2005 and thankfully it did.

This is the book:

http://www.amazon.com/gp/product/1590598547/ref=s9_psimh_gw_p14_d1_i1?pf_rd_m=ATVPDKIKX0DER&pf_rd_s=center-2&pf_rd_r=1V9E17C7MPDBS0QRD1KB&pf_rd_t=101&pf_rd_p=1389517282&pf_rd_i=507846

It explained to me that I needed to have the all the data needed for the master and for the detail in my dataset which I had not found anywhere else. It also showed me the type of code necessary to handle the subreport processing and I was able to adjust this to speed up the extremely slow subreport so that I actually filter the data appropriately on each subreport in code rather than loading the entire dataset for the subreport and letting the report filter it based on the filter set on the tablix.

Thanks for your help.
Post #1432143
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse