I am using 'Report Viewer Control ' in my project. I am using sub-reports in many cases. Whenever I export such reports containing sub-reports to 'Excel' format which is the major client requirement in our project, the exported excel file shows 'Subreports within table/matrix cells are ignored.'
Can anybody tell me the solution for this? If not possible in reporting service then is there any other way to get data in excel format?
Till SSRS 2005: This is a known limitation in the excel rendering. The problem occurs when subreports and/or any data regions are nested in table/matrix. Microsoft I mean SSRS doesn’t support exporting these to Excel format.
Other way to get it done is:
Embed the sub report within a rectangle rather than within a table. It will export ok.
P.S.: SSRS 2008 (shipped as part of SQL Server 2008) provides a full solution to this, since it has a new engine and rendering extensions. Excel rendering will now always render subreports contents.
Currently i am using CR chart for my report however i need to set the color of the stacked bar, I can only set the color when using color by group. However i need to use color by series as i am using stacked bar.....
CP isWe are building this repository of asking Q&A in CodeProject. Asking questions here[^] would help you in tracking you and other people who face something similar. Try it. You can also mark answers as accepted if it resolves your issue.
hi, iam using asp.net 2.0 with c# with ajax and database is sql server.
so when iam using a textbox control when user enter the any part of column or any filed in the text box it should come like popup in the textbox from database . can you give me a simple example which helps me.
when iam using a textbox control when user enter the any part of column or any filed in the text box it should come like popup in the textbox from database
Can you clearer? It's really difficult to understand what you are trying to ask right now.
like: Where from column came into question when talking of textbox? What do you mean by, field in textbox should come like popup in textbox from database?
Elaborate a little and tell where DB comes into picture and what exactly needs to be displayed in the popup?
iam having textbox in asp.net when user enter any value either branchname oraddress or emailid or phone no or mobileno the solution should comes like autocomplete extender . popup should come in textbox text
using asp.net with c#. give me a example which helps me.