Report Sharp Shooter loading 300k records problem


Author
Message
Edhy Rijo
E
StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K 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

Replies
Edhy Rijo
E
StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)
Group: StrataFrame Users
Posts: 2.4K, Visits: 23K
Trent L. Taylor (09/02/2009)


Well, generally I will create a custom property that exposes this on the Inherited Reporting BO.




Darn, sometimes I just forget to go back to the basics "custom field property", I use them all the time and in this case I simply got stuck which lead me to explore another area from RSS "Common Script" so I went ahead and create a function that will return the proper value for the Enum, it works fine, but it is not efficient in case the Enum values changes, so a custom property will be used.



Thanks again!



P.S.

About custom field properties "CFP" and BSS, have you noticed in VB that when a CFP is created, it does now show up in the BBS1 instance in the form unless I close the solution, exit VS and come back.

Edhy Rijo

Trent Taylor
Trent Taylor
StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 7K
About custom field properties "CFP" and BSS, have you noticed in VB that when a CFP is created, it does now show up in the BBS1 instance in the form unless I close the solution, exit VS and come back.





No. This is most likely due to you having your assemblies in the GAC. That is the only time I have seen something like that.
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