I'm trying to create dynamic columns in the Crystal Report. The parameter fields are named column1,column2,column3.....
I tried below code and it gives me an error "The parameter is incorrect".
[Code]....
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]....
I have a crystal report which accepts a parameter and gets displayed on a webpage abc.aspx
On another webpage i have a grid displaying columns from a table loan_request.
When I click a row in gridview I want to get the report of that corresponding row.
I used rowcommand on gridview to get the value that uniquely identifies the row in a gridview, now I need to pass this value as parameter to the crystal report.
for this i think two possibilities
1. pass the value as querystring.
2. store it session and use it on the page that display the report.
I don't want to use query string.
for better understanding. once look at the code.
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Request_Log_Search_Sort.aspx.cs" Inherits="WebApplication1.Request_Log_Search_Sort" %>
<%--<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %>--%>
<%@ Register Assembly="CrystalDecisions.Web, Version=10.5.3700.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"
[Code].....
I have a VB.Net application which generates quite a few Crystal Reports. One report in particular has a Group Section. What I am trying to do with my VB.Net app is pass a value (a sql server column name used in the report). This value is represented by radio buttons. For example, the user may check either "ZipCode" or "State" or "Category" or "Type" or "Vendor". Each of these options represent a column in the database table used in the report. I simply want to be able to write the "SelectionFormula" using one of these options but not sure how to go about it.
View 1 RepliesWe have migrate from VS2005 to VS2010. CR2010 installed too.
We have 1 website and class project in one solution.
The assembly of web.config has point to new version of CR ver13 and also checked that the references is ver13 too.
WEB CONFIG:
[code]....
However in code behind, when "Go To Definition" the imported CrystalDesicions Namespace, it go to CR version10 location.
The class project has references to correct ver13.
In the end we get error of :
Error 17 The project currently contains references to more than one version of CrystalDecisions.CrystalReports.Engine, a direct reference to version 10.2.3600.0 and an indirect reference (through 'Web_cl.clsAccountRpt.GetAccountStatementSummaryRptDoc')
to version 13.0.2000.0. Change the direct reference to use version 13.0.2000.0 (or higher) of CrystalDecisions.CrystalReports.Engine. D:ProjectWebGlobal 4.0Web_developCpAdminReportFormAccountReportModule.aspx.vb 40 28 D:...Web_develop
The function in class has return ReportObject back to the website, because of the website reference did not really point to new version has causes this error. I have checked all references in web.config and project properties all is point to new version, but in program it seems still point to old one.
My report is displayed without any problem. However, when I click on the button from my crystal report viewer toolbars I get the error. Note : the toolbars is working fine on my local machine.
Error message : Logon failed. Details: mscorlib : Could not find a part of the path 'C:Documents and SettingschiaMy DocumentsVisual Studio 2008WebSitesSafety Permit System
ptLoad_ConfineSpace_Summary.xml'. Error in File C:WINDOWSTEMP
ptPrintSummaryConfineSpace
{965CF937-D48C-483A-AC32-198A790880A6}.rpt: Unable to connect: incorrect log on parameters.
I am creating the crystal report without database data, just i am read the data from text file and fill into dataset then genrate the crystal report but problem is here if i am export the crystal report into different format so he wants the database logon parameter.so in this case i have no database crendential because i am creating the report without database.
View 1 RepliesI have a requirement to generate Dynamic Crystal Reports.I am a new bea of Microsoft .net.
View 2 RepliesI want to bind dynamic dataset to my crystal report. Dataset come from store procedure with pivot.
following is my sp and code.
[Code]....
[Code]....
I need your help on how to generate HTML reports in an asp.net application.The report content should be database driven. since we have faced so many problems with Crystal reports during the Deployment ,and also it takes some time to load data,rapidly it affects the performance of application.
View 1 Repliesi have a dynamic pivot table which has a parameter passed in stored procdure
i have temp table to store columns in it to be dynamic and also a parameter
but this script make me go mad
colud you find me the error Inncorrect syntax near '+@columns+'Item_Group2 table structure is ID,Name,Group1_ID this is script
[Code]....
I have master page, menu on master page, i use asp roles and trim menu item based on user roles and rights this process is working fine.
Now i have to create some reports based on user roles, and responsibility in a company like country head will view country wide reports, manager region will only view regional report and rest will view reports related to them.
How can i achieve this efficiently using asp roles.
How to display more than 20 columns in a crystal report.
In .Net Crystal report how can I display over 20 columns? I can use not more than 10 columns.
I'm using CR that included in VS 2005. I have a Dataset of Phone Extenions that I pass to Crystal Reports then exports it to a PDF for printing.
View 9 RepliesI am using the following code to pass parameter from VB to crystal report but getting the error messgae "Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX))" while it trying to add the first parameter. This chunk of coding works in another VB perfectly. The only diffferent is the working one takes the parameter to stored procedure where the failed one I added parameter during crystal report design time.
[Code]....
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 Repliesmy question how to create crystal report without database, in this case i want to create the crystal report using txt file data. is ther any way?plz tell me? how is it possible?
View 1 RepliesI have basic understanding to cache webpages for duration. Now I have some complex requirements:
1. User e.g "Nauna" login in asp application
2. Visit on report page
3. Pass data range from 01-01-2013 to 30-12-2013 and extract the report which retreive data in 55 seconds on gridview
4. Now I want that when next time user "Nauna" login in the application and use the same report with same parameter 01-01-2013 to 30-12-2013 so that report should be come up from cache instead of run the complete life cycle.
I am trying to populate a report with parameters from session. Problem I am getting is that it is asking for parameter after I click the 2nd page of report. If I remove the Session.Remove it works good. Is there anyway to clear session after the first time the code executes? Here is my report viewer page code
public partial class setups_ftreaty_ft_mstmt : System.Web.UI.Page
{
ReportDocument rptDoc = null;
protected void Page_Init(object sender, EventArgs e)
{
string reportName = Request.QueryString["reportName"].ToString();
rptDoc = new ReportDocument();
rptDoc = ReportFactory.GetReport(rptDoc.GetType());
string path = Server.MapPath("~/reports/ptreaty/" + reportName + ".rpt");
rptDoc.Load(path);
if (Session["ptRepParams"] != null)
{
Hashtable repParams = (Hashtable)Session["ptRepParams"];
foreach (string param in repParams.Keys)
{
rptDoc.SetParameterValue(param, repParams[param].ToString());
}
}..............
I defined a report with a parameter (ID_Aluno) in Crystal Reports to show it in an .aspx page. The page is called by another page passing it a query string with the value I need as a parameter in the report. In the code behind file I tryed three different approches without success. What happen is that the report is showed without data, but when I open the parameter panel I see that the parameter is there (If I don't set the parameter value actually it complains that the parameter is missing, giving an arror).
Here is the code I used to set the parameter:
[Code]....
The First try (code not commented) is the one I would like to use because it is the shorter and simpler one.
Here is the mark up for the report source and report viewer:
[Code]....
Have I to declare or define something special in Crystal Reports for the parameter to be received and applied?
I am using a sub report inside the main report but the issue is thatboth main and sub report take same argument i.e emp-idwhat i want is that either subreport copy parameter of main reportor in some way should be able to send paramet throug code-
"Session["username"]="muneeb";
ReportDocument report = new ReportDocument();
report.Load(Server.MapPath("~/UOGERP/GUI/Reports/CrystalReport.rpt"));
[code]...
Using Crystal Report to view reports on the site and noe able to pass parameters succesfully.
Heres the code:
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Report.aspx.cs" Inherits="MATReports.Report" %>
<%@ Register Assembly="CrystalDecisions.Web, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" Namespace="CrystalDecisions.Web" TagPrefix="CR" %>
[Code].....
I created a gridview that is made up of 4 gridviews and using a stored procedure to populate it. I create columns at runtime because the number of columns changes all the time.To make the grids editable I am adding template fields at runtime as I create the columns, this is to ensure that a user is able to edit the cells and some foot values update. Reason why I have four grids is to freeze rows and columns like in excel using javascript. The problem is that performance is very bad especially in IE, the grids take a long time to load. I am not sure if this is caused by the data load or the creation of text boxes. see some of the code below for my _aspx page:
[Code]....
I am trying to pass date as parameter from my asp application to crystal reports.
If I pass 1 jan 2010 to 16 Jun 2010 it will not get me some of the records which are on dates like 11 april 2010. And If i select dates between 1 Jan 2010 and 30 Nov 2010 then system will get me the records. Here I understood that system is not understanding the date format the problem is in date format of "dd/mm/yyyy" and "mm/dd/yyyy".
I have 2 asp.net pages first page (PaySlipForm.aspx) contains ui elements for getting values from user, second page shows the report depending on the parameters passed from first page. The problem is first time the report shows correctly but when I go back on first page by clicking the back button of browser and changes the selection the report is shown empty only labels are shown.
First Page PaySlipForm.aspx
<asp:DropDownList ID="ddlAllEmployees" runat="server" style="margin-left: 7px"
Height="20px" Width="174px"> </asp:DropDownList>
<br />
<asp:DropDownList ID="ddlMonth" runat="server" Height="23px">
</asp:DropDownList>
<br />
<asp:DropDownList ID="ddlYear" runat="server" style="margin-left: 18px"
Height="23px" Width="77px">
<asp:ListItem>2010</asp:ListItem>
<asp:ListItem>2011</asp:ListItem>
<asp:ListItem>2012</asp:ListItem>
</asp:DropDownList>
<br />
<asp:Button ID="btnShow" runat="server" Text="Show" PostBackUrl="~/Reports/PaySlipViewForm.aspx"/>
Second page is PaySlipViewForm.aspx that has the code
<CR:CrystalReportViewer ID="CrystalReportViewer1" runat="server"
AutoDataBind="True" EnableDatabaseLogonPrompt="False" Height="50px"
ReportSourceID="CrystalReportSource1" Width="350px" />
<CR:CrystalReportSource ID="CrystalReportSource1" runat="server">
<Report FileName="../Reports/PaySlip.rpt">
</Report>
</CR:CrystalReportSource>
---------------------
if (!IsPostBack)
{
int employeeID = Convert.ToInt32((((DropDownList)Page.PreviousPage.FindControl("ddlAllEmployees")).SelectedValue));
int monthID = Convert.ToInt32((((DropDownList)Page.PreviousPage.FindControl("ddlMonth")).SelectedValue));
int year = Convert.ToInt32((((DropDownList)Page.PreviousPage.FindControl("ddlYear")).SelectedValue));
CrystalReportViewer1.SelectionFormula = "{Payroll.EmployeeID} = " + employeeID + " And {Payroll.Month} = " + monthID + " And {Payroll.Year} = " + year;
}