|
Hello
I was developed Web Application using ASP With Crystal Report 9.
My Problem:
Now I want to display data in a single report file from more than one Table. Here I given how my Two tables.
Table1:
Col1 Col2 Col3
1 1 1
Table2:
Col1 Col2 Col3 Col4
2 2 2 2
3 3 3 3
4 4 4 4
5 5 5 5
My Report file design Look like....
Details a Table1.Col1 Table1.Col2
Details b Table2.Col1 Table2.Col2 Table2.Col3 Table2.Col4
When the report get generated records from Table1 get duplicated (i.e.) the output of my report is looking like.
1 1--------------------from (Table1)
2 2 2 2------from (Table2)
1 1(get duplicates)----from (Table1)
3 3 3 3------from (Table2)
1 1(get duplicates)----from (Table1)
4 4 4 4 -----from (Table2)
1 1(get duplicates)----from (Table1)
5 5 5 5------from (Table2)
So here i want to suppress the duplicated records please tell me in brief
N.Rajakumar B.E.,
Application Developer,
www.newdreamz.tk
|
|
|
|
|
Rather than supressing those fields, you should probably create a ierarchy, unless ou have reason to do otherwise. 2 ways i can think of doing this off-hand, both require linking your Tables.
Setup a link between your Tables, if you haven't already done so, (eg. "SELECT * FROM [Table1] LEFT JOIN [Table2] ...") such that you have a parent-child relationship mapped between the tables.
Method 1:
Set Table1.Col1, Table1.Col2, Table1.Col3 as your Groups, and in the Group3 Header section put:
Table1.Col1 Table1.Col2 Table1.Col3
as you want them displayed.
Then in the Details section, put your Table2 fields.
Method 2:
Put your Table1 fields in the Details section.
Create a subreport for the Table2 fields, and place it in the Group Footer, or Report Footer, just below the Details section. Crystal Reports documentation can explain how to create a subreport.
Both methods will acheive what you want, but i dare say that the second method will be more efficient.
nicko
|
|
|
|
|
I found an article in my e-mail newsletter that I'd overlooked previously:
"Protecting application's unauthorized copy - Manish K. Agarwal
To protect your application's unauthorized copy by using image integrity functions (Platform SDK's ImageHlp APIs) and to manage certificates in a portable executable (PE) image file. (Unedited)"
It was posted in WIN32/SDK on 28 Nov 2005.
When I tried following the link included in the newsletter,
http://www.codeproject.com/article.asp?tag=6718472808938685[^]
it brought me to some other irrelevant stuff.
Furthermore, the search for articles by Manish K. Agarwal on Code Project returns zero results.
Any idea what's going on?
SMD
|
|
|
|
|
|
I am getting some other article 
"Every morning I check Forbes 40 richest Indians list , if i'm not there I go to work."
|
|
|
|
|
|
Hello experts,
I am writing an application in Solaris, which is supposed to work on PrimePower 650 and SunFire 440 machines. The application listens to the events raised by the Hardware and OS in /dev/log. The application listens to the messages logged into /dev/log and do some processing on them. Now, when there is a load condition occuring at /dev/log(i.e. number of messages per second ocurring at /dev/log is high), CPU consumption by my application shoots up to 50%, while my application is expected to consume not more than 1% CPU.
Now, I want to bring down the CPU consumption to 1%. Since the CPU consumtion can vary according to various CPU configurations, i have to ensure that the CPU consumption remains below 1% for low end CPUs.
Thanks in advance.
Currently to solve this problem, i am using the following technique:
1.Process is only reading 5 messages per second from /dev/log and process them. The process sleeps for rest of the time per second.
2. Every 100 messages, the process sleeps for 5 seconds.
This solution brings down the CPU consumption. On some CPU configurations, it is less than 1% CPU consumption. But on others still varies from 3-13%.
Please tell me if the processing delay technique used has some fundamental faults, or what is the correct technique of introducing processing delay for controlling CPU consumption.
Please also tell your suggestions for controlling CPU consumption. I would also appreciate , if you can redirect me to some links where i can find CPU consumption control techniques and fundamentals.
Thanks and regards.
|
|
|
|
|
Asking the same question over and over will not change the answer!
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
software will display unicode under English windows xp (with unicode font installed).
The menu, all kinds of views, and dialog will display unicode.
Thanks
-- modified at 13:36 Monday 6th February, 2006
|
|
|
|
|
Dear Coders,
Any one of you possess the RSS Barcode Technical Specifications?
Help me out! I am in need of it!
NKR
|
|
|
|
|
|
Thanks, but this information is not sufficient for the Coder to implement the Solution for the RSS Barcodes.
Thanks Once again for your valuable efforts!
|
|
|
|
|
i am looking on the net for a long time for an example code that shows how can i resolve Channel.
can somebody write a simple Article that shows how to write PCF command for admin?
thanks.
|
|
|
|
|
Can any one please send me a descriptive article about the new technology AJAX?
fwefe
|
|
|
|
|
|
|
[I posted this in the "Visual C++" group by mistake. Apologies if you've already read it there.]
I recently had a bit of an issue where I was looking for a string tokenizer component. I posted on c.l.c.m, and was informed that STLSoft had one called "string_tokeniser" (note spelling). This both amused me and irritated me cos I use STLSoft and had done a search (for "tokenizer") and found nothing.
My experience of STLSoft over the last 2-3 years is that the code's great but the docs suck. So I posted on their newsgroup, complaining about the yawning gap between the quality of the code and the docs, and also asked why the author(s) doesn't post to Code Project.
It was good that I got a swift reply, but like a bad lawyer who doesn't know the answer to the question (s)he's asked, I got snapped on my own challenge, as Matt Wilson from STLSoft asked if I would consider posting to CP. So, I've created a new account - forgot my old details :$ - and will have a go at putting my size 12 where mt mouth is.
So, I was wondering whether anyone in CP already used STLSoft (http://stlsoft.org/[^]), and whether they'd had any experiences - good or bad - that might tallie with mine, as a good place to start.
Fanks
Danny T
-- Ain't no monolithic framework yet worth the hassles --
|
|
|
|
|
Have you looked at Boost[^] - Specifically the tokenizer[^] class. Any time I'm looking for something for C++ I first see if STL can do it then I check Boost.
Steve
|
|
|
|
|
Hello,
Am looking for something that allows me to manipulate displayed text. This is what I am doing
1.To the dialog, I add a Static Text
2.Chage the ID to IDC_xyz
3.Add a member variable for this IDC
4.Display text using this member variable
Now what I want to do is manipulate the font and color so that it looks more colorful or bigger!! But I cant seem to find anything. I had a look at CCreditsCtrl but it throws a Run-Time error. Since I am a newbie at this,was hoping someone could help me out.
|
|
|
|
|
|
Ok now I know I am going to make a complete fool of myself.
I had a look at CLabel .The problem is that the Static Text has to be mentioned before initialisation itself on the Dialog Box. I dont want tht. Basically I am writing an edcational program so I want to display dynamically generated text and it is the same text that I want to modify.
Thank you for your help anyway.
|
|
|
|
|
Ok, I figured out how to use CLabel for my program. However I dont quite know how to use the SetLoadCursor(LoadCursor.....).
I keep getting c2664(if I remember correctly) which says that it cannot convert parameter 2 fm int to .....
The thing is that I add the hand.cur to the Resource under the Cursor resource and then pass it as the 2nd parameter. .
Am i doing something wrong?
-- modified at 7:37 Wednesday 25th January, 2006
|
|
|
|
|
hi,
i have found plenty of articles about outlook.
In them i have found ,how to create commandbar button on explorer windows. but i am unable to find the article which can explain to create commandbar button on inpspector window with sample code.
And also how to edit the message,which will be sent afer editing
regards,
RamakotesaraRao
spend every minute for success
|
|
|
|
|
|
Hi
please tell me How to check data existing with sql command in c# before inserting new row
if data exist in table don't enter again
thanks
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
