Crystal Report Login Error

Question

0.00/5 (No votes)

See more:

Hi Friends,

There is a login problem in my CRV(Crystal Reports Viewer).

The first time the crystal reports open it works completely OK.
But, when I go onto second page of crystal reports it shows Database login dialog.

I try to set property EnableDatabaseLogin to false but it not work properly.

I need also one help from you:-
Can you give how to display crystal reports large reports in crystal reports?

Can we apply any css for it?

thanks and regards,
Chirag :rose:

Posted 30-Oct-10 18:38pm

dexters007

Updated 1-Nov-10 22:31pm

Dalek Dave

v2

Add a Solution

Comments

Dalek Dave 2-Nov-10 4:30am

Edited for Grammar and Syntax.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

sbeeMac · Answer 1 · 2010-11-01T21:25:00

Hi there, i had the same problem this how i managed to solve it. Pay attention to the first DataSet(getRpt) and how it is used within the following events 1.Page_init;2.Page_Load;3.CrystalReportViewr_Page_Init;4.CrystalReportViewrNavigate heres my Full code

MSIL

DataSet getRpt()
      {
              CrystalReport2 myRpt = new CrystalReport2();
              string myConstr = ConfigurationManager.AppSettings["ConnectionString"];
              SqlConnection myConnection = new SqlConnection(myConstr);
              SqlDataAdapter myAdapter = new SqlDataAdapter();
              DataSet3 myDataSet = new DataSet3();
              SqlCommand MyCommand = myConnection.CreateCommand();
          try
          {

              CrystalReportViewer1.DisplayGroupTree = false;
              CrystalReportViewer1.DisplayToolbar = true;

              MyCommand.CommandText = "ProcNamet";
              MyCommand.CommandType = CommandType.StoredProcedure;
              myAdapter.SelectCommand = MyCommand;

              myAdapter.SelectCommand.Parameters.Add(new SqlParameter("@myPara1",Convert.ToInt32(txtDays.Text)));
              myAdapter.SelectCommand.Parameters.Add(new SqlParameter("@myPara2", Convert.ToString(DropDownList1.SelectedValue)));
              myAdapter.SelectCommand.Parameters.Add(new SqlParameter("@myPara3", Convert.ToString(DropDownList2.SelectedValue)));

              myAdapter.Fill(myDataSet, "ProcName");
              myRpt.SetDataSource(myDataSet);
              CrystalReportViewer1.ReportSource = myRpt;
          }

          catch (Exception ex)
          {
              string strEX;
              strEX = ex.ToString();
          }
          return myDataSet;

      }

      private void Page_Init(object sender, EventArgs e)
      {
          if (!IsPostBack)
          {
              DataSet myD = getRpt();
          }
      }

      protected void Page_Load(object sender, EventArgs e)
      {
         if (!IsPostBack)
         {
             DataSet myD = getRpt();
         }
       
      }
      protected void btnPreview_Click(object sender, EventArgs e)
      {


          if (!IsPostBack)
          {
              DataSet myD = getRpt();

          }
      }

      protected void CrystalReportViewer1_Init(object sender, EventArgs e)
      {
          if (!IsPostBack)
          {
              DataSet myD = getRpt();
          }
      }

      protected void CrystalReportViewer1_Navigate(object source, CrystalDecisions.Web.NavigateEventArgs e)
      {
          if (!IsPostBack)
          {
              DataSet myD = getRpt();
          }
      }