Click here to Skip to main content
15,885,278 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi,

I am using two stored procedures, one for main report and another for subreport.Below is the code.



private void LoadSalesOrderReport()
            {
               
                string Type = gvQuotationDetails.Rows[QuoteIndex].Cells["Type"].EditedFormattedValue.ToString();
                FilePath = ConfigurationManager.AppSettings["EMP_IMG_PATH"].ToString() + "\\"" + ValQuoteID.ToString() + ".pdf";
                DeleteExistingFile(FilePath);
                try
                {
                    AccountsPayableMaster objAPM = new AccountsPayableMaster();
                    QuotationReport obj = new QuotationReport();
                    objReportDocument.Load(Application.StartupPath + @"\rptQuotationReport.rpt");
                    obj.crysQuotationReport.LogOnInfo = objAPM.ConnectionDetails("SD_SalesOrderReport;1");
                    obj.crysQuotationReport.LogOnInfo = objAPM.ConnectionDetails("SD_GetBatchReportDetails;1");
                    obj.crysQuotationReport.ReportSource = objReportDocument;
                    objReportDocument.SetParameterValue("@QuoteID", ValQuoteID);
                    objReportDocument.SetParameterValue("Type","-"+ Type.ToUpper()+"-");
                    objReportDocument.SetParameterValue("@QuoteID", ValQuoteID,objReportDocument.Subreports[0].Name.ToString());                
                    string[] Print = objAPM.GetPrintDetails();
                    SetPrintParameters(objReportDocument, Print);
                    obj.Show();
                    objReportDocument.ExportToDisk(ExportFormatType.PortableDocFormat, FilePath);
    
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
    
                }
               
                OpenPdfFile();
            }


 


private void OpenPdfFile()
        {
            try
            {

                Process.Start(FilePath);
            }
            catch (Exception ex)
            {

                MessageBox.Show("Please install MicrosoftOffice/Pdf Reader to view files", "", MessageBoxButtons.OK, MessageBoxIcon.Information);

            }
           

    }



The code is working fine.But the problem is. when i click the button in front end to show the pdf directly.The crystal report form is also displayed and I know the reason as I am using **obj.Show** in my code.I tried to comment it but it throws an error.Can any one advise changes in my code to directly display the pdf and not the crystalreport form.
Posted
Updated 25-Feb-13 7:10am
v2
Comments
Sandeep Mewara 25-Feb-13 13:33pm    
What error? Always add the details of the issue you face to get quick response that helps.
Prathap Gangireddy 26-Feb-13 23:22pm    
Hi Sandeep, When I am commenting out obj.show(). It gives an error like incorrect logon parameters and when i uncomment it works fine.

1 solution

Prathap Gangireddy wrote:
Hi Sandeep, When I am commenting out obj.show(). It gives an error like incorrect logon parameters and when i uncomment it works fine.

You have to apply logon details to reports run time dynamically.
C# Crystal Reports Dynamic Logon parameters[^]
 
Share this answer
 

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900