Crystal Reports :: Create DSN And Pass Database Credential Through A Asp 2.0 Page To Call?

Jul 29, 2010

I have a new issue, i am working with crystal report 2008 in ASP.NET 2.0

I am trying to call Crystal report through ASP.NET page

the issue is, system DSN is not allowed to create on the server.

how i can create DSN and pass database credential through a ASP.NEt 2.0 page to call a crystal report

previousley i am doing like this on a local machine to call a report

crConnectionInfo.ServerName = "dsn_Name"
crConnectionInfo.DatabaseName = "DB_Name"
crConnectionInfo.UserID = "sa"
crConnectionInfo.password="password"

but i am not able to create or system DSN is not allowed to create on the production server.

please help that wt are the other way to call the crystal report 2008 through asp.net 2.0

View 2 Replies


Similar Messages:

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

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 :: Create Without Database As Datasource?

Apr 11, 2010

I want to know that is it possible to create crystal report without database as datasource?

because i am having database but the data that i want to show in report is not a direct values from database...

Actually i am having one attendance table now i want to show the total no of rows(attendance table has 50 rows then report should display just "50" instead of displaying each rows) in the report...how can i show that?

attendance table(sub_code,status,roll_no,date)

subjects(sub_code_sub_name)

my report format is like :(sub_name,total lectures,present lectures)

for example:-report should look like....

(sub_name,total lectures,present lectures)-This total lectures can be counted using attendance table but how can i diplay in report thats what i want to know?

Sub-1 | 20 | 15

Sub-2 | 45 | 4

Sub-2 | 33 | 3

View 1 Replies

Crystal Reports :: When Pass Id To The .aspx Page Containing The Crrystalreportviewer Get Error

Jan 2, 2011

I am new to crystal reports... I am using a dataset for the report which gets data from stored procedure .. And i am using crystalreportviewer to view the report in .aspx page.. When i pass id to the .aspx page containing the crrystalreportviewer i get the above mentioned error.. I am clueless how to fix it..

View 2 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

Crystal Reports :: GridView To Display All Database Records In A Page

Oct 18, 2012

Actually I am developing one web application,in that application I used a gridview to display all the database records in a page. I provide hyperlink print for every row, if I click the print option, the particular record will be print in the crystal report..

View 1 Replies

Crystal Reports :: How To Create Role Based Reports When Working With Membership

Apr 13, 2013

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.

View 1 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 :: Create The Crystal Report Using Txt File Data?

Mar 1, 2011

my 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 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 :: How To Create Reports Using Views

Oct 28, 2010

I have got two sets of users. One set can view all information of branches from 1to 5 and the other group can view all the information of branches from 6 to 10. How do I create reports using views for these two sets of users?

View 2 Replies

Crystal Reports :: Pass A Value To A Store Procedure

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

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

Crystal Reports :: How To Dynamically Pass SQL Query

Jun 16, 2015

How to pass sql query to crystal report programmatically using c#

View 1 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 :: Crystal Report Not Using A Database Data?

Nov 28, 2010

My report does not use data from a database. It uses a code generated dataset. How do I give crystal reports the necessary logon data to avoid database logon failures.

View 1 Replies

How To Pass Date Parameters To Crystal Reports 2008 From App

Mar 31, 2010

I'm passing some parameters to a CR report programatically and it was working fine, but now that I have added a new date parameter to the report, for some reason, it is prompting me to enter that parameter on screen (the user isn't allowed to set that parameter is the system who must set it.), I haven't changed a thing other than adding the new date parameter, and all the other parameters behave normal, just the date parameter is prompted even thought I've already set a value for the parameter.

This is the code I've got:

private void ConfigureCrystalReports()
{
crystalReportViewer.ReportSource = GetReportPath();

[Code]....

Just for the sake of things: I have checked that the parameter is indeed a date and that it is well formed. CR prompts me to enter it in the format (mm/dd/yyyy hh:mm:ss) so I pass date in that exact format (In fact I've even tried hard coding a well-formed date and it still prompts me to enter the date).

View 2 Replies

Crystal Reports :: Pass TextBox Value To Formula Field?

Feb 26, 2014

I need to pass some data from text box ( ie dump from textbox ) to crystal report how can ido it using formula field in c# i have textbox1.text="INDIA" how do i display the value from textbox in crystal rpeort using formula field.

View 1 Replies

Crystal Reports :: How To Pass Session Values As Parameters

Apr 16, 2013

i want to show a crystel report on page load of page. where i want to show report of those student who logged in the system and their session is created.

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







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