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

Report Model Changes - How do I the DiscourageGrouping attribute for a field? Expand / Collapse
Author
Message
Posted Monday, April 21, 2014 1:33 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, June 13, 2014 2:32 PM
Points: 8, Visits: 38
I have a field 'comments' that is returning an error when I drag and drop it to report builder that states the attached large volumn return error. From research that I have done it seems that the discouragegrouping needs to be set to 'True' for this field. Can someone tell me how to set that?

Thank you,

Dawn


"Cakes"

  Post Attachments 
Rpt builder error.png (4 views, 7.34 KB)
Post #1563601
Posted Tuesday, April 22, 2014 9:54 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 6:42 PM
Points: 345, Visits: 853
Not sure. I think count returns an integer and the largest number that can return is 2,147,483,647. Do you have some more information on your query that can help?
Post #1563934
Posted Friday, June 13, 2014 2:33 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, June 13, 2014 2:32 PM
Points: 8, Visits: 38
Thanks for your reply! I finally found it located in Reporting Services but it was a hidden attribute. All is good

"Cakes"
Post #1580737
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse