I am having problem with incorporating crystal report in ASPX page. I have to print an invoice and that has to be either through PDF file or through Crystal Report. I am having following problems while extracting the fields from database>>
a) I am using push method for Crystal Report.
b) I created a dataset1.xsd with an existing stored procedure (Steps>>Right Click on Solution>>Add>>new item>>Dataset)
c) When I try to create a report and try to access that Stored procedure that I selected in dataset1.xsd from crystalReport1.rpt (the steps I am taking are right-click on details on CrystalReport1.rpt form >>add/remove database>>Project data etc, etc), I dont see any object there under dataset1.
It seems to me that Crystal Report only works with table object not with the stored procedure (or I am making some mistakes somewhere).
If anybody can help me with a sample piece of code regarding how I can create a crystal report (which will be used in a web page (ex: PrintInvoice.aspx)) using the stored procedure given by our DBA and finally export it to a PDF format (or any printable format from client machine) I will really appreciate that.
Thank all of you in advance.
a) I am using push method for Crystal Report.
b) I created a dataset1.xsd with an existing stored procedure (Steps>>Right Click on Solution>>Add>>new item>>Dataset)
c) When I try to create a report and try to access that Stored procedure that I selected in dataset1.xsd from crystalReport1.rpt (the steps I am taking are right-click on details on CrystalReport1.rpt form >>add/remove database>>Project data etc, etc), I dont see any object there under dataset1.
It seems to me that Crystal Report only works with table object not with the stored procedure (or I am making some mistakes somewhere).
If anybody can help me with a sample piece of code regarding how I can create a crystal report (which will be used in a web page (ex: PrintInvoice.aspx)) using the stored procedure given by our DBA and finally export it to a PDF format (or any printable format from client machine) I will really appreciate that.
Thank all of you in advance.