Hi, I want to group by a report item, but that's not allowed. So I tried creating a parameter...not allowed as well. Tried referencing from footer...failed again. This is somewhat complicated. Let me explain: I have textbox22, it's value is: =Code.Calc_Factor(Fields!xx.Value, fields!yy.Value...) This is embedded VB code in the report ...
Trying to build a GUI application in Java/Swing. I'm mainly used to "painting" GUIs on the Windows side with tools like VB (or to be more precise Gupta SQLWindows .. wonder how many people know what that is ;-)). I can't find an equivalent of a Group Box in Swing .. With a goup box, you have a square box (usually with a title) around...
I'm looking to build a "quick link" directory access widget. e.g. (option 1) 0-9 | A-F | G-K | L-P | Q-U | V-Z Where each would be a link into sub-chunks of a directory starting with that character. The widget itself would be used in multiple places for looking up contacts, companies, projects, etc. Now, for the programming part... ...
Hi all, I have a table like this (Oracle, 10) Account Bookdate Amount 1 20080101 100 1 20080102 101 2 20080102 200 1 20080103 -200 ... What I need is new table grouped by Account order by Account asc and Bookdate asc with a running total field, like this: Acc...
Originaly posted a while back on a different forum, hope I can find a bit more help here :) Hi Guys, I'm sure this is a pretty basic question, but I'm new to much programming and C#. I find I need to clear databindings on several controls and currently have: lblTableValue1.DataBindings.Clear(); lblTableValue2.D...
Heyall, Is it possible I make a simple query to count how many records I have in a determined period of time like a Year, month or day, having a TIMESTAMP field, like: SELECT COUNT(id) FROM stats WHERE record_date.YEAR = 2009 GROUP BY record_date.YEAR Or even: SELECT COUNT(id) FROM stats GROUP BY record_date.YEAR, record_date.MONTH...
I want to convert the following query into LINQ syntax. I am having a great deal of trouble managing to get it to work. I actually tried starting from LINQ, but found that I might have better luck if I wrote it the other way around. SELECT pmt.guid, pmt.sku, pmt.name, opt.color, opt.size, SUM(opt.qty) AS qtySol...
Hi, I need your help, I have developed a comparative report like this: 01:00 02:00 Desv 10 23 15/01/2009 20 22 16/01/2009 30 45 I have a dataset with values from two different dates every 15 minutes. I have a matrix which is grouped by row Date and grouped by column ...
I am using an ItemsControl bound to a CollectionViewSource. I set its ItemsPanel to a WrapPanel (with orientation initially set to horizontal) and am using a button to toggle between horizontal and vertical orientation. Basically changing the ItemsPanel to point at different resources, inside the button click handler. This works fine. ...
Is it possible to make a group and sort conditional? If so, is it possible to somehow do this based on the value of a textbox item? I thought I could just set the Expression of the group and sort to something like =IIF(ReportItems!TheTextBox.Value = 0, 0, Fields!FieldName.Value), which would be perfect, but it doesn't allow me to use Re...
I have to use DevExpress's Xtra Reports which is in a third-part app. I have a group header that displays 'State' but grouped by 'Sum(Payment_Amount)' in descending order of the total and not the name of the state (This is a requirement.). Group Header: State Detail: Each item in this State | Payment_Amount Group Footer: Sum(Payment_...
My data table looks something like this (first row = column names): Name; Number; Group 1; Group 2; Group 3; Leslie; 555-555-5555; Y; N; Y; John; 555-555-1234; N; Y; N; Mary; 555-555-2222; Y; Y; N; James; 555-555-3333; N; N; Y; Sue; 555-555-4444; Y; Y; Y; I want my report to look like this: Group Name 1 Leslie; 555-555-55...
Is it possible to group in jqgrid without using subgrids ? I just want a heading that spans all columns with the group title, not a subgrid with different headings. The only examples of grouping I can find seem to use a full subgrid. ...
I need to add a row dynamically in SQL after the Marketer number changes with the header "Marketer Total" that should add only the "Total" column. For example, after the last row of Marketer 22 row, there should be "Marketer Total" and then under the Total column should be 1804. The same should occur after the last row of Marketer 500....
I have some data that must be presented in tabular form with multiple sections. In particular, Each section of data is broken up (with it's own headers) by day. This is basically a one-off single page deal, and won't really be maintained, so I don't want to put a lot of effort into architecture. I have two tables. HEADERS and ITEMS. ...
I've got a student table and an enrollment table; a student could have multiple enrollment records that can be active or inactive. I want to get a select that has a single student record and an indicator as to whether that student has active enrollments. I thought about doing this in an inline UDF that uses the student ID in a join to ...
Anyone know of an algorithm that will group pictures into events based on the date the picture was taken. Obviously I can group by the date, but I'd like something a little more sophisticated that would(might) be able to group pictures spanning multiple days based on the frequency over a certain timespan. Consider the following grouping...
This follows on from this question: http://stackoverflow.com/questions/624206/modify-xml-in-sql-server-to-add-a-root-node/ In addition to the problem posed and now fixed in that question, I am also splitting the existing table into 2, where the 2nd table is a sub-table of the first, with a foreign key back to the first. So currently ...
Hi, I have an XML like this <ContractInfo ContractNo="12345"> <Details LastName="Goodchild"> <Filedata FileName="File1"/> </Details> </ContractInfo> <ContractInfo ContractNo="12345"> <Details LastName="Goodchild"> ...
I need sphinx to sort the results by the sum of an attribute. I need to: Group the results by their IDs (done) Sort the results by the SUM of one attribute I can't find a way to sum this attribute. How could I do this? (Im using sphinx PHP API) ...