URL truncate when sending it from main report to sub report

• Lucky9

  Default port

  Points: 1470

  More actions

  October 8, 2013 at 1:27 pm

  #283663

  I have to pass a URL From main to SUb report, it works fine when the URL is less then 2000 characters but if it's more then that it's truncating the URL

  So is there any work around , in the URL what am sending is list of Customer Id's created in the main report based on the Parameters

  can i create any tables which will store the session customer id's based on the execution of the parameters in the main report and delete it after the session is closed

  trying to pass the customer id's created in the main report to the sub report and it's through the URL

• mister.magoo

  SSC-Forever

  Points: 47174

  More actions

  October 8, 2013 at 4:30 pm

  #1656949

  One thought I have is that you could store the required information in a database table along with a unique reference (e.g. a guid) then pass the unique reference back to the main report , which in turn passes it on to the child report

  OR

  pass the required parameters to the child for it to determine the list itself?

  MM
  

  ---

  
  select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

• Forum Etiquette: How to post Reporting Services problems
[/url]
• Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
[/url]
• How to Post Performance Problems - by Gail Shaw
[/url]