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


SSRS In a Flash


SSRS In a Flash

Author
Message
Prasad Gulavani
Prasad Gulavani
Grasshopper
Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)

Group: General Forum Members
Points: 11 Visits: 11
I agree too! Well written indeed. Waiting for the next. Smile
kaushal_shah26
kaushal_shah26
SSC Rookie
SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)

Group: General Forum Members
Points: 26 Visits: 30
Very good introduction. I am looking forward to learn basics and then advances options like creating chart, grahphs , automatic emails to user, scheduling etc... Can't wait for the next article.
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (85K reputation)SSC Guru (85K reputation)SSC Guru (85K reputation)SSC Guru (85K reputation)SSC Guru (85K reputation)SSC Guru (85K reputation)SSC Guru (85K reputation)SSC Guru (85K reputation)

Group: General Forum Members
Points: 85186 Visits: 41077
Canned meat reported. ;-)

--Jeff Moden

RBAR is pronounced ree-bar and is a Modenism for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
raranchado
raranchado
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 5
Good article to start learning the basics.

As an underpaid IT person who ended up managing sql server and database instead of just the application, I realized that the third party data mining application is not enough to fulfill some of the reports needed by our users. Just started learning SSRS and loving it. Can't wait to read the rest of this series. Thank you for sharing.
timc_fla
timc_fla
Forum Newbie
Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)

Group: General Forum Members
Points: 8 Visits: 13
None of us are perfect.
we all make mistakes and some are worse than others.

So.....Jessica you will be flogged with a wet noodle!

you must, must, must, must always reference what software and what specific version of the software and platform you are talking about!!!!
don't make me do stupid investigative searches to find out what version your are talking about.
from a screen shot in Level 2 it appears you are talking about SQL Server 2008 R2 on a Win 7 platform.
I can't tell if you are using the 32bit or 64bit version, it shouldn't matter, but sometimes it does depending on what you're doing.

Other than that, I can't wait to go through your articles.

Thank you for taking the time to write and publish them.
peter.row
peter.row
SSC-Addicted
SSC-Addicted (487 reputation)SSC-Addicted (487 reputation)SSC-Addicted (487 reputation)SSC-Addicted (487 reputation)SSC-Addicted (487 reputation)SSC-Addicted (487 reputation)SSC-Addicted (487 reputation)SSC-Addicted (487 reputation)

Group: General Forum Members
Points: 487 Visits: 405
All of this is all well and good until you try to use it like:

  • Use custom authentication so you can use it on a web app across the internet

  • Use the report builder to make simple master/child details

  • MS made a school boy implementation error with Report builder where it doesn't close connections when it's done with them meaning you crash it fairly easily. We used some of our MS partner support time to get a workaround figured out whereby you can extend the max connections from 1 to a maximum of 1024 so you can delay the crash for a while

  • Have report parameters that show a list of options obtained from the database alphabetically ordered



...it is such hard work.
The custom authentication is a massive headache. There are not many resources online about the configuration required. There is no UI whatsoever to do this you have to do it all by hand changing XML files where one wrong character can screw you over.

MS has depreciated report models in SSRS 2012 so pretty screwed if you are using them once 2008 R2 is dropped from MS support.

Creating a simple report that shows a master line, several details rows, master line, several details rows which takes 5 minutes in something like MS Access after writing the query is only possible with a sub report that has it's own dataset in SSRS - i.e. a lot more work - at least using report builder - which given the context of a self-surface web app is the only option.

Think very carefully about your requirements before integrating this into your product. I for one would love to rip it out and not use it - we only used it because we were using SQL Server for the data storage so we already had it - hindsight, sweet hindsight - if only I could have seen the future.
j-1064772
j-1064772
Say Hey Kid
Say Hey Kid (661 reputation)Say Hey Kid (661 reputation)Say Hey Kid (661 reputation)Say Hey Kid (661 reputation)Say Hey Kid (661 reputation)Say Hey Kid (661 reputation)Say Hey Kid (661 reputation)Say Hey Kid (661 reputation)

Group: General Forum Members
Points: 661 Visits: 1207
This looks promising. Looking forward for more.

What are your plans ?

Visual Studio 2008 or the SSRS report builder ?

Will you use SQL Server datasets or use FetchXML ? FetchXML did not impress me too much last year when I found out it could not support what I could do easily in T-SQL:

SELECT AccountIdName, SUM(TotalAmount_Base) AS AccountTotal FROM Invoice GROUP BY AccoountIdName



A thing to note: caution is required using T-SQL and directly refering to tables instead of views. In its wisdom, for CRM 2013, MS dumped the idea of creating ...ExtensionBase tables when new fields are created with the CRM environment. All custom fields are now added to the ...Base tables. Which means migrating my T-SQL-based reports from CRM 2011 to CRM 2013 I will have to rewrite my T-SQL so stop looking for ...ExtensionBase tables.

I did not like too much using the Views automatically constructed by the CRM environment, each view returning typically 100 columns when I select only a half-dozen. Not familiar enough with the inner workings of SQL Server to determine whether or not the remaining 94 columns still end-up as dead weight overhead even if not selected.
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