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


Tutorial: Designing Your First Report in SQL Server Reporting Services


Tutorial: Designing Your First Report in SQL Server Reporting Services

Author
Message
Brian Knight
Brian Knight
SSCertifiable
SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)

Group: Moderators
Points: 5391 Visits: 235
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com

Brian Knight
Free SQL Server Training Webinars
Chris Stamey
Chris Stamey
SSC-Addicted
SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)

Group: General Forum Members
Points: 491 Visits: 29

I went through this tutorial, and while everything went smoothly through most of the article, at the end, when I deployed the report, it fell down. It does not want to use the Windows Authentication I chose, I get an error opeing the report; and I did not get the pretty interface to navigate to the report like the one pictured, but cannot figure out what's different between my environment and the article's.

I'd like to know if these issues can be helped now, or will be addressed in a subsequent article.

Thanks,
Chris


Brian Knight
Brian Knight
SSCertifiable
SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)

Group: Moderators
Points: 5391 Visits: 235
THe pretty interface you're referring to can be accessed at http://reportservername/reports. What are you viewing the report in that causes an authentication error?

Brian Knight
Free SQL Server Training Webinars
Chris Stamey
Chris Stamey
SSC-Addicted
SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)

Group: General Forum Members
Points: 491 Visits: 29

It seems that Reports Server can't use Windows Authentication, because Reports Server appears to pass it the authentication for the web server, not the authentication from the IE user hitting the site. If I use the "The credentials supplied by the user running the report" option, I cna specify a user ID and PW when runnign the report. I had hoped to use "Windows NT Integrated Security" and, since this is an Intranet site, added to my Intranet sites list in IE, have IE pass my NT login info to the web server and it pass that info to the SQL Server for seemless authentication. I guess this is a little too much to expect though, but we can put a man on the moon....

I did find the other area you spoke of, with the pretty interface and report menu. This does look like it may be a useful tool, once I learn more about it and can articulate its usefulness and features to others in my organization. I will have to figure out a better authentication method though, but I hate to go with SQL standard security.

Thanks
Chris


Kevin Jones
Kevin Jones
SSC Rookie
SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)

Group: General Forum Members
Points: 30 Visits: 3

Forgive me for being thick, but where/how can I get the client component?

I have a CD for Reporting Services (from the Microsoft Action Pack) and have installed on my server to try it out. But I haven't found anything anywhere for installing a client component. I also looked at the link in the article which is for a trial version. Since I have a CD, I don't know if that'll help.

Please, a simple answer for a simple person

Kevin


Tim Coker
Tim Coker
Old Hand
Old Hand (325 reputation)Old Hand (325 reputation)Old Hand (325 reputation)Old Hand (325 reputation)Old Hand (325 reputation)Old Hand (325 reputation)Old Hand (325 reputation)Old Hand (325 reputation)

Group: General Forum Members
Points: 325 Visits: 34
It should be on the cd for reporting services. Pop the cd you have in your dev box and try it. It should ask you what you want to install (client or server software). Calling it the client component is a little misleading, though, since almost any software/machine can be a client for reporting services in the sense of viewing reports. A better name would probably be the development component or client or whatever.
Angela Henry
Angela Henry
SSC-Addicted
SSC-Addicted (458 reputation)SSC-Addicted (458 reputation)SSC-Addicted (458 reputation)SSC-Addicted (458 reputation)SSC-Addicted (458 reputation)SSC-Addicted (458 reputation)SSC-Addicted (458 reputation)SSC-Addicted (458 reputation)

Group: General Forum Members
Points: 458 Visits: 285

I thought this was a great start. I took it and made some slight modifications to include the run duration and the start time for each job. Then I created a subscription to email me every morning so I don't have to go out and look at every one of my servers every morning, I just have to check my email.

Thanks for putting this out there.


keskinserkan
keskinserkan
Forum Newbie
Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: General Forum Members
Points: 9 Visits: 148
if you run the job two times a day the job is listed two times with that SQL

but if you change the SQL like this "using max instance_id instead of Run_date" all jabs listed one time

select
distinct
j.Name as "Job Name",
j.job_id,
j.enabled,
j.category_id,
j.description as "Job Description",
h.run_date as LastStatusDate,
case h.run_status
when 0 then 'Failed'
when 1 then 'Successful'
when 3 then 'Cancelled'
when 4 then 'In Progress'
end as JobStatus
from
sysJobHistory h with (nolock),
sysJobs j with (nolock)
where
j.job_id = h.job_id
and h.instance_id = (select max(hi.instance_id) from sysJobHistory hi where h.job_id = hi.job_id)
order by j.Name
Shabba
Shabba
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1239 Visits: 1846
Many Thanks Brian for a very informative article for someone who is only now beginning to dabble in SSRS.

I have a question...

Let's say I want to run this report against all SQL instances within our environment how would I go about configuring the Data Sources? Do I really need a data source for each instance?

Many Thanks,
Mark
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