Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cipriani1984
Constraint Violating Yak Guru
304 Posts |
 Posted - 2009-09-28 : 09:41:26
|
| Hi,Producing reports here for department who love to export into excel and run their 'special' formulas and macros but they have to convert the field to number format, even though my data is set to 'int' in the database, any ideas?Cipriani |
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-09-28 : 12:45:05
|
| Odd. I am working on an Excel extract bug myself (which I'll post to board soon. Anyway, I have a column ZipCode (USA version of a Postal Code) and a calculated SUM field.ZipCode Defined as varchar(12),Qty field being Summed as intWhen I export to Excel the zipcode (in Excel 2007) is left adjusted and has the warning-"The number in this cell is formatted as text or preceeded by an apostrophe. The Quantity field is numeric.I am doing nothing "special" in the RDL or SQL.Sorry...John |
 |
|
|
cipriani1984
Constraint Violating Yak Guru
304 Posts |
Posted - 2009-09-28 : 13:06:47
|
Yea i converted to int, nvarchar, float etc and the user still has to right click the cell and click convert to number..quote:
Originally posted by JCirocco
Odd. I am working on an Excel extract bug myself (which I'll post to board soon. Anyway, I have a column ZipCode (USA version of a Postal Code) and a calculated SUM field.ZipCode Defined as varchar(12),Qty field being Summed as intWhen I export to Excel the zipcode (in Excel 2007) is left adjusted and has the warning-"The number in this cell is formatted as text or preceeded by an apostrophe. The Quantity field is numeric.I am doing nothing "special" in the RDL or SQL.Sorry...John
|
|
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-09-28 : 14:41:06
|
| What version of Excel?What if you a redundant conversion to Integer within the report design? I know I didn't have to do that but there may be version differences?John |
|
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-09-28 : 15:00:30
|
| OK, just created a new permission for a user=training and created a new role Browser_Reporting_Only. I opened the Browser role and selected copy. I unchecked View Folder, View Models, and View Resources. The role only has View Reports. I needed a URL that was a direct link to an authorized report. I was able to open and run the reports in my folder as long as I knew the URL. It also removed the ability to navigate the folders. The error they would get is: The permissions granted to user 'WNY\training' are insufficient for performing this operation. (rsAccessDenied) Get Online HelpJohn |
|
|
|
cipriani1984
Constraint Violating Yak Guru
304 Posts |
Posted - 2009-09-29 : 07:05:38
|
I managed to get it down to they dont have access to execute the reports in folders, but they can still view folders.Is there just no way of not allowing them to view stuff i dont want them to see?quote:
Originally posted by JCirocco
OK, just created a new permission for a user=training and created a new role Browser_Reporting_Only. I opened the Browser role and selected copy. I unchecked View Folder, View Models, and View Resources. The role only has View Reports. I needed a URL that was a direct link to an authorized report. I was able to open and run the reports in my folder as long as I knew the URL. It also removed the ability to navigate the folders. The error they would get is: The permissions granted to user 'WNY\training' are insufficient for performing this operation. (rsAccessDenied) Get Online HelpJohn
|
|
|
|
|
|
|
|
|
Exporting to Excel