|
hi,
1. yes its possible to change the query at runtime.
2. cryrpt.SqlQuery
3. try checking the fields in the report and fields you give in the sqlquery, both should match.
hope this works
Nitin...
|
|
|
|
|
what do you mean by its possible??
you have a dataset fill it bu the query you want, btw the you can the crystal report all of it by run time you can let the user select the grouping field and the fields to appear and the sorting on any field the user want,
you have to search more for your question it seems to me that this this the first time you use the crystal report,
search on the net to find how we can use the crystal reports
Regards
|
|
|
|
|
U cant ask Dummy question like this , search and find the Answer
<big><small>WE ETHIER FIND A WAY OR DIE TRIEN</small></big>
Mohamad A. Flefel
mflefel@hotmail.com
+962 79 5963865
C#.net & VB.net Developer
|
|
|
|
|
How do I automatically resize the Form when the screen resolution changes between design-time and runtime
Regards
Suman
|
|
|
|
|
By setting the anchor or dock properties on your controls.
|
|
|
|
|
I am using vs2003 for a vb.net windows app.
I need to create a web browser app that saves password that login to a web site. Theses user accounts are in a database that I can change. The web browser app shares theses login accounts for more users. The web browser app manages current users and kick them off when more users join the wait queue. Micro share accounts.
The problem I am running into is that javascript popups, like calling a javascript function that uses window.open, jump out of my app and opens in the default web browser.. and needs to be kept in my browser app. When it opens in default web browser the login authorization falsea and then requires them to login. I currently hide the login screen from the user and can't let them see it.
What work arounds can I do?
|
|
|
|
|
Hi all, I am quite new to VB.NET.
I need a subroutine that will download a file from the internet and place it in a folder location.
Can anyone advise me on how to do this?
many thanks
|
|
|
|
|
Use the following method
my.Computer.Network.DownloadFile
|
|
|
|
|
Hi.
How to get alert message on my computer whenever a new record come in table?
I want to get alert message on my computer when a new record will come in table.
Actually i am working on asp.net.
I am creating a web application for customer support and when user will visit our site then i will get alert message on my computer by windows application.
have any idea about it?
please reply me.
imran
|
|
|
|
|
So is the PC you're using the server ? Or is it on the same network as the server ? You can run a trigger when a record is added, but unless it's SQL Server 2005, you can't run C# or VB.NET code inside the database ( nor does the database offer external triggers ). The other option is to perform your action in the ASP.NET app, in the code that also makes the database call.
Really, the obvious thing to do is to send an email when making a DB call that inserts a record.
|
|
|
|
|
I want to replace Third party controls Shridan & Farpoit which I have used for Spreadshit and splittcontrol how it is possible?
pl. give me solution for this.
email: nileshjs@hcl.in
nilesh
|
|
|
|
|
The API is going to be different if you use Excel ( for example ), so you have a big job in front of you. There is no forum post answer that will help you.
|
|
|
|
|
I am developing my application using 1024x768 pixel setting.
Using VB.Net code can I resize the application form
automatically in a different pixel setting (e.g 800x600).
Can anybody help me?
Regards
Suman
|
|
|
|
|
What do you want to do ? You can set up the form so that controls resize when the form resizes, by setting the Anchor or Dock properties. You can set the size of a form, but I don't think that is what you want.
|
|
|
|
|
u can Read the Screen Resolution by using screen.x and screen.y
Mohamad A. Flefel
mflefel@hotmail.com
+962 79 5963865
C#.net & VB.net Developer
|
|
|
|
|
so.. then what to do !!!!!!!!!!!
When you get mad...THINK twice that the only advice
Tamimi - Code
|
|
|
|
|
MAN MEN TAL3LE ENT EGLEB WEJHAK
WE EITHER FIND A WAY OR DIE TRIEN
Mohamad A. Flefel
mflefel@hotmail.com
+962 79 5963865
C#.net & VB.net Developer
|
|
|
|
|
BL MONASABEH, BDNA NETL3 EL YOUM,JASEM TAYYASAT MA3O
OK, E7KE M3NA BS TRAWE7
BTYE
Mohamad A. Flefel
mflefel@hotmail.com
+962 79 5963865
C#.net & VB.net Developer
|
|
|
|
|
how to Pass range of values from VB to crystal report
I have an order table in access.I want to print orders from 1 to 10 or like that.(values entered in two text boxes).I have created the crystal report,it is working smoothly when giving the range values.
But through Vb I wrote
orders.orderid>=value1 and orders.orderid<=value2
If I give value1=5 and value2=7 it is showing properly.I change the the value1 it is working.But if I change the value of value2 it is not refreshing.always the value of value2 remains the first value(the value given for the first time.)
|
|
|
|
|
Not sure I understand your question, but I suspect you may have problems with DataTypes. In what format is the Order No stored in your Database (Text or Number) I would use numbers so rather take the textbox value and convert it before writing to the database. Alternatively if you want to keep the order as text, pad the OrderNo with leading zeroes (in other words use 000001 instaed of 1)
|
|
|
|
|
I converted the text value to number.now its working.thank you so much.
|
|
|
|
|
i have no idea wat can i do to show the status of an action. Example like i have schedule a action to be done by 5pm today and in my DB i have a colunm call Status. wat can i do to allow my DB to update itself once the action is done?
|
|
|
|
|
You'll have to add code to the "action" to call some kind of status update routine to update the field in the database. It's not going to change on its own.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Sorry.. i dun really understood wat u meant. wat "action" u toking about. Do u have any example of my problem?
|
|
|
|
|
 You said "action" in your original post! What that "action" is, you have to code is so it updates the status you want.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
