|
Dear All,
I have a SQL database with 3 columns A, B, C. Under these 3 columns, there are 100 entries.
I want each row to be printed on each page of crystal report, so that i get a separate page for each row entries of the database.
Can someone suggest me how to implement this?
Regards
R.S.
|
|
|
|
|
You can check with crystal reports, from report field explorer, there is a field called Group Fields, there if you give your field as a group field, then your reports will be seperated by the same manner.
For Details, suppose your report like
S.No..Name...............Category
1.....Mr.Dave Kresoik....MVP
2.....You................Learner
3.....Me.................Learner
Now I added a Group By Field as Category, then PAGE-1
S.No..Name...............Category
1.....Mr.Dave Kresoik....MVP
And PAGE-2
S.No..Name...............Category
1.....You................Learner
2.....Me.................Learner
|
|
|
|
|
H0=[3/(5*sqrt(2)),4/5;-1/20,-3/(10*sqrt(2))];
H1=[3/(5*sqrt(2)),0;9/20,1/sqrt(2)];
H2=[0,0;9/20,-3/(10*sqrt(2))];
H3=[0,0;-1/20,0];
G0=[-1/20,-3/(10*sqrt(2));1/(10*sqrt(2)),3/10];
G1=[9/20,-1/sqrt(2);-9/(10*sqrt(2)),0];
G2=[9/20,-3/(10*sqrt(2));9/(10*sqrt(2)),-3/10];
G3=[-1/20,0;-1/(10*sqrt(2)),0];
H=[H0,H1,H2,H3];
G=[G0,G1,G2,G3];
B=zeros(2*k1,2*k2);
for i=1:4:2*k1
if (i+7)>(2*k2)
B(i:i+1,i:i+3)=H(1:2,1:4);
B(i+2:i+3,i:i+3)=G(1:2,1:4);
B(i:i+1,1:4)=H(1:2,5:8);
B(i+2:i+3,1:4)=G(1:2,5:8);
else
B(i:i+1,i:i+7)=H;
B(i+2:i+3,i:i+7)=G;
end
end
and the code
[k1,k2]=size(A);
WW2=gen2(k1/2,k2/2);
FF=ipermutesub(A);
FT=FF';
EE=ipermute2(FT);
DPP=WW2'*EE;
DD=icspreproc1(DPP);
CPP=DD';
CC=ipermute2(CPP);
AAP=WW2'*CC;
B=icspreproc1(AAP);
|
|
|
|
|
Soooooooo......what's the question?
|
|
|
|
|
I have a context menu running for a vb.net windows service controller I've created.
Folks can turn the windows service on and off with the application. I change the caption for the local mene each time the user changes the service status. (Startup service/ shutdown service)
This works great until somebody changes the service status independantly of my service controller. Then the captions don't match.
I'd like to capture the "right click" event of my context menu, so to speak, to make certain I have my service's status displayed correctly. I don't know how to do this with a dynamically created context menu.
I can add events associated with specific menuitem w/i my context menu without issue.
|
|
|
|
|
It's not very clear where you want this code to run. Are you saying that you have a context menu that pops up on a right-click of a form or some other control and you want to update the status then? Or do you want to update the status when right-clicking an item in the context menu??
It's easy to wire up the events using AddHandler. You just have to write the method up with the correct header, matching what the event you're going to use expects.
|
|
|
|
|
JaeBeam wrote: This works great until somebody changes the service status independantly of my service controller. Then the captions don't match.
Would it be an option to get the latest status and setting the caption, just before the menu is about to pop up? In that case, you could wire up the PopUp[^]-event, and set the caption from there.
I are Troll
|
|
|
|
|
Is it possible to use all the Queries in Single DataAdapter, Dataset?
Also Iam using like the following
Dim Query1="Select * from Table1"
Dim DAp1 as SqlDataAdapter,Ds1 as new Dataset
Dim Query2="Select * from Table2"
Dim DAp2 as SqlDataAdapter,Ds2 as new Dataset
Dim Query3="Select * from Table3"
Dim DAp3 as SqlDataAdapter,Ds3 as new Dataset
con.open
DAp1=New SqlDataAdapter(Query1,con)
DAp1.Fill(Ds1)
DAp2=New SqlDataAdapter(Query2,con)
DAp2.Fill(Ds2)
DAp3=New SqlDataAdapter(Query3,con)
DAp3.Fill(Ds3)
con.close
Instead, Dap1.Tables(0), DAp1.Tables(1), DAp1.Tables(2) like wise, how to fill all in a single Dataset from SQLDataadapter?
THANKS
|
|
|
|
|
You can use multiple tables in the same data set. But, you cannot use a single DataAdapter to fill it. The DA's only work with queries that work on a single database table at a time. You CAN, like in your example, use multiple DA's on the same dataset.
|
|
|
|
|
i hav a table with schema
id int
name varchar
i declare trow as personrow
i bind it to a gridview onselectedindexchange i got the row selected by user as
dim row as gridviewrow = gridview1.selectedrow
how can i cast row to personrow
|
|
|
|
|
You don't. A GridViewRow represents the row in the GridView control, not the data inside it. You can use the returned GridViewRow object's DataItem propety to get a reference back to the data item that row is bound to.
|
|
|
|
|
hi
I form a loop display all do
|
|
|
|
|
In what context?
Are you trying to get the form names and show them in a list or are you really trying to show every form in your app?
|
|
|
|
|
Hi all,
has anybody work with data format "jdf"?
For example reading and writing?
Thanks for help
|
|
|
|
|
Is this a survey question or did you have an actual problem you were trying to solve?
Your best source of information on JDF is going to be Adobe.
|
|
|
|
|
scenario:
I have a Sql Server in Rome and a shared server dir (with the access database)
on a Server in New York.
I have permission on sever dir and databse.
The database table on sql Server have exactlly the same structure of Access
table database. (the table on Sql Server have 200.000 records and 48 columns).
Now i want to recopy all records from Rome(sql server) to NewYork (Access
database).
Wath is the best way in terms of time to recopy all records fom sql server to
access database.
note:
I want to use in my app the ADO drive and vb6 classic.
naturally other way are welcome![Smile | :)](https://codeproject.global.ssl.fastly.net/script/Forums/Images/smiley_smile.gif)
|
|
|
|
|
sal21 wrote: Wath is the best way in terms of time to recopy all records fom sql server to
access database.
One option is to Replicate[^] it
I are Troll
|
|
|
|
|
Hi Eddy.... tks for tip but sure not for me i know only VB6...
Can you post a code to use with vb6 classic?
Tks for patience.
Sal.
|
|
|
|
|
Hi Eddy....
tks for tip but sure not for me i know only VB6...
Can you post a code to use with vb6 classic?
Tks for patience.
Sal.
|
|
|
|
|
sal21 wrote: Hi Eddy....
tks for tip but sure not for me i know only VB6...
Can you post a code to use with vb6 classic?
Replication is done over SQL Server, and it doesn't speak VB6, only SQL. You should be able to talk to your Access-database using VB6 and ADO without any problems.
Alternatively, you could write some code in VB6 to do the import manually; creating an ADODB.Connection to SQL and writing it in your Access database. I'm going to guess that that's the code that you're interested in?
I are Troll
|
|
|
|
|
I have tested this way but the code run very, very slow...
Tell me if thei prob is your and post me a vb6 code![Smile | :)](https://codeproject.global.ssl.fastly.net/script/Forums/Images/smiley_smile.gif)
|
|
|
|
|
sal21 wrote: I have tested this way but the code run very, very slow...
sal21 wrote: (the table on Sql Server have 200.000 records and 48 columns).
SQL Server and Microsoft Access don't store their data in "exactly" the same way. Moving 200k records takes time. How long did it take?
Replicating to a linked server is the easy and painless way. Yes, it's possible to do it manually. Yes, you can read the data from SQL Server, and update it in Microsoft Access. That it's possible doesn't make it a good idea though.
Do you only need a read-only copy, or is it required to update the SQL Server-data with the changes in the Access-database? If you're satisfied with a read-only copy, then you could simply copy each table into an empty Access database. Should indeed be faster than replication.
Your best option would then be to execute an select into or something similar, from your SQL Server into your linked server. That would at least be a lot easier than reading data from connection 1 and writing it into connection 2.
sal21 wrote: Tell me if thei prob is your and post me a vb6 code
I can't write any specific VB6-code without seeing the physical server. I'll require a plane-ticket from Maastricht to Rome and lot's of coffee
I are Troll
|
|
|
|
|
Two questions from a VB.Net beginner:
1. How can I center text in a table cell in a Word document that I have created with VB.Net?
2. How can I make the first row of my table repeat at the top of each page on which the table carries over?
I can't find the methods in visual basic for either action.
Thanks
Bill
|
|
|
|
|
Well, I will answer my own questions.
bhogsett wrote: 1. How can I center text in a table cell in a Word document that I have created with VB.Net?
'center all the text
oTable.Rows.Alignment = Word.WdRowAlignment.wdAlignRowCenter
bhogsett wrote: 2. How can I make the first row of my table repeat at the top of each page on which the table carries over?
oTable.Rows(1).HeadingFormat = True
I needed to place the above after the with that applied a style (Contemporary) to the table.
oTable is obviously the table object.
I found it very difficult to find these answers.
Bill
|
|
|
|
|
Hi,
I wonder if anyone can help me with the error I am getting when I try and run my application in VB 2008.
"Form1.vb cannot be modified at this time"
I have tried Tools/Option/Build and Run/ Don't save any changes.
This does not work and I would want the choice to save changes everytime I run my app.
When I put say a button on the form the first time, it works. If I add another say button then that is when I get the problem. Basically adding anything to a form gets the error.
modified on Thursday, January 14, 2010 4:13 AM
|
|
|
|