Crystal Reports :: Pass A Parameter From A Querystring?

Mar 14, 2011

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?

View 2 Replies


Similar Messages:

Crystal Reports :: Pass Parameter From QueryString To Report Viewer Control

May 7, 2015

protected void btn_showReport_Click(object sender, EventArgs e) {
try {
ReportParameter Comp_Name = new ReportParameter();
Comp_Name.Name = "Comp_Name";
ReportViewer1.ProcessingMode = ProcessingMode.Remote;
ReportViewer1.ServerReport.ReportServerUrl = new Uri("http://dell-pc/ReportServer");
ReportViewer1.ServerReport.ReportPath = "/Companies Report/Companies";

[CODE]..

the above code is in "reportpage.aspx" when I click on it the company report is shown according to the parameter "Comp_Name"

I want to show report in "reportpage.aspx" according to parameter name passed from another .aspx page, how to do that?

View 1 Replies

Crystal Reports :: How To Pass QueryString Value Using Database

Jan 6, 2013

I am developing a web application and I am using a crystal report for my project, how can I pass the query string to the crystal report using the database.

View 1 Replies

Crystal Reports :: Cannot Pass Parameter From VB

Jun 21, 2010

I 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]....

View 5 Replies

Crystal Reports :: Pass TextBox Value As Parameter?

Feb 25, 2016

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].....

View 1 Replies

Crystal Reports :: How To Pass Multiple Values To Parameter Using C#

May 7, 2015

parameter field {?country}: string

allow diffrent values: true

selection record: table.country in {?country}

when i pass one parametrs it's works fine.

rd.SetParameterValue("country", DropDownListSalle.SelectedItem.Text);

my question is how can i passing multiples values (tokyo,usa,india,...) ?

View 1 Replies

Crystal Reports :: Pass GridView Row Columns As Parameter?

Mar 12, 2013

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].....

View 1 Replies

Crystal Reports :: How To Pass Label Text Into Parameter

Apr 27, 2016

I used lable(Lblname) in page that bind it from database:

