Export to Excel queries for multiple worksheets in SSRS 2008 -


we have 2 reports, 1 consumer details , consumer transaction details. consumer transaction details report based on consumerid consumer details report.

consumer details report displays consumer details. consumer transaction details contain consumer’s transaction details.

we have created 2 separate reports in ssrs. have set “go report” action consumerid field of consumer details report point consumer transaction details report consumer id only. this, have set parameters. in preview of consumer details report when click on consumerid field, displays transactions details clicked consumer id.

now, want 2 things:

  1. when export excel, want consumer details should in sheet1, , consumer transactions details should displayed in sheet2, sheet3,sheet4…etc. (number of sheets should depends on number of consumer id available in consumer details report).
  2. also, when click on consumerid cell of consumerdetails, should redirected particular transaction details sheet (for consumerid).

is there way achieve this?

your first requirement can achieved through adding subreport referring consumer transaction details , make visible when exported excel. if using ssrs 2012, can use following expression in subreport visibility:-

=iif(globals!renderformat.name = "excelopenxml", false,true)

reason make subreport when export report, current viewable content exported (unless hidden expression mentioned), not linked reports. when have subreport consumer transaction details rendered along main report consumer details, can export them in 1 excel file. make sure apply appropriate page breaks view data in different sheets.

as second requirement, since when export data excel, linked other report given link, hyperlink direct reporturl. far have known ssrs, cant done. please comment if have questions.


Comments

Post a Comment

Popular posts from this blog

android - Get AccessToken using signpost OAuth without opening a browser (Two legged Oauth) -

i using signpost oauth access data magento server. have read various tutorials on same , reach point open browser user can enter credentials. however, per requirement have automate part. hence, user should not browser page. have set-up done on server side ( magento ), hit url , returned call page. same through program in android. i have tried below, consumer = new commonshttpoauthconsumer(key, secret); provider = new commonshttpoauthprovider(oauth_init_url,access_token_url, authorize_url); try { provider.retrieverequesttoken(consumer, oauth.out_of_band); log.d("tokens" , consumer.gettoken() + " -- " + consumer.gettokensecret()); } and request tokens. dont know how bypass next step. tried directly accessing accesstoken (stupid of me) provider.retrieveaccesstoken(consumer, "mycallback://callback"); no luck, ends in oauth.signpost.exception.oauthnotauthorizedexception: authorization failed (server replied 401). ...
Read more

org.mockito.exceptions.misusing.InvalidUseOfMatchersException: mockito -

getting error org.mockito.exceptions.misusing.invaliduseofmatchersexception: invalid use of argument matchers! 1 matchers expected, 2 recorded. exception may occur if matchers combined raw values: //incorrect: somemethod(anyobject(), "raw string"); when using matchers, arguments have provided matchers. example: //correct: somemethod(anyobject(), eq("string matcher")); at when( getprogramservice .callservice(any(getprogramtype.class))) .thenreturn(jaxbresponse); please explain error , possible resolution the code posted looks fine; don't see problem it. code before or above causing exception. key here: invalid use of argument matchers! 1 matchers expected, 2 recorded. any , used above, doesn't return "special kind of null" or "special kind of getprogramtype"; don't exist. instead, returns null , side effect puts matcher on stack. whe...
Read more

google shop client API returns 400 bad request error while adding an item -

i'm working on solution add items in google shopping market java application. following tutorial real mess because of missing classes of laste release, after setting 1.5-beta maven managed make base example typecheck correctly classes. still can make simple task of adding 1 item. instead of posting whole code i'm posting part creates product feed. private product createproduct(string id) { product product = new product(); product.title = "red wool sweater"; product.content = new content( "text", "comfortable , soft, sweater keep warm on " + "cold winter nights. red , blue stripes."); product.appcontrol = new appcontrol(); product.appcontrol.addrequireddestination("productads"); product.externalid = id; product.lang = "it"; product.country = "it"; product.condition = "nuovo"; product.price = new price("eu...
Read more