Click here to Skip to main content
15,890,579 members
Home / Discussions / Database
   

Database

 
AnswerRe: what is er of codeproject.com Pin
S Douglas28-Apr-11 10:48
professionalS Douglas28-Apr-11 10:48 
QuestionApostrophe in Stored Procedure Pin
berba13-Apr-11 21:20
berba13-Apr-11 21:20 
AnswerRepost warning Pin
Peter_in_278013-Apr-11 21:37
professionalPeter_in_278013-Apr-11 21:37 
QuestionGenerate Alpha Numeric no in sql server Pin
sumit703413-Apr-11 19:20
sumit703413-Apr-11 19:20 
AnswerRe: Generate Alpha Numeric no in sql server Pin
Johan Hakkesteegt14-Apr-11 1:57
Johan Hakkesteegt14-Apr-11 1:57 
AnswerRe: Generate Alpha Numeric no in sql server Pin
Wendelius14-Apr-11 8:51
mentorWendelius14-Apr-11 8:51 
AnswerRe: Generate Alpha Numeric no in sql server Pin
Prasanta_Prince15-Apr-11 0:34
Prasanta_Prince15-Apr-11 0:34 
QuestionStill Can't Get SSRS To Work Pin
Kevin Marois13-Apr-11 5:20
professionalKevin Marois13-Apr-11 5:20 
I'm trying to display an SSRS report in a ReportViewer control in a WinForms application. Here's the Form_Load...

private void Form1_Load(object sender, EventArgs e)
{
    reportViewer1.ServerReport.ReportServerUrl = new Uri("http://192.168.2.5/reportserver");
    reportViewer1.ServerReport.ReportServerCredentials.NetworkCredentials = CredentialCache.DefaultCredentials;

    string reportFile = @"C:\Report Project1\Report1.rdl";
    reportViewer1.ServerReport.ReportPath = reportFile;
    reportViewer1.ProcessingMode = ProcessingMode.Remote;

    reportViewer1.ServerReport.DisplayName = "Corporate View Report";

    ReportParameter[] parameters = new ReportParameter[3];
    parameters[0] = new ReportParameter("@ProjectId", "6");
    parameters[1] = new ReportParameter("@PrimaryWhseId", "8293");
    parameters[2] = new ReportParameter("@SecondaryWhseId", "8290");
    reportViewer1.ServerReport.SetParameters(parameters);

    try
    {
        reportViewer1.RefreshReport();
    }
    catch(Exception ex)
    {
        throw ex;
    }
}


With the reportViewer1.ServerReport.SetParameters(parameters); line uncommented, at this point the form pops ups, the repot is blank, and nothing else happens after that.

If I comment out the parameters and run it the form runs and in the viewer control I get "The request failed with HTTP status 401: Unauthorized".

I can't find any examples of displaying a SSRS report in a WinForms application.

I could really use some help here.

Thanks
Everything makes sense in someone's mind

AnswerRe: Still Can't Get SSRS To Work Pin
thatraja13-Apr-11 17:25
professionalthatraja13-Apr-11 17:25 
GeneralORA-00603: ORACLE server session terminated by fatal error Pin
Ish Kapila13-Apr-11 4:59
Ish Kapila13-Apr-11 4:59 
GeneralRe: ORA-00603: ORACLE server session terminated by fatal error Pin
Wendelius13-Apr-11 5:09
mentorWendelius13-Apr-11 5:09 
GeneralRe: ORA-00603: ORACLE server session terminated by fatal error Pin
Ish Kapila13-Apr-11 5:17
Ish Kapila13-Apr-11 5:17 
GeneralRe: ORA-00603: ORACLE server session terminated by fatal error Pin
Wendelius13-Apr-11 5:24
mentorWendelius13-Apr-11 5:24 
GeneralRe: ORA-00603: ORACLE server session terminated by fatal error Pin
Ish Kapila13-Apr-11 7:09
Ish Kapila13-Apr-11 7:09 
QuestionRe: ORA-00603: ORACLE server session terminated by fatal error Pin
Jörgen Andersson13-Apr-11 7:30
professionalJörgen Andersson13-Apr-11 7:30 
AnswerRe: ORA-00603: ORACLE server session terminated by fatal error Pin
Ish Kapila13-Apr-11 7:42
Ish Kapila13-Apr-11 7:42 
GeneralRe: ORA-00603: ORACLE server session terminated by fatal error Pin
Wendelius13-Apr-11 7:42
mentorWendelius13-Apr-11 7:42 
GeneralRe: ORA-00603: ORACLE server session terminated by fatal error Pin
Ish Kapila13-Apr-11 8:00
Ish Kapila13-Apr-11 8:00 
GeneralRe: ORA-00603: ORACLE server session terminated by fatal error Pin
Wendelius13-Apr-11 8:12
mentorWendelius13-Apr-11 8:12 
GeneralRe: ORA-00603: ORACLE server session terminated by fatal error [modified] Pin
Klaus-Werner Konrad13-Apr-11 12:03
Klaus-Werner Konrad13-Apr-11 12:03 
QuestionSQL Server ASPState Blocking under high load Pin
MecAlex13-Apr-11 4:57
MecAlex13-Apr-11 4:57 
AnswerRe: SQL Server ASPState Blocking under high load Pin
Wendelius13-Apr-11 5:07
mentorWendelius13-Apr-11 5:07 
GeneralRe: SQL Server ASPState Blocking under high load Pin
MecAlex13-Apr-11 5:28
MecAlex13-Apr-11 5:28 
GeneralRe: SQL Server ASPState Blocking under high load Pin
Wendelius13-Apr-11 5:34
mentorWendelius13-Apr-11 5:34 
AnswerRe: SQL Server ASPState Blocking under high load [modified] Pin
MecAlex14-Apr-11 22:34
MecAlex14-Apr-11 22:34 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.