Click here to Skip to main content
15,921,646 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralBackup & Restore Database Pin
vaani3-Jan-08 18:51
vaani3-Jan-08 18:51 
GeneralRe: Backup & Restore Database Pin
John_Adams4-Jan-08 1:52
John_Adams4-Jan-08 1:52 
QuestionProduce reports. Any help plz? Pin
tellytub3-Jan-08 16:57
tellytub3-Jan-08 16:57 
GeneralRe: Produce reports Pin
Christian Graus3-Jan-08 17:17
protectorChristian Graus3-Jan-08 17:17 
GeneralRe: Produce reports Pin
tellytub3-Jan-08 21:23
tellytub3-Jan-08 21:23 
GeneralRe: Produce reports Pin
Christian Graus3-Jan-08 23:47
protectorChristian Graus3-Jan-08 23:47 
GeneralRe: Produce reports. Any help plz? Pin
Tom Deketelaere4-Jan-08 5:25
professionalTom Deketelaere4-Jan-08 5:25 
GeneralRe: Produce reports. Any help plz? Pin
tellytub4-Jan-08 23:13
tellytub4-Jan-08 23:13 
Hi TD, thanks for the reply.

Your assumptions:
1) I use ReportViewer (am using Microsoft Visual Studio 2005 btw) from the Toolbox to create reports. I do not use Crystal Report (I just use Windows Form).

2) Do you mean the SQL select query for listing contracts due for renewal in 3 months? If so, yes I know the query.
SELECT Contract_ID<br />
FROM Contracts<br />
WHERE DateDue BETWEEN GetDate() AND DateAdd(mm, 3, GetDate())



Do you have any idea how to do a report which list contracts due for renewal in 3 months (which is not one of the database attribute)?

Previously how I created my report(drag and drop):
like this

Can you help me please? Thanks in advance.

telly
GeneralRe: Produce reports. Any help plz? Pin
Tom Deketelaere7-Jan-08 1:04
professionalTom Deketelaere7-Jan-08 1:04 
QuestionDisplay String With Quotes Pin
Dan Suthar3-Jan-08 15:05
professionalDan Suthar3-Jan-08 15:05 
GeneralRe: Display String With Quotes Pin
Christian Graus3-Jan-08 15:15
protectorChristian Graus3-Jan-08 15:15 
AnswerRe: Display String With Quotes Pin
Nilesh Hapse3-Jan-08 18:32
Nilesh Hapse3-Jan-08 18:32 
AnswerRe: Display String With Quotes Pin
Dan Suthar3-Jan-08 23:36
professionalDan Suthar3-Jan-08 23:36 
GeneralFill By Methods Vs. Binding Source Pin
AAGTHosting3-Jan-08 12:43
AAGTHosting3-Jan-08 12:43 
GeneralRe: Fill By Methods Vs. Binding Source Pin
Dave Kreskowiak3-Jan-08 14:24
mveDave Kreskowiak3-Jan-08 14:24 
Generala coding problem Pin
s3rro3-Jan-08 10:42
s3rro3-Jan-08 10:42 
GeneralRe: a coding problem Pin
Dave Kreskowiak3-Jan-08 10:58
mveDave Kreskowiak3-Jan-08 10:58 
GeneralRe: a coding problem Pin
Ray Cassick3-Jan-08 11:30
Ray Cassick3-Jan-08 11:30 
QuestionApplication exits without error message Pin
Volker Weichert3-Jan-08 9:06
Volker Weichert3-Jan-08 9:06 
GeneralRe: Application exits without error message Pin
Christian Graus3-Jan-08 11:12
protectorChristian Graus3-Jan-08 11:12 
GeneralRe: Application exits without error message Pin
Volker Weichert4-Jan-08 1:55
Volker Weichert4-Jan-08 1:55 
GeneralCannot cast from ControlCollection to ControlCollection Pin
Ed Hill _5_3-Jan-08 6:30
Ed Hill _5_3-Jan-08 6:30 
GeneralRe: Cannot cast from ControlCollection to ControlCollection Pin
Ed Hill _5_3-Jan-08 6:34
Ed Hill _5_3-Jan-08 6:34 
GeneralRe: Cannot cast from ControlCollection to ControlCollection Pin
Dave Kreskowiak3-Jan-08 7:16
mveDave Kreskowiak3-Jan-08 7:16 
GeneralRe: Cannot cast from ControlCollection to ControlCollection Pin
Ed Hill _5_3-Jan-08 22:25
Ed Hill _5_3-Jan-08 22:25 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.