Click here to Skip to main content
15,884,472 members
Home / Discussions / ASP.NET
   

ASP.NET

 
GeneralRe: Impement AJAX, Pin
codelinks9-Jul-08 4:40
codelinks9-Jul-08 4:40 
GeneralRe: Impement AJAX, Pin
Christian Graus9-Jul-08 4:48
protectorChristian Graus9-Jul-08 4:48 
GeneralRe: Impement AJAX, Pin
codelinks9-Jul-08 4:55
codelinks9-Jul-08 4:55 
GeneralRe: Impement AJAX, Pin
Christian Graus9-Jul-08 5:04
protectorChristian Graus9-Jul-08 5:04 
AnswerRe: Impement AJAX, Pin
codelinks9-Jul-08 5:10
codelinks9-Jul-08 5:10 
QuestionLogout > Back Button in Browser Pin
butchzn9-Jul-08 4:23
butchzn9-Jul-08 4:23 
AnswerRe: Logout > Back Button in Browser Pin
Christian Graus9-Jul-08 4:33
protectorChristian Graus9-Jul-08 4:33 
QuestionSetParameterValue Not passing parameters to the SP Pin
allende9-Jul-08 4:14
allende9-Jul-08 4:14 
HI friends, this question is regarding Crystal Reports in VS 2005

My report here is attached to a SP. I'm trying to pass parameters but it raises an error:

Procedure or function 'sp_wfsAppByCounsReport' expects parameter '@StartingDate', which was not supplied.

Here is my code, I'm passing the parameter. I can even trace it and the rdDocument variable has them attached after the SetParameteValue....why the report is not sending them to the SP???

Here is my code:

protected void Page_Load(object sender, EventArgs e)
{
    DateTime dtStartingDate =  DateTime.Parse(DateTime.Today.Month.ToString() + "/" + "1" + "/" + DateTime.Today.Year.ToString());

    ConnectionInfo ciLogin = new ConnectionInfo();
    ciLogin.ServerName = "myserver.com";
    ciLogin.DatabaseName = "mydb";
    ciLogin.UserID = "dbuser";
    ciLogin.Password = "mypass";
    TableLogOnInfo tbLogonTable = new TableLogOnInfo();
    tbLogonTable.ConnectionInfo = ciLogin;

    ReportDocument rdMonthReport = new ReportDocument();
    rdMonthReport.Load(Server.MapPath("couns-month.rpt"));
    rdMonthReport.SetParameterValue("@StartingDate", dtStartingDate);
    rdMonthReport.SetParameterValue("@EndingDate", DateTime.Today);

    foreach (CrystalDecisions.CrystalReports.Engine.Table tbTable in rdMonthReport.Database.Tables)
    {
        tbTable.ApplyLogOnInfo(tbLogonTable);
    }
    CrystalReportViewer.ReportSource = rdMonthReport;
    CrystalReportViewer.RefreshReport();
}



Any help is appreciated!!
AnswerRe: SetParameterValue Not passing parameters to the SP Pin
Christian Graus9-Jul-08 4:16
protectorChristian Graus9-Jul-08 4:16 
GeneralRe: SetParameterValue Not passing parameters to the SP Pin
allende9-Jul-08 4:23
allende9-Jul-08 4:23 
QuestionStop Timer Plz Pin
Member 34356149-Jul-08 3:29
Member 34356149-Jul-08 3:29 
AnswerRe: Stop Timer Plz Pin
Christian Graus9-Jul-08 3:44
protectorChristian Graus9-Jul-08 3:44 
AnswerRe: Stop Timer Plz Pin
eyeseetee9-Jul-08 4:36
eyeseetee9-Jul-08 4:36 
GeneralRe: Stop Timer Plz Pin
Christian Graus9-Jul-08 4:53
protectorChristian Graus9-Jul-08 4:53 
GeneralRe: Stop Timer Plz Pin
Member 34356149-Jul-08 19:03
Member 34356149-Jul-08 19:03 
QuestionRegarding ASP.Net AJAX Pin
dhanunjaya219-Jul-08 3:20
dhanunjaya219-Jul-08 3:20 
AnswerRe: Regarding ASP.Net AJAX Pin
Christian Graus9-Jul-08 3:46
protectorChristian Graus9-Jul-08 3:46 
QuestionMerging onClick events in ASP.net Pin
imnotso#9-Jul-08 3:19
imnotso#9-Jul-08 3:19 
Questioncombo box -- ddl Pin
trilokharry9-Jul-08 2:44
trilokharry9-Jul-08 2:44 
AnswerRe: combo box -- ddl Pin
Imran Khan Pathan9-Jul-08 2:51
Imran Khan Pathan9-Jul-08 2:51 
QuestionMaster to Content page Pin
Agweet9-Jul-08 2:07
Agweet9-Jul-08 2:07 
AnswerRe: Master to Content page Pin
eyeseetee9-Jul-08 2:55
eyeseetee9-Jul-08 2:55 
GeneralRe: Master to Content page Pin
Agweet9-Jul-08 3:01
Agweet9-Jul-08 3:01 
Questionmasterpage+js Pin
niki_nilu9-Jul-08 1:47
niki_nilu9-Jul-08 1:47 
AnswerRe: masterpage+js Pin
eyeseetee9-Jul-08 2:56
eyeseetee9-Jul-08 2:56 

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.