|
Hi All,
I am working newly on Crystal Reports with C# for a Desktop Application and its my first experience for both the reports and desktop application.
I created a simple pie generating report.Everything is working fine.
The only problem I feel is everything with designing of reports can be done on design time only...is it so or am I wrong..?
1] Also I wanted to change the Label generated and place my own.Right now the label displayed on Pie is something like "Distinct.Count.TrialTable"
i.e. the formula I use for generating the Pie. Can I change it ..if so how..?
2] Also I want to display the charttype based on user selection...like if user wants pie, it should be pie or if user wants bar ..it should display bar...as we do it in Chart Expert ..wherein we select the chart type.
Can this be done dynamically ..like if I take a dropdown list and allow user to select the type of graph...the same should be dynamically selected and displayed..how to achieve this..is there any provision for this...or will I have to go by making different report files and calling the same on user selection..? How should I go about it..??
Hope I am clear with my question..!
Jimish
|
|
|
|
|
Have you tried asking this question in Crystal support forums. I know it is a negative response but the deveolpment experience with CR is so bad that most of us have moved to another reporting platform.
You will almost certainly not get a positive response from a general development forum (CP) for a 3rd party product (Crystal), especially when the product is such a POS.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
can u suggest what other reporting platforms can I use..??
Jimish
|
|
|
|
|
We use sql server reporting services and I beleive DevExpress have a good report tool. SSRS comes with SQL Server but you can embed a report in your app without installing the full reporting services.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Crystal Report is a component Which is used to Create Report and Print. You Can draw Crystal Report At run Time as per your requirement.
Best Regard
Anubhava Dimri
mailto: anubhava.prodata@gmail.com
|
|
|
|
|
Hi Anubhava..
I understand it...but can u post any link showing run time usage of Cryatl Report Component..!!
Jimish
|
|
|
|
|
Hi Jimish,
Visual Studio 2005 have a auto-generated Code for creating Crystal Report.I have not any url for run time usage to creating Crystal Report .
Best Regard
Anubhava Dimri
mailto: anubhava.prodata@gmail.com
|
|
|
|
|
Exactly..this is where is the problem..I could not find any relevant code of runtime crystal reports..and the auto generated code is ofno good..when it comes to placing of the chart component..!
My basic requirement is charts..if anyone can help me out ..!!
Jimish
|
|
|
|
|
Check the path of Report there is a file of .VB or .CS extenction same name of Report.
mailto: anubhava.prodata@gmail.com
|
|
|
|
|
I am not getting result of API for Google Image Search which available on codeproject.com as auther said we have to upadate regexpr .as it was runnig properly before 20 days
|
|
|
|
|
Sorry, is this a question ? If you read an article, ask the author. If it's about a google offering, maybe they changed it since ?
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
|
I need to create simple query designer. because we need to give sql query designing part to our customers. The main headache to me is visualize the joining. I use custom controller (checkedListbox and button) to visualize the table. Please help me to do this.
Dushan Perera
|
|
|
|
|
can i help you ? you need Described in detail
|
|
|
|
|
Basicaly i need to develope simple sql query designer like sql server query designer. I need that to generate simple select statement. It is use to design query for the reports in the system
Dushan Perera
|
|
|
|
|
You need to either post the work on Rentacoder and pay someone to do it, or ask more specific questions.
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
|
We use this product to give our used access to the database QueryBuilder[^]
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
You could always take a look at articles here on CP - specifically this[^] one.
"WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.
My blog | My articles | MoXAML PowerToys | Onyx
|
|
|
|
|
Hello! I can´t show videos in WS.
I have a GenericHandler:
]]>
using System;
using System.Web;
using System.Data.SqlClient;
using System.Data;
using System.Configuration;
public class VideoHandler : IHttpHandler
{
private localhost.wsDataReader example;
public void ProcessRequest (HttpContext context)
{
example = new localhost.wsDataReader();
context.Response.BinaryWrite((byte[]) example.ShowVideo() );
}
public bool IsReusable
{
get {
return false;
}
}
}
If we only execute it shows a window for download the video: open, save or cancel.
This .ashx uses the WebMethod called ShowVideo():
using System;
using System.Web;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Data.SqlClient;
[WebService(Namespace = "http://localhost/wsDataReader/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
public class wsDataReader : System.Web.Services.WebService
{
public SqlConnection ConexionConBD;
public SqlCommand Orden;
public SqlDataReader Lector;
[WebMethod(Description = "this method returns a video using DataReader")]
public byte[] ShowVideo()
{
string Conexion ="Data Source=.\\SQLEXPRESS;AttachDbFilename=\"|DataDirectory|\\BDvideos.mdf\";Integra" +
"ted Security=True;User Instance=True";
ConexionConBD = new SqlConnection(Conexion);
string Consulta = "SELECT Video FROM Videos";
Orden = new SqlCommand(Consulta, ConexionConBD);
ConexionConBD.Open();
Lector = Orden.ExecuteReader();
Lector.Read();
return (byte[]) Lector["Video"];
}
}
I don´t want download the video. I only want show the video in a WindowsFormsApplication or in a Website (.aspx)...
What can I do?
|
|
|
|
|
You can't really use a webservice if you don't want to download the video. Do you know anything about what a webservice is ?
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
|
Javier Aballay wrote: I don´t want download the video
Ok so how do you propose to move your eyeballs to the server. You need to research different way of displaying the video, get away from the idea that the vidio is not downloaded.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
i have a problem with how to pass the server name or its address in the code.
???
??
?
thanks in advance,,,
|
|
|
|
|
What the hell are you talking about ? What server name ? Is this an ASP.NET question ?
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
|
i have a project in c# and sql server and i have to make the server name in this project as a parameter how i make the end user to chose the server name to connect the project to the server database.
thanks for your efforts.
|
|
|
|
|
Hi there,
I’m trying to write a program that reads .xls file, formats it by removing specific rows and columns into table, sorts the data and then displays the data in dataGridView.
The .xls file is not formatted into table and in order to do that I need to delete 4 first rows and 2 first columns.
And here’s the problem when I’m trying to do that the program removes only 2 first rows and columns one and three instead of one and two. Here’s the code:
DataTable sampleDataTable = new DataTable();<br />
<br />
OleDbConnection aConnection = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\file.xls;Extended Properties=Excel 8.0");<br />
<br />
aConnection.Open();<br />
<br />
OleDbDataAdapter oleDbCommand = new OleDbDataAdapter("Select * from [file$]", aConnection);<br />
oleDbCommand.Fill(sampleDataTable);<br />
<br />
dataGridView1.DataSource = sampleDataTable;<br />
<br />
dataGridView1.Columns.RemoveAt(0);<br />
dataGridView1.Columns.RemoveAt(1);<br />
<br />
dataGridView1.Rows.RemoveAt(0);<br />
dataGridView1.Rows.RemoveAt(1);<br />
dataGridView1.Rows.RemoveAt(2);<br />
dataGridView1.Rows.RemoveAt(3);<br />
I don’t know what’s wrong as I tested it several times by programatiacally counting coulumns and rows but it’s still not working. It does work when I format the file before opening it by the program though.
Hope that somebody will point me in the right direction.
Thanks, Darius
|
|
|
|
|
One problem I can see is that after removing a row at index 0, the row that was at index 1 is now at index 0 (everything gets shifted).
So you would want this I believe:
dataGridView1.Columns.RemoveAt(0);
dataGridView1.Columns.RemoveAt(0);
dataGridView1.Rows.RemoveAt(0);
dataGridView1.Rows.RemoveAt(0);
dataGridView1.Rows.RemoveAt(0);
dataGridView1.Rows.RemoveAt(0);
|
|
|
|