Use Query Created In Sql Server For Crystal Report?
Nov 10, 2010
using vs.net 2005.I have a console application that is displaying a Crystal Report.I want to use a query that I created in sql server mgmt for the data in Crystal reports.some questions:
1. how do I do this?
2. Is is more efficient to do this with stored proc or just enter the query?
3. There are some fields where I need a case statement because so that I can display meaningful text (not the code values that are returned), is it normally more efficient to put the case statement in the SQL or to add logic in the report for this?
View 1 Replies
Similar Messages:
Mar 17, 2010
a myth has been passed to me by a senior who told me to 'always' design a crystal report using Add command and not through the table view (like selecting tables and linking them manually).I have been having a hard time writing the queries for master detail reports and making sub report links manually. It gets pretty confusing sometimes.I find it easy to design reports by just selecting two tables and dragging and dropping the link in crystal report designer.
View 1 Replies
Nov 1, 2010
Does anyone know how to pass values from adynamically created gridview checkboxes to a crystal report?Is it possible? I am using asp.net, vb.net and mssql. Here's my grid minus a few boundfields:
<asp:gridview id="grid" runat="server" autogeneratecolumns="False" cellpadding="4"
forecolor="#333333" gridlines="None" emptydatatext="No Products registered for this company...">
<RowStyle BackColor="#EFF3FB" />
<Columns>
<asp:TemplateField HeaderText="Select">
<ItemTemplate>
<asp:CheckBox ID="chkSelect" runat="server" onclick="javascript:HighlightRow(this);" AutoPostBack="True"/>
</ItemTemplate>
<HeaderTemplate>
<input id="chkAll" onclick="javascript:SelectAllCheckboxes(this);" runat="server" type="checkbox" />
</HeaderTemplate>
</asp:TemplateField>
<asp:BoundField DataField="aid#" HeaderText="AID#" />
<asp:BoundField DataField="brandname" HeaderText="Brand Name" />
<asp:BoundField DataField="exp_date" DataFormatString="{0:MM/dd/yyyy}" HeaderText="Exp. Date" />
</Columns>
</asp:gridview>
View 1 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
Nov 9, 2010
to print a crystal report from the server's printer with a button on the web application.Assume that I have a ASP .NET Web Application, When i press the "print" button on the web application, the server which holds the web application prints the specific crystal report with specific data set. Is this possible? How I am going to make this happened?I am sorry to say that I'm very new to all these web programming,
View 3 Replies
Jun 22, 2010
I installed Visual Web develperTrying to get a crystal report to show in the form but therte are no Crystal obhject to select Installed Visual Studio 2008 I can add an Item for Crystal now in form show the form and I see it has menu bar for crystal viewer and I see the report Now if I move the webpage to our server which has IIS 7.0, ASP.net 3.5 what else do I need to install on the server so it wil show the crystal report in the form?
View 5 Replies
May 17, 2010
By right clicking on my database i created a query in server explorer. But where are this query stored can't find them back. I should aspect that their is a folder query's like there is a folder tables but this isn't the case.
View 10 Replies
Sep 17, 2010
I am getting below error while generating report using crystal report:
Error in File C:WindowsTEMP
epEnquiry {095737EB-07B4-437D-9E86-85780B7417B0}.rpt:
Access to report file denied. Another program may be using it.
For this i did google and found some solutions but still its not working:
what i tried:
-given full access to aspnet and network services on my root directory and reports folder and then restarted iis.
OS:windows server 2008(64)
vs2008 application.
but still getting same error.
View 1 Replies
Feb 15, 2010
we have an application in ASP and Crystal Report design in Segate Crystal Report 7 in the same application. We are running this application on Windows 2000 advanced server web server, its running fine as well as the Reports. The problem arise when we host this application from Windows 2003 web server. The application run fine but the Reports does not run, giving data source error messgae
View 1 Replies
Mar 9, 2011
How Can I Install CRredist.Msi Package on Web Server, I Am Facing Problem Of Hosting ap.net Application With Crystal Report. I Have Gone Through all Post and Tutorial at MSDN and asp.Net Please Help Me To Install Crystal Report Runtime on web Server.
View 2 Replies
Feb 28, 2011
I have an vb 2005 asp application that will show a crystal report based upon a user selection which is a job number.On my development machine all work fine and the report is being shown every time.When I publish the application the web server it works for most part. Every so often for selected job numbers the report that will not display. When this happens there is a text being displayed above the business object banner:The Report Application Server failed I have checked the event log and there is no entries. Also there is no stack trace. The application seems to complete normally. I have compared the registry entries in HKEY_LOCAL_MACHINESOFTWARECrystal Decisions and they are the same id evelopment and production. I am referencingCrystalDecisions.CrystalReports.Engine version11.5.3700.0I am clueless and hoping that someone could suggest where to start looking
View 2 Replies
Dec 16, 2010
I am retrieving connection string based on value stored in cookie.NowI am making crystal report. I cannot hard code server credential. I have to get these credential from connection string from web.config. so that i can pass these credentials to my crystal report .
ConnectionInfo reportConnectionInfo = new ConnectionInfo();
reportConnectionInfo.ServerName = connection string server name from web.config
reportConnectionInfo.DatabaseName = connection string database name from web.config
reportConnectionInfo.UserID = ...;
reportConnectionInfo.Password = ...;
View 1 Replies
Feb 6, 2011
i hv use a crystal report in my web application if i publish my application and run in iis on different system with diff server name the crystal report part cause problem login failed with server as name is alredy defined in crystal report at publish time.Can we define the name of server for crystal report in web.config.
View 5 Replies
Dec 20, 2010
I have 3 tables where i need to retrieve records. Please consider the following scenario:
MtblPaymentTerms
CCode TERM Amt
CC001 50% on signing 10000
CC001 20% on submission of report 4000
CC001 20% on submission of draft 4000
CC001 10% on final report submission 1000
MtblInvoice
CCode INv_No InvAmt InvDate
CC001 INV-001 15000 20/12/2010
MtblReceipt
CCode Receipt_No Receipt_Amt InvAmt Balance
CC001 R001 10000 15000 5000 (InvAmt - Receipt_Amt)
My project requires to generate a report, wherein the user selects the ccode from the drop down list, and a report as given below is generated:-
CCode TERM Amt INV_No InvAmt Receipt_No Receipt_Amt
CC001 50% on signing 10000 INV-001 15000 R001 10000
CC001 20% on submission of report 4000
CC001 20% on submission of draft 4000
CC001 10% on final report submission 1000
generating a SQL query for this report?
View 18 Replies
Jun 22, 2012
I have deployed ASP.net WebSite on Remote Server ....
It gives the Following Error when i tested by typing URL in IE ....
(The URL is college.desiresoftech.com)
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately. Parser Error Message: Could not load file or assembly 'CrystalDecisions.ReportAppServer.ClientDoc, Version=10.5.3700.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' or one of its dependencies. The system cannot find the file specified.Source Error:
[Code] ....
WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLMSoftwareMicrosoftFusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLMSoftwareMicrosoftFusion!EnableLog].
How can I solve it, i searched on net and the answer was server has no cr Runtime, install CR Runtime on server or Copy the .dll Files in Bin Folder, I downloaded the 10.5.3700.0 CR Runtime bt it is giving error when i try to install it...
View 1 Replies
Sep 19, 2012
I have created 1 report in my web site (EmployeeDetail.rpt) using inbuild crystal report .
Now I wanted to display image of respective employee(s) according to selection(department wise)
I tried everything but it did not work.
(I have uploaded and stored images on server in EmpImages directory empID wise)
How to achieve this ?
View 1 Replies
Oct 23, 2012
LinkButton lnkHistory = (LinkButton)sender;
int ID = Convert.ToInt32(lnkHistory.CommandArgument);
ReportDocument rp;
DataSet ds = new DataSet();
SqlConnection con = new
[Code] .....
View 1 Replies
Jan 27, 2011
This group section cannot be printed because its condition field is nonexistent or invalid. Format the section to choose another condition field. Error in File Detailed_CrystalReport {9C8154B9-5093-457C-9E6A-2A1D63E7E866}.rpt: Invalid group condition.
without group section report can correctly show report and with group section can correctly show in local computer only with visual studio But with group section has error after deploy to new machine window server 2008 group section is date my crystal report version is 2008, assembly version 12, CRDist x64
try 1: i try to delete the group date and run local, it can correctly show date, but deploy to the new machine date is invisible Group date is wrong the date have only 01/25/2011 however group date become 23/1/2011 why group date is not 01/25/2011?
View 1 Replies
Jul 17, 2015
Web hosting provider has set the .net trust level as Medium. so report viewer & crystal reports are not working. it required full trust.so is it possible to execute the reports in medium trust? and how?
ReportDoc.Load(Server.MapPath("~/Reports/Proposal.rpt"));
DataTable dt = cm.DisplayUserInfo("select * from tblProposal_Master where proposal_id='000006'").Tables[0];
ReportDoc.SetDataSource(dt);
CRV.ReportSource = ReportDoc;
CRV.DataBind();
View 1 Replies
Feb 9, 2011
<connectionStrings>
<add name="SchoolEntities" connectionString="metadata=res://*/SchoolModel.csdl|res://*/SchoolModel.ssdl|res://*/SchoolModel.msl;provider=System.Data.SqlClient;provider connection string="Data Source=.;Initial Catalog=school;User
ID=sa;MultipleActiveResultSets=True"" providerName="System.Data.EntityClient"/>
</connectionStrings>
how report read this connection string
View 2 Replies
Nov 10, 2010
using vs.net 2005, sql server 2005, creating windows form appI have a dataset that I bound to a crystal report as follows:
[Code]....
and in the Crystal Report in design view I added a Text Object called "myTxtObj".I am assuming that I can do something like this
[Code]....
However I'm not seeing the "myTextObj" with intellisense in the code behind in the form.so my question is: after binding a dataset to a report how to you bind column values to text objects on your crystal report?and actually one mor thing:I just ran the project and found out when I try to do the databind that i'm getting an error:"The report has no tables"how to solve this too?
View 1 Replies
Jul 23, 2010
I got a code from internet for creating Crystal reports in Visual studio 2008 .net. It shows on how to pass parameters from web form to Crystal reports. Everything is ok, except the report crystal report viewer. How can I declare and assign report crystal report viewer manually in Visual studio .net?.
[Code]....
View 9 Replies
Feb 24, 2014
Is it possible to show 3 "Crystal Report" in single "Report Viewer Control" page??My current code for 1 Crystal Report and 1 Report Viewer control Page is below:Below code Page name is "JpsCrystalReport.aspx"
using CrystalDecisions.CrystalReports.Engine; //for crystal report
using CrystalDecisions.ReportSource;
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["SQLConnectionString"].ConnectionString);
[code]...
I want that when i click on button it redirects to "JpsCrystalReport.aspx" page as per condition given. Then on "JpsCrystalReport.aspx" page it should execute the 3 crystal reports as per conditions given on button click.Or I had to create 3 different "JpsCrystalReport.aspx" pages (that contains Report Viewer control) to show 3 Different Crystal Reports as per condition on button click?
View 1 Replies
Nov 22, 2010
I have a Registration form with two Buttons "Save" & "Report". When I click on "Save" the data will store in the Database. Now I want when click on the "Report" button the report of that particular will be produce in the Crystal report. How can I do that??
View 2 Replies
Mar 30, 2010
I am developing we application using Csharp on Visual studio 2008.How can I pass values from Page or GridView to a Crystal Report? For example I want some details on a Default.aspx want to appear on the Crystal report when I click on it. How do I pass theses values from Page to crystal report at Runtime?
View 3 Replies