private void ViewDocInfo(int data1) {
using (SqlConnection conn = General.GetConnection()) {
using (SqlCommand _cmd = General.GetCommand("Documentry_ViewMostanadInfo", conn)) {
_cmd.Parameters.AddWithValue("@id", data1);
conn.Open();

[Code] ....

I have datalist that bind it from database:

private void GetCustomersPageWiseView(int pageIndex) {
using (SqlConnection conn = General.GetConnection()) {
using (SqlCommand cmd = General.GetCommand("GetCustomersPageWiseMC", conn)) {
cmd.CommandType = CommandType.StoredProcedure;

[Code] ...

And I have Linkbutton :

protected void LBview_Click(object sender, EventArgs e) {
Lblname.Visible = !(DLMostanad.Visible = true);
this.GetCustomersPageWiseView(1);
}

In above code as you see when click on linkbutton it will Lblname.visible=false

But in this metod:

this.GetCustomersPageWiseView(1);

In this line:

cmd.Parameters.AddWithValue("@Name", Lblname.Text);

I need Lblname.text but when I click on linkbutton it will lblname.visible=false and it can't pass lblname.text to GetCustomersPageWiseView metod...

How I can pass lblname.text to this metod?

View 1 Replies

Crystal Reports :: Pass Rich TextBox Content To Parameter?

May 7, 2015

my requirement is  i want to pass  richtext content  and text as t is in rich txt box  such as bold,color  font .... into crystal report

View 1 Replies

Crystal Reports :: How To Pass Date Range From Text Box To Crystal Date Range Parameter

Sep 25, 2010

I has developed a crystal report, which display the records from a table and filters them based on a parameter( date range parameter). now I has integrated the report into a asp.net page using c#, but when I am running the asp page it is not promption for the date range values, it used to prompt for date range when I run the report in crystal report.

View 2 Replies

Crystal Reports :: How To Avoid Logon Parameter Of The Databse Data Creating The Crystal

Dec 25, 2010

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 Replies

Crystal Reports :: How To Pass Values From Page Or GridView To A Crystal Report

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

Crystal Reports :: How To Pass Values From Page To Oracle Store Procedure In Crystal Report

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

How To Pass More Than One Parameter In Querystring

May 7, 2015

I have one hyperlink I want to pass more than one parameter in hyperlink

but cant pass perfect data in query string 

using database.

same data pass in another page using this code.

<asp:HyperLinkField DataNavigateUrlFields="Product_Id" Target="_blank" DataNavigateUrlFormatString="AddprodPhoto.aspx?Product_Id={0}&Catalog_Id={0}" Text="Upload">
o/p

[URL] ....

product_id pass right Catalog_Id=2 is wrong

View 1 Replies

Crystal Reports :: How To Pass Values To Crystal Report

Mar 14, 2011

i can develop crystal report with password itself.But, i want to pass values in to crystal report programatically..

View 1 Replies

Crystal Reports :: How To Pass Parameters Into Crystal Report With C#

Mar 27, 2011

i need to pass parameters into the crystal report...i am using asp.net with c#

View 1 Replies

Pass Values From QueryString Parameter In GridView Hyperlink?

Jan 14, 2010

I'm using GridView with a hyperlink column, and I want to do the following:

DataNavigateUrlFormatString="~/student/group/document/Body.aspx?DID={0}&GN={QueryString("GN")}" HeaderText="View Document" Text="view" />

How I can retrieve the value of GN from the QueryString parameter and add it to the hyperlink column ?

View 1 Replies

Web Forms :: How To Pass A Long Parameter String (more Than 256 Chars) Via Querystring

Aug 30, 2010

In my project one of scenario demands passing querystring values more than 256 chars @ a time ...I tried it but after 256 chars its trunacting all other chars. workaround or various ways for passing more than 256 chars through querystring.

View 6 Replies

Crystal Reports :: Either The Crystal Reports Registry Key Permissions Are Insufficient Or The Crystal Reports Runti?

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

Crystal Reports :: Cached Reports User Wise And Data Parameter Wise

Nov 24, 2013

I 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.

View 1 Replies

Data Controls :: Pass Multiple Values For Single QueryString Parameter

May 7, 2015

i want to pass multiple arrays variable in query string.for example i have three checkbox list Brand ,Price, Attribute any arrays variable may have more than one value key arrays variable are fixed for checkboxlist

1-checkbox list Brand has Brand []arrays variable

2-checkbox list Price has Price []arrays variable

3-checkbox list Attribute has Attribute []arrays variable

now i have selecting two -two from every checkbox list .than i want to query string something like this

www.defualt.aspx?brand[]=samsung=123&apple=11,Price[]=100=12&200=2,Attribute []=camera=1&display=2

View 1 Replies

Web Forms :: Pass QueryString Parameter In PostBack URL Of LinkButton And Fetch It On Next Page

May 22, 2013

In my asp.net web i used the following code:

<asp:LinkButton ID="LinkButton1" runat="server"
PostBackUrl="unitlink.aspx?coy=tata">Tata</asp:LinkButton>

The data is correctly displaying in gridview.

There is a label (label1.text) in the same page i want to display the coy in that label along with the gridview....

View 1 Replies

Crystal Reports :: Asking For Parameter After First Page Display

Mar 18, 2010

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());
}
}..............

View 3 Replies

Crystal Reports :: Passing Parameter To Subreport?

Jun 24, 2010

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]...

View 1 Replies

Data Controls :: How To Pass TextBox Value To Another Page Using QueryString Parameter On Button Click

Jan 9, 2014

I have passed the value from one page to next page using a querystring. In the next page i need to get the value from the query string and based on the value, it needs to checked with the database and the result set should be placed in the gridview, details view or listview anything else. 

Ex: Response.redirect("user.aspx?id="+userinput.text);

 userdetails.aspx?id=vicky - url

table:

user           mobileno                email
vicky           9848752322         ervigsh@gmail.com 

In the details view or list view control, I need to get the value vicky from the url and based on the value's row in the database table need to be binded in any of the mentioned above controls.

View 1 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved