Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to pass parameters in ssrs 2008 through stored procedure? How to get more than 2lakhs data in ssrs-excel? Expand / Collapse
Author
Message
Posted Wednesday, July 10, 2013 10:42 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, July 24, 2014 10:02 PM
Points: 19, Visits: 38
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.
Post #1472425
Posted Thursday, July 11, 2013 12:32 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:36 AM
Points: 13,345, Visits: 10,205
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?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1472446
Posted Thursday, July 11, 2013 8:18 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, July 24, 2014 10:02 PM
Points: 19, Visits: 38
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


  Post Attachments 
error.jpg (8 views, 36.82 KB)
Post #1472600
Posted Thursday, July 11, 2013 9:08 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 4:14 PM
Points: 13,126, Visits: 11,964
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 Moden's 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)
Post #1472636
Posted Thursday, July 11, 2013 2:37 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:36 AM
Points: 13,345, Visits: 10,205
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




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

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1472780
Posted Thursday, July 11, 2013 2:46 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 4:14 PM
Points: 13,126, Visits: 11,964
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


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 Moden's 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)
Post #1472783
Posted Thursday, July 11, 2013 2:49 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:36 AM
Points: 13,345, Visits: 10,205
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


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?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1472787
Posted Friday, July 12, 2013 12:02 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, July 24, 2014 10:02 PM
Points: 19, Visits: 38
Hi All,

It's more than 2lakhs data.

Sorry, i hope its missed out.

Thanks in advance,
Subhash.
Post #1472864
Posted Friday, July 12, 2013 12:25 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:36 AM
Points: 13,345, Visits: 10,205
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?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1472869
Posted Friday, July 12, 2013 12:41 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 1:55 PM
Points: 2,238, Visits: 2,692
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’! **
Post #1472871
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse