SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Let the Excel Play


Let the Excel Play

Author
Message
shashank-666535
shashank-666535
SSC Rookie
SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)

Group: General Forum Members
Points: 40 Visits: 93
Hey don't get me wrong, I respect you and it was out of that respect only Smile))))))))))))))))))))
DPhillips-731960
DPhillips-731960
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1262 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.
Manie Verster
Manie Verster
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1655 Visits: 1022
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.

:-PManie 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)
shashank-666535
shashank-666535
SSC Rookie
SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)

Group: General Forum Members
Points: 40 Visits: 93
Plz send me the code to analyze
shashank-666535
shashank-666535
SSC Rookie
SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)

Group: General Forum Members
Points: 40 Visits: 93
Also make sure that MDAC components are installed on the machine
Manie Verster
Manie Verster
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1655 Visits: 1022
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!

:-PManie 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)
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search