logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
vicky  
#1 Posted : Monday, April 4, 2016 9:30:03 AM(UTC)
vicky

Rank: Newbie

Groups: Registered
Joined: 4/4/2016(UTC)
Posts: 5
India
Location: Pune

We have created Enum for the report using Dynamic SQL, but facing issue.

the SQL query is returning 1000+ valueset to be bind in the parameter prompt, but it's making the whole report slow down and crashing the report server.

How can i Dynamically pass the Enum valueset in real mean time?
we want it to be autofill dropdown with matching criteria only to reduce the overhead.

please do suggest.
epf  
#2 Posted : Monday, April 4, 2016 9:52:51 AM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 533
Switzerland

Thanks: 7 times
Was thanked: 72 time(s) in 70 post(s)
Yes with the current implementation, Enum values having a lot a values will impact the performances...

Could be a good feature request to have smart enums that loads only on demand from the server.

Contributors or sponsors for this are welcomed :-)
vicky  
#3 Posted : Friday, April 8, 2016 6:39:45 AM(UTC)
vicky

Rank: Newbie

Groups: Registered
Joined: 4/4/2016(UTC)
Posts: 5
India
Location: Pune

Hi Admin,

We would like to sponsor it,

can you please provide the details for it.
Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.