Thanks everyone for the input to my question.
After having a meeting yesterday with a lot of "big-wigs", they basically didn't even read the javascript I had on the page which flashes saying "Allow pop-ups for this site" in very big letter, along with a big help icon as to why to do so.
I just...
ca8msm,
Thanks for your patience and help!
I wasn't handling my control structure correctly.
If there was no "|", I wasn't handling it properly when I ran a database query to make sure the user didn't select a name, then try to edit it on the fly.
So, I needed to say if there's no "|" and...
...and....it's my datagrid update command.
If the user tries to update a name, and doesn't use the autosuggest text box's dropdown list, then I wanna exit the sub and display the error message.
Here's my code, but it's not getting caught:
If Len(Trim(txtASBRes.Text)) > 0 And InStrtxtASBRes.Text, "|") = 0 Then
'Means there are characters for the Resource code
' and no pipecleaner = didn't use ddl for name
lblResCodeWarn.Visible = True
lblResCodeWarn.Text = "* Use list!"
Exit Sub
End...
Let's say I have the three groupings from most outter to the inner:
1.U.S. four quarters (North, South, East, West)
2. U.S. 50 States (so, each of the 50 states)
3. Each states's top two city's measured by population
...and the sum() is for energy consumption in whatever, let's say Kilo-Watts...
Hmmm...well, Distinct didn't work. I was sceptical for it to be that simple.
If I use runningvalue, that's not giving me what I want. I can't tell the higher group(first grouping) to reset on a lower group (2nd grouping) like in Crystal. I has to be the group itself or I get an error in the...
xlbo,
Well, I just used the same scenario I had before when using the simple sum(), but did a "Distinct" in my SQL.
That seemed to do the trick.
Any downers to that?
Thanks!
I can perform this running total easily w/ Cyrstal reports via the "Running Total" window where:
1. I want a certain expression, here would be the sum of a money column
2. I want it to total on this certain grouping
3. I want it to reset on this certain grouping
So, let's say I have three...
In our appliation, we have a "Close" button, that when the users click it, we update the records just in case as a safety net...this was by design when the application was first developed.
Is there a way to check to see if the whole row (about 25 columns) has changed w/o having an Update...
Hello!
I just ended up using a DIV tag w/in the page via CSS.
I tested the page w/ both IE6 and 7.
Since we started off asking the user if they would or wouldn't like to perform a step, we took that out and simply presented them with the final form to fill out and a "Close" button at the top...
adam0101,
Tried this but still same as before with pop-up question to close the page (thanks for the suggestions though):
<HEAD>
<SCRIPT language="VBScript">
Sub Window_Onload
window.opener = "self;"
End Sub
</SCRIPT>
</HEAD>
..in body:
<INPUT type="button" value="Close"...
Does SSRS 2005 have the issue fixed as to when the user exports a report to .xls format and the report contains a subreport?
In SSRS 2000, if there was a subreport in the main report, and the user exported the report to .xls, then it would just display an error message.
Thanks!
I have a window that's opened via a hyperlink from a parent window.
If I try to close this "child" window with a simple self.close(), I get the prompt:
The web page you are viewing is trying to close the window
Here's my HEAD code:
<SCRIPT language="VBScript">
Sub Window_Onload...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.