Crystal Reports :: Using VS 2008 Unable To Use Store Procedure?
Apr 27, 2010
I have store procedure: ALTER PROCEDURE dbo.GetAllInfoFromUsers(@name varchar(50)) AS select id, userName,password, role from tbl_users where userName=@name
Then I have Report.aspx page:
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
<CR:CrystalReportViewer ID="CrystalReportViewer1" runat="server"
AutoDataBind="True" Height="1106px"
Width="876px" />
[Code]....
I have dataset (MyDataset) build out of store procedure. and I have StoreCrystalReport.rpt linked to MyDataset.
I am unable to see the filtered output in crystal report.
View 4 Replies
Similar Messages:
Mar 11, 2011
I create an ASP.NET Crystal Report Web application using VS.NET 2010. In ASP.NET page, I stored two values in Session state and need to pass them as input parameters to Oracle stored procedure. In Crystal reports 2010 once you connect to a stored-procedure as data source, it automatically creates the parameter fields with Crytal Report Viewer. how I pass values to store procedure at runtime automatically.
Detail code:
1. ASP.NET page store the values in the Session:
Sesion.Item("CourseNumber")
Sesion.Item("StudentNumber")
2. I like to pass above values to the store procedure with IN parameters named P_CourseNo and P_StudentNo to print out the Crytal Report with Store Procedure as data source.
View 3 Replies
Jul 16, 2010
I created a CR which data source is a store procedure. Within the store procedure there is one parameter. How to pass a value to the parameter and display CR on the screen?
View 1 Replies
Aug 27, 2010
Im working on Visual Studio 2008 to develop a web application in asp.net. if I add a crystal report file (.rpt) in my project, I see only hexadecimal code.
View 1 Replies
May 27, 2010
I'm working on a site that ws developed using VS 2005 and the server where the site is running has Crystal Reports for .net 2.0 (ver 10.2.36)I will be making changes. I just ported the website to my local computer, and build the site using VS 2008, that comes with Crystal R. Basic.I haven't tested all the functionality of the site, so I'm not sure since all the pages that use C. Reports work ok.My main concern is about publishing the site I compiled to the server. Will things work, if I have Crystal R. Basic and the server has Crystal R. for .net 2.0.
View 2 Replies
May 29, 2010
Runtime Error Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine. Details: To enable the details of this specific error message to be viewable on remote machines, please create a tag within a "web.config" configuration file located in the root directory of the current web application. This tag should then have its "mode" attribute set to "Off". Notes: The current error page you are seeing can be replaced by a custom error page by modifying the "defaultRedirect" attribute of the application's configuration tag to point to a custom error page URL. ----------------------------------- This error will be display when I am try to show the Crystal Report. Can anybody tell me what Property I have to ser in Windows Server 2008 R2 or in IIS7???
View 1 Replies
Dec 15, 2010
I'm struggling with this problem about 2 weeks and still cannot find the resolution.I was developed a .Net application with visual studio 2008 and using crystal report to generate report.It is working fine in my local machine. However, after I deployed the application to web server with microsoft server 2003 64bits server. The report cannot open and I get this error The type initialize or 'crystaldecisions.crystalreports.engine.reportdocument' threw an exception. I try to install the redistribution package from C:Program FilesMicrosoft SDKsWindowsv6.0ABootstrapperPackagesCrystalReports10_5 but it doesn't work.
View 1 Replies
Aug 5, 2010
When i run the application locally it works fine but when i publish it n access from it it gives the error asEither the Crystal Reports registry key permissions are insufficient or the Crystal Reports runtime is not installed correctly.
View 2 Replies
Mar 21, 2010
I need to link 2 stored procedure in crystal report, passing same parameter id, i tried but getting error
"Unable to connect: incorrect log on parameters."
in this way i'm creating report.
1) Create Dataset(myTable.xsd) in App_Code folder
2) Create a blank Crystal Report, Field Explorer getting Database Fields, from Database Expert (ADO.Dataset Objects), selecting the
myTable.xsd Dataset
3) Drag the fields in Crystal Report n Execute
View 12 Replies
Apr 4, 2010
am using a crystal report with unparameterised stored procedure (i didn't use any parameter).
but i noticed the the report keeps the data from last "Refresh report data".
View 1 Replies
Jan 24, 2011
I write some code below in FrmPrescription.aspx.cs file :
protected void btnPrint_Click(object sender, EventArgs e)
{
try
{[code]....
this code is for local print,but if crystal report has more than 1 pages in that case it will print just one page!
View 4 Replies
Oct 26, 2010
i am havin one join condition in back end and storing the result into dataset and from dataset i am unable to load data into crystal reports nothing is coming only empty report is getting displayed.
View 1 Replies
Sep 17, 2010
i am displaying some crystal reports on some pages but when the user wants to print it, the data disappears and all you see is the labels.
[Code]....
View 6 Replies
Feb 24, 2010
I ran the redistributional CRRedist2008_x86.msi on my web server, but when I try to browse my page it can't find the Crystal Reports assemblies: Could not load file or assembly 'CrystalDecisions.CrystalReports.Engine, Version=10.5.3700.0, Culture=neutral, PublicKeyToken=692fbea5521e1304'
View 3 Replies
Oct 11, 2010
I am writing a ASP.NET 4 web application running on Windows 7 Professional 64-bit and attempting to view a Crystal Reports 2008 report in the web viewer. After battling through issues with: Enabling 32-bit apps on the app pool Switching the pipeline mode of the crystalreportviewers12 folder to Classic, and Ensuring that the appropriate users have NTFS access to the windows emp folder I've finally gotten the viewer to load in the web page. However, despite the fact that the report I'm testing is tre simple, with no parameters, absolutely nothing is being displayed. This is also despite the fact that my SQL profiler shows that the correct query is being run on the database to return the data that should be showing in the report.
Thus, I am forced to ask the questions: Does Crystal Reports 2008 work on ASP.NET 4, and if so, Is there something extra I need to do to get it to work?
View 1 Replies
Mar 24, 2011
I'm working on a vb.net windows project using crystal reports for report generating.I'm using stored procedures as well.Stored procedures are used by crystal reports.When I run report with some parameters it gives error,like this " Unknown Query Engine Error ".I have checked the Stored Procedure and there is no problem with the SP, no extra parameters.
View 1 Replies
Apr 25, 2010
I have a crystal report using store procedure with DSN Name: 192.168.0.3. when I keep the connection to this server it's OK
But when i change the logon info and disconnect to the server to connect to My PC it appear the error :
"Unable to connect: Incorrect log on parameter"
[code]....
View 3 Replies
Dec 5, 2010
there is error appear when i use crystal report v13 with Visual Studio 2010 in server
Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information.
what is the reason of this exception
View 1 Replies
Dec 4, 2010
When i export crystal report (table formtatted) to excel (using in web app) and see the output than i dont get column and row lines i mean My data comes in table format but without column and row lines. Can anyone pl guide me on this? What should i do to get proper format like present in crystal report.
View 1 Replies
May 14, 2010
I have a problem that i'm sure will not be hard to fix for anyone who has been using CR for some time.
To start I have created a program in VB2008, that uses a MS Access data file, I can connect to it with no problem and can also add data and amend data, so all seems to work perfectly. I have published it and it once again runs perfectly on another/s machines.
I have now a requirement for a number of reports so have choosen CR for this purpose. I have connected the report to the database and that runs with no problems at all, that is untill I try to run it on another machine, it seems not to be able to find the database and comes up with a panel wanting me to log in with a password and Admin name.
I feel it's proberly a problem with the path of the database, I have tried so many time with diferent data files but with no success.
View 6 Replies
May 1, 2010
Is there any alternative of Crystal Reports. I dont want to use it....Crystal Reports are just useless,But I didnt get any other alternative!
View 4 Replies
Dec 7, 2010
I have a crystal report viewer on .aspx page. When the report is loaded, the report shows but toolbar not displaying, no buttons, borders or scrollbars.But with reports which open in new blank,everything's fine..the toolbar, buttons, borders and scrollbars all show perfectly.
View 3 Replies
Jan 3, 2011
I have some background in writing reports for Win32 programs using VS 2008. I now have to write a report (which will actually be a billing statement) in ASP.Net. The data for the report will be on an MSSQL server either 2005 or 2010. My question is what is the best way to access that data. I assume there are different methods for doing this. My experience is pretty much confined to ADO net, but I am open to anything that may be better
View 1 Replies
Mar 24, 2010
I have 2 parameters 1. InvoiceNum: this is array of InvoiceNumbers and 2. CompanyNickName. A single string value Now when I am passing these parameters to report only 1st record is getting displayed and not others. Ideally no. of records should be equal to no. of InvoiceNums e.g. if there are 3 invoice no. it shoudl display all 3 invoices. here is relevant code
private
void SetCurrentValuesforParameterField(
ArrayList InvoiceNumList)
ParameterFields param =
new
ParameterFields();
ParameterValues vals =
new
ParameterValues();
ParameterField parameterfield =
new
ParameterField();
foreach (object submittedValue
in InvoiceNumList)
ParameterDiscreteValue InvoiceDiscreteVal =
new
ParameterDiscreteValue();
ParameterValueKind.StringParameter; //ParameterField parameterfield1 = param[1];
parameterfield =new
ParameterField();
ParameterValueKind.StringParameter;
ParameterDiscreteValue InvoiceDiscreteVal1 =
new
ParameterDiscreteValue();
new
ParameterValues(); //
CrystalReportViewer1.ParameterFieldInfo = param;
}
vals.Add(InvoiceDiscreteVal1);
parameterfield.CurrentValues = vals;
param.Add(parameterfield);
InvoiceDiscreteVal1.Value = CompanyNickName;
vals =
parameterfield.Name = Parameter_Field_Name1;// 2nd Parameter CompanyNickName
parameterfield.ParameterValueType = parameterfield.CurrentValues = vals;
param.Add(parameterfield);
}// End of Loop
InvoiceDiscreteVal.Value = submittedValue.ToString();
vals.Add(InvoiceDiscreteVal);
parameterfield.Name = Parameter_Field_Name; //1st Paramt name InvoiceNum
parameterfield.ParameterValueType =
ParameterDiscreteValue InvoiceDiscreteVal1
new
ParameterDiscreteValue();
new
ParameterValues();
//
CrystalReportViewer1.ParameterFieldInfo = param;
}
vals.Add(InvoiceDiscreteVal1);
parameterfield.CurrentValues = vals;
param.Add(parameterfield);
InvoiceDiscreteVal1.Value = CompanyNickName;
vals =
new
ParameterValues();
//
CrystalReportViewer1.ParameterFieldInfo = param;
}
vals.Add(InvoiceDiscreteVal1);
parameterfield.CurrentValues = vals;
param.Add(parameterfield);
View 1 Replies
Oct 28, 2010
I have designed a report for printing cards and am able to print it on my local machine but when i upload on the server, i can preview the report but when i click print through a pdf its coming out blank.
View 1 Replies
