Click here to Skip to main content
15,905,616 members
Home / Discussions / Database
   

Database

 
QuestionSetting PRIMARY KEY using Alter Table Pin
Widgets13-Oct-07 0:02
Widgets13-Oct-07 0:02 
AnswerRe: Setting PRIMARY KEY using Alter Table Pin
GuyThiebaut13-Oct-07 0:40
professionalGuyThiebaut13-Oct-07 0:40 
AnswerRe: Setting PRIMARY KEY using Alter Table Pin
Mike Dimmick13-Oct-07 2:24
Mike Dimmick13-Oct-07 2:24 
GeneralRe: Setting PRIMARY KEY using Alter Table Pin
Widgets21-Oct-07 0:03
Widgets21-Oct-07 0:03 
QuestionDataGridView Filter Pin
udikantz12-Oct-07 22:13
udikantz12-Oct-07 22:13 
AnswerRe: DataGridView Filter Pin
GuyThiebaut12-Oct-07 22:35
professionalGuyThiebaut12-Oct-07 22:35 
GeneralRe: DataGridView Filter Pin
udikantz12-Oct-07 22:37
udikantz12-Oct-07 22:37 
QuestionSSRS embedded code and dynamic columns Pin
dove1112-Oct-07 9:08
dove1112-Oct-07 9:08 
The first 3 columns of my report are dynamic, depending entirely on parameters passed to the stored procedure. The result set from the stored procedure is used as the dataset in my Reporting Services report. Sometimes there are fields that are not returned in the result set and I wanted to display blanks if they weren't there. I tried all the tricks using iif(isNothing(Fields!field1.Value, "",Fields!field1.Value) and using Fields(Parameters!parm1.value).Value in my argument list. Neither of these worked.
I created 3 textboxes in my report (table) and placed the three different values in them, i.e., Fields!field1.Value, Fields!field2.Value, and Fields!field3.Value. In certain cases, one or two of these fields would not be returned in the result set. I made them hidden. Then in my other textbox, where I wanted to display the value, I added as the expression, Code.DetermineFieldValue(Parameters!parm1.value, ReportItems!txtTextBox1.Value, ReportItems!txtTextBox2.Value, ReportItems!txtTextBox3.Value)
I did this for each of the 3 textboxes, just replacing parm1 with parm2 or parm3.
In the embedded code, the function was defined as:
public function DetermineField(value1 as object, value2 as object, value3 as object, value4 as object) as object
I just refered to my fields as value1 through value4 and it worked. I have been trying this for about a week and couldn't get anything to work. Apparently, it will accept the textbox not having a value, but cannot handle the dataset field directly if it is not returned. It never got to the code. Hope this helps someone.

Dove11
AnswerRe: SSRS embedded code and dynamic columns [modified] Pin
pmarfleet12-Oct-07 9:53
pmarfleet12-Oct-07 9:53 
QuestionReg: SQL DB in Emergency Mode [modified] Very Urgent Pin
P.T.R.K12-Oct-07 7:20
P.T.R.K12-Oct-07 7:20 
AnswerRe: Reg: SQL DB in Emergency Mode [modified] Very Urgent Pin
Skanless12-Oct-07 8:49
Skanless12-Oct-07 8:49 
QuestionDynamic database pathways... Pin
new_phoenix12-Oct-07 6:59
new_phoenix12-Oct-07 6:59 
AnswerRe: Dynamic database pathways... Pin
Hesham Amin12-Oct-07 8:46
Hesham Amin12-Oct-07 8:46 
GeneralRe: Dynamic database pathways... Pin
new_phoenix15-Oct-07 10:41
new_phoenix15-Oct-07 10:41 
QuestionSQL statement on website, global password Pin
Cory Kimble12-Oct-07 6:57
Cory Kimble12-Oct-07 6:57 
AnswerRe: SQL statement on website, global password Pin
andyharman12-Oct-07 8:18
professionalandyharman12-Oct-07 8:18 
GeneralRe: SQL statement on website, global password Pin
Cory Kimble15-Oct-07 4:21
Cory Kimble15-Oct-07 4:21 
GeneralRe: SQL statement on website, global password Pin
andyharman15-Oct-07 8:29
professionalandyharman15-Oct-07 8:29 
Questiona problem about stackoverflow Pin
nibabug12-Oct-07 3:27
nibabug12-Oct-07 3:27 
AnswerRe: a problem about stackoverflow Pin
Pete O'Hanlon12-Oct-07 4:44
mvePete O'Hanlon12-Oct-07 4:44 
GeneralRe: a problem about stackoverflow Pin
nibabug12-Oct-07 15:26
nibabug12-Oct-07 15:26 
GeneralRe: a problem about stackoverflow Pin
nibabug12-Oct-07 15:36
nibabug12-Oct-07 15:36 
QuestionChecking Duplicate values in Database Pin
codingrocks12-Oct-07 2:25
codingrocks12-Oct-07 2:25 
AnswerRe: Checking Duplicate values in Database Pin
Pete O'Hanlon12-Oct-07 2:31
mvePete O'Hanlon12-Oct-07 2:31 
AnswerRe: Checking Duplicate values in Database Pin
Skanless12-Oct-07 5:33
Skanless12-Oct-07 5:33 

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.