June 10, 2011 at 9:00 am
Hi,
I am new to the forum and new to SSRS. I do have business requirements to develop custom reports using SSRS but i have no idea how to write TSQL for business logic to build a report are there any free tools which help me in either generating SQL or TSQL queries which i can use. Or is there anyone available to help me. All the help would be greatly appreciated.
thanks
June 14, 2011 at 12:16 pm
Hi and welcome to SSC!. Reports can frequently be some of the most complicated queries. Sounds like you are new to sql? I don't know that diving straight into SSRS is the best way to learn sql but it sounds like you need to do some serious reading before you can even really get started. As long as you don't have really short time demands and you have a desire there is tons of useful information to be discovered just browsing the forums on here. As for your reports, the question of how do I create the sql to create my report is entirely too vague to have even a chance of producing anything useful. If you have specific requirements there are tons of people on here willing and able to help. Please see the link in my signature for best practices on asking your questions in such a way as to maximize the possibility of getting the desired result.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
June 15, 2011 at 8:52 am
Hi - I'm pretty new too, so others may have more experienced suggestions. But what I have found most helpful for coding business logic so far has been the use of Case Statements. You should be able to come up with info about them by googling that or looking it up on the SQL Books Online.
Good luck!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply