|
Hello,
I am very new to Crystal Reports and i am trying to implement specific report format.
I have programmatically created some data tables (using SQL queries) which are to be displayed in grid format in report.
Each Data Table corresponds to one column data and they are mapped with the Data Tables created in DataSet . I am using Standard report to display data but i don't know how to display the data in grid layout.
I tried to use Cross Report but i don't want to group the data or count and other unnecessary fields.
Also, all columns are not having equal no. of rows so the Box object and Line object are not solving my purpose if i use Standard Report.
Please see the report format image at http://sites.google.com/site/gridformat
I have the data ready with me but i am struggling to wrap it out with specified grid layout.
Please tell me how to generate the grid with merged column header and fill the data in it?
Thanks in advance.
|
|
|
|
|
here i want to create sequence no. with every ..
like...
and show in richtextbox control..
here is my code:-
richTextBox1.LoadFile(filepath,RichTextBoxStreamType.RichText);
string inputstring = richTextBox1.Text;
StringBuilder sb = new StringBuilder(inputstring);
sb.Insert(0, "
");
sb.Replace("\n", " " + "\n" + "");
sb.Replace(" ", "");
sb.Append("");
sb.Replace("", "");
sb.Replace("\n\n", "\n");
sb.Replace("\n\n", "\n");
sb.Replace("\n\n", "\n");
sb.Replace("\n\n", "\n");
sb.Replace("\n\n", "\n");
sb.Replace("\n\n", "\n");
richTextBox1.Text = sb.ToString();
|
|
|
|
|
i have datagrid i want to update my grid values to sql table in button click,
is there any ways that values can automatically update while entring.
please help me i am fresher. its urgent
thanks in adv.
|
|
|
|
|
1. uslesss subject line
2. databinding
3. UjwalGwoda wrote: i am fresher so?
4. UjwalGwoda wrote: its urgent of course it is, silly us for not responding sooner.
Note - there is clue in the above.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Hi guys...
How to create radio buttons dynamically and assign textbox value to radio button text.
Krish
|
|
|
|
|
RadioButton is an ordinary class so to create new instance you just need to call its constructor and assign it some variable. Like this: RadioButton rd = new RadioButton() It has a property called Text so you can use it to set its text. The text can come from any source. rd.Text = myTextBox.Text
Note the radiobutton will not be visible if you don't add it to a form or container control.
|
|
|
|
|
Thanx dude its working.
Very good support
|
|
|
|
|
You are welcome
|
|
|
|
|
I am programming a movie info collect tool. I think store all data with XML is OK.
Here is the MovieDataXML
<?xml version="1.0" encoding="utf-8" ?>
<Data>
<Movie>
<ChineseName>aa</ChineseName>
<EnglishName>aa</EnglishName>
<Year>aa</Year>
<Area>aa</Area>
<Type>aa</Type>
<Language>aa</Language>
<Subtitle>aa</Subtitle>
<IMDB>aa</IMDB>
<Resolution>aa</Resolution>
<Director>aa</Director>
<Actors>aa</Actors>
<Introduction>aa</Introduction>
<BelongTo>aa</BelongTo>
<DiscNumber>aa</DiscNumber>
</Movie>
</Data>
And when I try to read the data.
ClassXMLHandler clsXmlHandler = new ClassXMLHandler();
string strMovieData = "Data";
XmlNode xNodeMovieData = clsXmlHandler.MovieDataDocument.SelectSingleNode(strMovieData);
XmlNodeReader xReader = new XmlNodeReader(xNodeMovieData);
Here is the problem
If I read XML data by DataTable
There will be a Exception "DataTable does not support schema inference from Xml",
If I create this DataTable schema manually,there is no data in that DataTable.
DataTable dtMovieData = new DataTable();
dtMovieData.ReadXml(xReader);
But I found it is OK if I use DataSet instead of DataTable
DataSet ds = new DataSet();
ds.ReadXml(xReader);
I don't know why.
|
|
|
|
|
I get this string from device : 6.623E-2\n,#wz4y
How do i get 6.623E-2 ?
thanks
|
|
|
|
|
|
|
What about
- yourstring.Split(new char[] { '\n' }) or
- yourstring.Substring(0, yourstring.IndexOf('\n') or
- Regex.Match with pattern @"^([^\n]+)\n.*"
regards
modified 12-Sep-18 21:01pm.
|
|
|
|
|
\n or \r\n are concidered new lines.
if you load following string:
"test\r\nmore test"
in a multiline textbox it will appear:
test
more test
|
|
|
|
|
|
But you need to be sure that the '\n' is there or test for -1.
|
|
|
|
|
Hi,
How can i "store" a image in a xml file?
I am thinking in a byte[] like in sql server.
<user>
<f_name>John<f_name>
<l_name>Black<l_name>
<image>w3cvbjr7lerr4hh56ws2<image>
<user>
Any help welcome; link, code, whatever
nelsonpaixao@yahoo.com.br
trying to help & get help
|
|
|
|
|
Since you can't stored just any old character you want in an XML file, you'll have to convert the image to a string that XML can hold. A thought off the top of my head says convert it to a base64 string and store that.
|
|
|
|
|
|
I have a application I have built that uses a SQL Server express database to store the data. I have built a logging functions which writes the log entrys of whats going on in the application to a text file on the hard disk. When I set the logging to DEBUG mode (which logs a ton of stuff) it takes a long time for certain things to run as its writing a bunch of data to the text file. If they set the logs to WARN... it only writes important information to the log file.
This all works great, but I would really like to log everything so if there is a problem with the application I can look at the users log file and tell exactly what they were doing to try and reproduce the error. So I was thinking about writing the logs to the database which would mean I could insert all entrys and just query the items I need to return which brings up my question.
If i start to insert a ton of data into the database, at what point could I overload the database?
XXX Querys a hour/second?
Database reaches XXX size?
I know this will depend on the users machine also, but its not going out to a wide user base, more like 10 people.
|
|
|
|
|
Brad Wick wrote: I know this will depend on the users machine
This is just 1 of the considerations. Database design will have a big impact, as will proper connection control and a whole host of other things. I suspect the only real way of finding out is to test it.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
I am passing in the procedure name and a parameter array. The values in the array are correct, yet I'm not getting any data back:
public DataSet ExecuteQueryProc(string sParameterName, SqlParameter[] ParamArray)
{
DataSet oDataSet = new DataSet();
SqlConnection oConn = GetConnection(true);
if (oConn != null)
{
SqlCommand oCommand = new SqlCommand();
oCommand.Connection = oConn;
oCommand.CommandText = sParameterName;
oCommand.CommandType = CommandType.StoredProcedure;
oCommand.Parameters.AddRange(ParamArray);
SqlDataAdapter oAdapter = new SqlDataAdapter();
oAdapter.SelectCommand = oCommand;
oAdapter.Fill(oDataSet);
}
return oDataSet;
}
>
Anyone wanna take a stab it this?
Everything makes sense in someone's mind
|
|
|
|
|
oConn equaling null would result in no data.
Just because we can; does not mean we should.
|
|
|
|
|
Have you tried running the proc in query analyser with the EXACT paramters you are passing? Its often easy to get a trailng space on a string that results in no data, or similar problems. I often just do a bit of code to generate the exact call (with the param values in the correct quites etc), then test it in query analyser.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Hi
I have a project where I want to start X threads for processing in the background while the main thread does other stuff. However, as soon as the main thread is finished with its work it should wait for all the other threads to finish before continue.
I looked at threadpool and found it to be insufficient (due to reasons I will not discuss here).
What I try instead is to implement my own pool of threads starting with:
Thread[] threads = new Thread[numthreads];
for (int i = 0; i < this.threads.Length; i++)
{
threads[i] = new Thread(Handler);
threads[i].Start();
}
I figured I could use ManualResetEvent to wait for the threads to finish. My question is this though:
Can I use a single resetevent for all threads to signal, or do I really need to have <numthreads> resetevents and use WaitHandle.WaitAll()?
How about the other way around? Can I have a single resetevent that all threads are listening to (waiting for input to process), and then only the first thread to catch the signal from the mainthread to actually start processing?
|
|
|
|