I'm doing a report that includes blocks of text. The block of text that is inserted into the report is determined using a formula.
I want to indent the first line (similar to writing a letter) of the text. Can anyone let me know how to program this into the formula. I'm looking for something similar to the Bold (<b>), underline (<u>), or hard return (<BR>) codes that are used with HTML format.
am using crystal reports and directly exporting it to pdf. I want to filter records based on record selection formula but below mentioned code is not filtering data for particular employee. All records are coming to pdf. I want only selected records based on selection formula.
ReportDocument report = new ReportDocument();
string ReportPath = Server.MapPath("Reports/PayRollReport.rpt").ToString();
report.Load(ReportPath);
[code]...
"SELECT * FROM details where UserName = '" & name.Text &
"' and Date1 between CDate('" & date1 &
"') And CDate('" & date2 &
"')"
can any one help convert it into crystal report selection formula
in my project iam providing users to send sms acrooss india..in admin panel the admin have a feature to check the usersent sms details on the basis of userid.. when admin selects the userid then corresponding send sms details are details are displaying.. my requirement is generating the crystal report for that table..the users are displaying from one table and sent sms details are displaying detaials from another table.. how to generatye crystal report for that..and how to give formula fields in crystal reports
View 1 RepliesI'm sorting the Crystal Report (2008) programmatically:
FieldDefinition fdSortField = rpt.Database.Tables[0].Fields[ddlSort.SelectedItem.Value];
rpt.DataDefinition.SortFields[0].Field = fdSortField;
if (rbSort.SelectedIndex==0)
{
rpt.DataDefinition.SortFields[0].SortDirection = CrystalDecisions.Shared.SortDirection.AscendingOrder;
}
else
{
rpt.DataDefinition.SortFields[0].SortDirection = CrystalDecisions.Shared.SortDirection.DescendingOrder;
}
(the user selects the sort field from the Dropdown list ddlSort and the sort direction from the Radiobutton list rbSort).
This works fine, the only problem is that this doesn't work for the formula fields, because they are not part of the database. However, since it is possible to set the sort order by the formula field in design time, it should be possible to do this programmatically.
I need to concatenate address string. Is it better to concatenate using the formula field or concatenate in the Sql query itself? which one would be faster?
View 1 Replieshow can i get and set crystal report formula fields from c# code behind, i use this code, double sum=reportdocument.datadefinision.formulafields[1].text but it get formula text not value
View 2 RepliesI tried using this and am concatenating the fields together. It does not appear to be working. Here's what I have.
View 7 RepliesI 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 RepliesI'm trying to generate crystal report based on the two dates selected by the user ... the selection formula editor gives me
the error "a string is required" when I want to save and close my formula , can any1 help me whts wrong with my formula shown below ,
{records.entrance_date} >= {?entrance_date} and {records.entrance_date} <= {?entrance_date2}
both ?entrance_date and ?entrance_date2 are of date data type
Access font color formula from asp.net code
View 3 Repliesusing vb.net 2005 and crystal reports.
I have a typed dataset that is displaying an image using an iBlobFieldObject on a report. I need to use a crystal report formula field to hide the image when the value is null, does anyone know how to do this?
I want to change text of text object in crystal report (.rpt file). The datasource for the report is a datatable which consists of a column named sale, if it is '0' then I want to display the text of text object as 'sale' and if it is '1' then I want to display the text of text object as 'lease'. how to add formula and based upon the result of formula I have to change the text of text object being displayed.
View 1 Repliesusing 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?
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 RepliesI have text more than 1000 character in table. But I want show text from table in crystal report. When I show text in textbox crystal report text out from textbox and can’t seen all text.
For example:
Text out from t
extbox.
For me need like this:
Text out from textbox . it’s need me
How I can solve this?
I need users to be able to enter text in a webform with some basic formatting options and then generate a report showing the formatted text.The support for HTML is horrible and entering a simple bulletlist doesn't even show properly in the report.Right now i'm using a textarea with tinyMCE but that's because i don't know what else to use.Is there a known best-practice for showing formatted text in a Crystal Report?EditI just need to show a report with a bunch of text and icons. Users need to be able to save it to PDF. I doesn't even have to be Crystal Reports but it's what i have been using and worked so far. Until i needed to show formatted text.I wish for another solution that comes with a designer and let's me bind against a DataSet.
View 1 RepliesI'm new to Visual Studio.NET . I need to integrate the crystal reports into an ASP.NET application. I generated Crystal report with the help of crystal report XI developer edition(Stand alone version and NOT from the one which comes from visual studio).
How to integrate this report with the web application.
We have quite a few reports which were developed earlier in Crystal Reports 8.5. We are now planning to use these reports in our web application developed in VS 2008 (C#).
What dlls are needed for calling 8.5 in the application and how should they be added to the application while shipping it to the client?
They are also struggling to get the code running. Would also need the code to call the report with parameters.
In Crystal Report I have some text boxe on the page footer section, I wanted to show all these text boxes only on the last page. In other words I wanted to show the whole page footer section only on the last page. I do not wanted to user Report footer, as report footer starts immediatly after the contenets of the report are finished, but I wanted to display my stuff at the page footer leve in any case.
View 1 RepliesI want to display Gujarati text in crystal report ..
View 15 Repliesusing vs.net crystal reports 2005
I am attaching a dataset to a crystal report and want to know when I have several rows of items to display on the report how would I display several rows of data in the crystal report.
I am normally using textObjects on the report but it looks like I need some kind of repeating control, something like crystal reports version of a datagrid. I realize that in the part of the report where I need to display rows of product names that I might need to create a sub-crystal report that I attach a sub query to.
I have already generated crystal reports but i've made them static. but now i want to make the user to select the criteria for generating the reports. for eg., in one of them i want to show monthwise data so user should be able to select the month and year and that would be passed as parameter and compared to the existing data. provide me with proper exact code that can be used for giving parameters in such a report using C#.
View 3 RepliesI am developing web application using csharp. But I want one copy to apper with a writing in background as Copy? Forexample the report should pull details which a m doing. But want in the background of the report a text which is saying COPY COPY.
View 1 RepliesI 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?