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 «««1234

Let the Excel Play Expand / Collapse
Author
Message
Posted Monday, October 6, 2008 2:04 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, April 17, 2012 5:38 AM
Points: 16, Visits: 93
Hey don't get me wrong, I respect you and it was out of that respect only :)))))))))))))))))))))
Post #580939
Posted Monday, October 6, 2008 10:23 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, August 10, 2012 6:08 PM
Points: 1,156, Visits: 801
Jeff Moden (10/5/2008)
"If you limit what they can read to simple views, you also keep control of the queries so they don't crush the server performance wise."
- and -
"You can either spend time writing custom automations for all 50 users, or you can teach them to become self sufficient.
"

I fully and whole-heartedly believe in the principle, "Teach them correct principles and they govern themselves." Seeing your point to a point, but then it has not stopped the problems of needing to dubunk what they do with the data.

In so many words or less you are actually taking TWO steps:
1. Teaching
2. Creating controlled sources of output they can use to effectively limit what they may want to do to munge the data.

Herein lies the the delta: Judging how much time to spend creating the various views and rights to view, and dealing with how they rollup, pivot, and analyze the data.

When the numbers do not match, it is back in your lap anyway. Notice I did not use "If". And remember, I noted that I have these issues more with those who feel they know Excel... not the new learners... the new ones do not usually know enough to even get themselves into trouble. The problem lies in the fact that both the Views they need, and the report crunching layout needs to be handled.

So when a report becomes adopted between more than a couple people, I mold it on report server, so that all they have to do is copy it down (if they must) with little or no munging. If the analytical mistakes of others did not come to haunt me so, then I would be more apt to just teach... heh... would even prefer to just teach.
Post #581232
Posted Tuesday, October 7, 2008 2:20 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, December 16, 2014 9:58 PM
Points: 1,207, Visits: 928
sashank, thanks for this article. For me it came at just the right time. I have one problem though. When I try to open the connection string "con.Open connstr" I get the following error. Run-time error: '3001' Application-defined or object-defined error. Any ideas? I checked the references in vba but all looks fine. Please help!!

Further to the comments in this post. Get external data is ok but I want to with VB place my data and make it look like a real report and the client wants it in Excel. So, I think this is a cool way to do it.


Manie Verster
Developer
Johannesburg
South Africa

I can do all things through Christ who strengthens me. - Holy Bible
I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)
Post #581585
Posted Tuesday, October 7, 2008 2:46 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, April 17, 2012 5:38 AM
Points: 16, Visits: 93
Plz send me the code to analyze
Post #581598
Posted Tuesday, October 7, 2008 3:20 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, April 17, 2012 5:38 AM
Points: 16, Visits: 93
Also make sure that MDAC components are installed on the machine
Post #581608
Posted Thursday, October 9, 2008 1:06 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, December 16, 2014 9:58 PM
Points: 1,207, Visits: 928
shashank, thanks for the reply and sorry for only comming back to you now. MDAC is installed on my computer and I did come right thank you. I had the provider wrong in my connection string and when I fixed it, it worked thanks to Adrian Jardin (a fellow South African) that helped me. Thanks Adrian!

Manie Verster
Developer
Johannesburg
South Africa

I can do all things through Christ who strengthens me. - Holy Bible
I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)
Post #583089
« Prev Topic | Next Topic »

Add to briefcase «««1234

Permissions Expand / Collapse