Report Sharp Shooter loading 300k records problem


Author
Message
Edhy Rijo
E
StrataFrame VIP (4.6K reputation)StrataFrame VIP (4.6K reputation)StrataFrame VIP (4.6K reputation)StrataFrame VIP (4.6K reputation)StrataFrame VIP (4.6K reputation)StrataFrame VIP (4.6K reputation)StrataFrame VIP (4.6K reputation)StrataFrame VIP (4.6K reputation)StrataFrame VIP (4.6K reputation)
Group: StrataFrame Users
Posts: 2.4K, Visits: 23K
Hi Trent,



I am having a situation with RSS and wanted to see if you or somebody else here in the forums has experienced this one before going to RSS support.



I have a report that will bring a lot of child records up to 300,000. I am using SF BBS and I have not problems generating small data reports (less than a 1,000), but with the ones over 250,000 then I simply get the RSS "No Report grey screen) and after waiting a considered period of time, nothing ever comes up.



This BBS is based on a View and the data is grabbed using a store procedure to limit the fields to be shown and expedite the generation, while debbuging I can see all the records in the BBS.Source.Count and I can even visualize them.



Now to explain why so many records, I have to import CSV files with that many records which are then sorted out against my data and the ones that fail needs to be send out back to the CSV originator, so my plan was to generate a nice PDF file with RSS.



At this point I appreciate any suggestion related to the overall process. Thanks!

Edhy Rijo

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search