if i am using a seagate crystal report 7,and i use stored procedure as datasource.and i set string as a parameter to import date formate as yyyymmddhe user haven't input date, then set date to today in stored procedure.but the field doesn't display current date.how can i disply 20100604 when the paramter is empty
View 2 Replies
I'm building crystal reoport XI 2 on visual studio 2008 the datasourcse of report is dataset and it works for the first time but when i click on next page button or any other buton on the toolbar the report becomes empty I tried to but the dataset at the page load it doesn't work i tried also to put the reportviewer report source at the page load the report retrive date but at the next button it only give the second page.
View 2 RepliesI have two reports but i want to use the same crystal report viewer to display both reports depending on an option selected. How can I achieve this?
CrystalReportViewer.setCrystalReportSource(CrystalReportSource3) or something like this i am just not sure about the code in c#
I am working with Parametrized Crystal Reports. There are only two page called Source.aspx and Target.aspx.
[code]...
Only One text box data shows Not 2nd One.Can any one help me with this by checking my 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 RepliesI want to display a crystal report in my vb.net application. Suppose I have tables named student details, student marks, student address, etc... Nowif I want to display all these details (fields of all tables) in one crystal report (with page breaks if necessary) then how will I achieve it. I will be providing a combo box in my application that contains list of student names.How can I link this combo box with the cystal report to dynamically display report for different student on selected index change of combo box?
View 2 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.
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 RepliesHow 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.
May I know how to do this kinds of report? I am using Crystal Report 2008. Is it can be done using crystal report 2008? Is yes, may I know how to do this?
View 1 RepliesI want to show image in a crystal report. Scenario is something like this.
I have a database where my path of an image is persisting. eg ftp://Images/1.jpg
Now i want to repeat this image in a crystal report.
When i fills my datatable it shows me complete url. When i displays this field in GridView i uses imageBox to display my image and it works for me very fine.
But when i tries to do the same with crystal reports, it starts me showing image path as it is. Now here instead of path i want an image to be displayed.
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 RepliesI am using vs 2008 and sql server 2005. I am using Ajax Editor and storing the value in the DB in HTML tags.
Example:
<span style="color: #33ff66; font-weight: bold">Test Value</span>.
Now I want to display this html tags in crystal rerport. I have selected text Interpretation as HTML in crystal report. But it gives me the value as "Test Value". But not formatted value like "Test Value". I mean it not does apply HTML styles to the data whereas its printing only the datas taking away the HTML tags.
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());
}
}..............
using vb.net 2005 and crystal reports I added a server and db to my crystal report and I can see the table and fields in the server explorer. Also in "database expert" I added the table that I want to display data from. The question I have now is how to I display fields from this table on my report? I thought I remembered simply dragging and dropping a field onto the report from the table but not able to do that now
View 1 RepliesI want to display opening balance in page header of the report.
ex :
opening balance :
aaaaa bb 340 2000.00
item brand qty amt
aaaaa bb 34 340
aaaaa bb 34 340
I'm exporting a PDF report from Crystal Reports bundled with VS2008. I need to display non-standard fractions so that they look nice instead of just something like 26/32. I have turned html interpretation on for the field so ½ and other standard html entities display nicely, however, because CR does not understand <sup> and <sub? I cannot format non-standard fractions to look pretty.
View 1 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 some informations to put in my report and i want to display them in a table format
for example:
Number
[Number Information extracted from the database]
Description
[Description Information extracted from the database]
I have a problem with CR on server; I have reports that read connection string from web.config. On my development computer, everything is ok.
On server, report page opens normally, report template (I mean Print, Export etc.) is displayed but data is not shown there. Interesting point is data is loaded even though it is invisible, I understand that for reports more than 1 page, toolbar page buttons becomes enabled. Additionally, when I make a postback, by changing page number or changing zoom ratio, data becomes visible.
I have written this code for CrystalReportViewer but this not work
Private Sub Form2_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim scon As String = "server=(local);database=my;User;Password=sa"
sqlcon = New SqlConnection(scon) [code]....
I have an image in a report (a school logo stored in a folder).
My issue is that this image does not appear constantly on my reports, all of which use the same code to load it.
The image is stored in a Blob in an unconected dataset on the report.
The data set is filled as follows
public static DataTable SchoolLogo()
{
string ImageFile = System.Web.HttpContext.Current.Request.MapPath("~/Images/ReportImages/logo.jpg");
DataTable data = new DataTable();
[Code]....
I have about 6 reports that use this code and the image is loaded sometimes and sometimes it is not (even within the same report if it is loaded several times.)
I want to display images in crystal reports from database. what i do?
View 1 Replies
