Click here to Skip to main content
15,867,308 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hello All,
My Self Hardik Soni. I m working as jr. Devloper in Amba soft solution. i have to do one task for SSRS i have 1st export ssrs report in excel format and then i email that report.So plz i must have to complete this tast on monday if anybody has give answer on it then plz reply immediately on my Email Address which is [email removed]@gmail.com plz help me out for this task
Posted
Updated 29-Oct-11 10:31am
v2
Comments
[no name] 29-Oct-11 16:35pm    
Do not include your email and ask people to respond there. The point of asking a question here is to get responses that are shared for the benefit of all.

Also, don't ask for an immediate response. This is a volunteer site and people will answer on their time, not yours.
hardiksoni88 29-Oct-11 16:51pm    
ok thanks for advising
Atul_Negi 14-Sep-18 10:33am    
Hi,

I am trying to access data in Tablix control, it always have 1 data rows. But in preview it is showing actual number of rows of data. Even if I export in CSV or some other standard format, it exports all the rows which are getting displayed in report.

I am accessing the RowsCollection like below:

((Tablix)item2).Body.RowCollection.Count

and then accessing cell value:

((TextBox)cell.CellContents.ReportItem).Paragraphs[0].Instance.TextRunInstances[0].OriginalValue

Why I am always getting only two rows? not the original

Quick help in this is appreciated.

1 solution

Got this through a very simple Google query:

http://weblogs.asp.net/srkirkland/archive/2007/10/29/exporting-a-sql-server-reporting-services-2005-report-directly-to-pdf-or-excel.aspx[^]

Once you have the report, emailing it should be trivial. See http://msdn.microsoft.com/en-us/library/system.net.mail.smtpclient.aspx[^]

Good luck for Monday though. That said, you probably need to talk to your manager about giving you tasks you are not prepared for.
 
Share this answer
 
Comments
Nish Nishant 29-Oct-11 16:49pm    
Post about that error in a separate question. I am sure someone here will help you out.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900