SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


How to pass parameters in ssrs 2008 through stored procedure? How to get more than 2lakhs data in...


How to pass parameters in ssrs 2008 through stored procedure? How to get more than 2lakhs data in ssrs-excel?

Author
Message
Venal
Venal
Valued Member
Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)

Group: General Forum Members
Points: 53 Visits: 55
I have a problem in ssrs,please suggest your valuable answers.



Problem:- I have one report, in that i'm passing one stored procedure.This procedure having 2 parameters.One is int,second one is date format.I need to get the data through these parameters and saved it into Excel.

when i was tried to save the data in excel it was getting problem.

Thanks in advance,

Subhash.
Koen Verbeeck
Koen Verbeeck
SSC Guru
SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)

Group: General Forum Members
Points: 64666 Visits: 13298
Can you be a bit more specific?

I have totally lakhs data.can i save this data into excel?


How are we supposed to answer a question like this?
Yes you can get data into Excel. Totally lakhs (remember this is an international forum. Use real numbers) data? I don't know, how much is totally lakhs data?

It seems to me you need to tackle this problem with SSIS (Integration Services), not SSRS.


How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
Venal
Venal
Valued Member
Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)

Group: General Forum Members
Points: 53 Visits: 55
Hi Koen,

I'm very new of ssrs.

when i was tried to save the ssrs result set data in excel i'm getting the error.

For your reference i attached the error image.


Thanks in adavnce,
Subhash
Attachments
error.jpg (12 views, 36.00 KB)
Sean Lange
Sean Lange
SSC Guru
SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)

Group: General Forum Members
Points: 64816 Visits: 17979
subbareddyap (7/11/2013)
Hi Koen,

I'm very new of ssrs.

when i was tried to save the ssrs result set data in excel i'm getting the error.

For your reference i attached the error image.


Thanks in adavnce,
Subhash


That error should be pretty self explanatory. You can't put 200,000+ rows into an excel spreadsheet. Why do you want to put this much into a spreadsheet? If you need to transfer the data there are better ways than Excel. If you can explain what you are trying to do we can help.

Koen - Lakh is the same as 100,000. http://en.wikipedia.org/wiki/Lakh

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Koen Verbeeck
Koen Verbeeck
SSC Guru
SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)

Group: General Forum Members
Points: 64666 Visits: 13298
Sean Lange (7/11/2013)


Koen - Lakh is the same as 100,000. http://en.wikipedia.org/wiki/Lakh


I know what Lakh is (although other people on this forum might not), I just didn't know how much "totally lakh" is :-D


How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
Sean Lange
Sean Lange
SSC Guru
SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)

Group: General Forum Members
Points: 64816 Visits: 17979
Koen Verbeeck (7/11/2013)
Sean Lange (7/11/2013)


Koen - Lakh is the same as 100,000. http://en.wikipedia.org/wiki/Lakh


I know what Lakh is (although other people on this forum might not), I just didn't know how much "totally lakh" is :-D


Totally 1,00,000? Being an American through and through that always looks like a misprint of 1 million to me. ;-) I suspect that they meant "total rows around 1 lakh" or something...but who knows.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Koen Verbeeck
Koen Verbeeck
SSC Guru
SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)

Group: General Forum Members
Points: 64666 Visits: 13298
Sean Lange (7/11/2013)
Koen Verbeeck (7/11/2013)
Sean Lange (7/11/2013)


Koen - Lakh is the same as 100,000. http://en.wikipedia.org/wiki/Lakh


I know what Lakh is (although other people on this forum might not), I just didn't know how much "totally lakh" is :-D


Totally 1,00,000? Being an American through and through that always looks like a misprint of 1 million to me. ;-) I suspect that they meant "total rows around 1 lakh" or something...but who knows.


For a European fellow like me it looks like a misprint as well :-)


How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
Venal
Venal
Valued Member
Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)

Group: General Forum Members
Points: 53 Visits: 55
Hi All,

It's more than 2lakhs data.

Sorry, i hope its missed out.

Thanks in advance,
Subhash.
Koen Verbeeck
Koen Verbeeck
SSC Guru
SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)

Group: General Forum Members
Points: 64666 Visits: 13298
subbareddyap (7/12/2013)
Hi All,

It's more than 2lakhs data.

Sorry, i hope its missed out.

Thanks in advance,
Subhash.


You can export this to CSV, but not to Excel.
What is the purpose of this export? If you want to analyze the data, you can import it into Power Pivot. This tool can easily handle 200,000 rows.


How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
HanShi
HanShi
SSCrazy Eights
SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)

Group: General Forum Members
Points: 8892 Visits: 3718
If you really want to import that much data into Excel, you need to upgrade to a newer version.
Excel 2010 is capable to handle a bit more then 1.000.000 (1 mln) rows.
But again, as Koen allready posted: what is your purpose for this data? Maybe another tool can be more appropriate.

** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search