Rank: Newbie
Groups: Registered
Joined: 4/4/2016(UTC) Posts: 5  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.
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209  Thanks: 14 times
Was thanked: 206 time(s) in 199 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 :-)
|
|
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 4/4/2016(UTC) Posts: 5 Location: Pune
|
Hi Admin,
We would like to sponsor it,
can you please provide the details for it.
|
|
|
|
|
|
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.
