• RELEVANCY SCORE 4.18

    DB:4.18:'Total' In Grid Charts da





    Hi all,

    How to display the total on both sides(horizontal and Vertical) in a grid chart?

    PS: just like attached excel snapshot

    any help would be appreciated.

    Regards,

    Susvith

    DB:4.18:'Total' In Grid Charts da


    It should be possible if you create two new dimensions in the script based on the two you use in the chart. Suppose you have a dimension Product:

    ProductAppleBananaChocolate

    The new table would look like this:

    ReportProductProductAppleAppleBananaBananaChocolateChocolateTotalAppleTotalBananaTotalChocolate

    Now you can use ReportProduct in the grid chart instead of Product to show the totals too.

  • RELEVANCY SCORE 3.43

    DB:3.43:Grid In Bar Charts/Trend Charts..Etc cc





    Is there any way to modify the grid when you run reports? I know they can either be displayed or not, but looking to eliminate the first graph.

    DB:3.43:Grid In Bar Charts/Trend Charts..Etc cc


    There isn't currently a way to modify the grid unfortunately.

  • RELEVANCY SCORE 3.33

    DB:3.33:Report Builder 3.0 Charts Only Total To 99.99% xk




    Is this normal? When I add each column and it's percentage listed in the chart together, they always total 99.99 %.

    DB:3.33:Report Builder 3.0 Charts Only Total To 99.99% xk

    Thanks, I figured as much. Was just looking for confirmation.

  • RELEVANCY SCORE 3.28

    DB:3.28:Linking Charts To Advanced Datagrid Summaries? cj


    Having a hard time finding a way to chart the summaries in an
    advanced data grid. Anyone have any ideas?

    DB:3.28:Linking Charts To Advanced Datagrid Summaries? cj

    Having a hard time finding a way to chart the summaries in an
    advanced data grid. Anyone have any ideas?

  • RELEVANCY SCORE 3.28

    DB:3.28:Wad Themes? sx



    Hi WAD Gurus,

    My doubt in WAD is that, is it possible to change the default theme of Grid/Charts etc in BEx. My default theme is - "TRADESHOW". I'm able to change to other 2 themes, but If I want to add a new theme for a better chart, what is the procedure? Any ideas?

    Thanks,

    Arun Bala

    DB:3.28:Wad Themes? sx


    Thanks Andrew.

    Edited by: Arun Bala G on Sep 17, 2010 5:13 PM

  • RELEVANCY SCORE 3.22

    DB:3.22:Alternate States And Possibility To Connect Charts kj



    Hi Community,

    In my sheet I've created 2 identical multiple box selection, one in Group 1 and the other in Group 2 as alternate states, where Customer, Region, Area, etc... can be selected.

    Then, based on this selections, I've created 2 identical charts, which are not simple charts, but rather charts with expressions in cycle group. Now I'm trying to synchronize these charts, I mean if I choose to see the third expression of the cycle in the chart with group 1, automatically I would like to see the third expression of the cycle even in the chart with group 2, without the need to select again the wanted expression. Is it possible? I've tryed introducing in etl a table with 2 fields: 1 contained the names assigned to the expressions (Total Sales, Total Incomes, etc...), 1 contained the expressions themselves (sum(Sales), sum(Incomes), ...), so that if I selected in the first field the name "Total Sales" then in the chart the relative expression sum(Sales) would be accepeted... and the 2 charts would be synchronized. But it doesn't work till fields and charts have different states.

    Any suggestion? Any idea?

    Thank you so much

    IB

    DB:3.22:Alternate States And Possibility To Connect Charts kj


    Thank you Dariusz, your answer is really useful.

    In the meantime I've found even another way to solve my problem, that is: I set the Alternate State of the charts as 'inherited' or 'pre-defined' and then I imposed Group 1 e Group 2 as Alternate States in set analysis in the expressions. In that way I could introduce for each expression a condition for its visualization, condition connected to an event of selection on a field which I created in etl just to contain the names of the expressions. Then if I select 'Sum Sales' in the field, it will appear only 'Sum Sales' in the charts symultaneously.

    I admit your solution is more complete and flexible, I will find it useful even in the future.

    Thanks again

    IB

  • RELEVANCY SCORE 3.14

    DB:3.14:Gridlayout For Charts m8


    Hi,
    I am trying to display a couple of charts on one window. When I try the following Code to put my ChartPanels in the right Grid, I get the error: Constraint must be a string or null! How can I make it work?
    Thanks

    GridBagConstraints c = new GridBagConstraints();
    c.fill = GridBagConstraints.HORIZONTAL;

    c.gridx = 1;
    c.gridy = 0;
    this.getContentPane().add(chartPanel1,c);

    c.gridx = 2;
    c.gridy = 0;
    this.getContentPane().add(chartPanel2,c);

    DB:3.14:Gridlayout For Charts m8

    Look at the API. You're specifying 1 column:

    http://java.sun.com/j2se/1.4.2/docs/api/java/awt/GridLayout.html

  • RELEVANCY SCORE 3.12

    DB:3.12:How To Make The Current Year Marked In Charts By A Line? (Vs 2008) jp


    Hello everyone,
    We have a lot of charts for our reports (line chart, bar chart, gantt chart, etc.) and need the current year be marked by a line, e.g. with the grid line, in order to show, where we stand currently.

    Does anyone know how to make that? We are using VisualStudio 2008.
    Thanks a lot!
    Char

    DB:3.12:How To Make The Current Year Marked In Charts By A Line? (Vs 2008) jp

    Hi Char360,
    From your description, you want to show only one major gridline in the chart to mark the current year. Could you show me the category fields and the series fields? Which fields area is the year field dropped to, the category fields area or the series fields
    area? This is helpful for us to resolve the issue.
    In Reporting Services, we can control the major gridline by using the Interval and IntervalOffset properties. For example, if we drag the “CalendarYear” field to the category fields area and drag the “SalesAmount” field to the data values area, to display
    only one major gridline for the “CalendarYear” group, we can use the steps below:

    Right-click on the Horizontal Axis and select “Show Major Gridlines”.Select the Horizontal Gridlines. In the “Properties” pane, set the “Interval” to “=Count(Fields!CalendarYear.Value)”.If we set the “IntervalOffset” to “1”, the major gridline will be added to the first value of the category group. We can also set the value by using an expression.

    If you have any questions, please feel free to let me know.
    Regards,
    Mike Yin

  • RELEVANCY SCORE 3.09

    DB:3.09:Images In Grid Chart Possible? dc


    Dear QlikView-users,

    I have a question about the grid chart function in QlikView.

    Is it possible to show alternative looks, such as custom images for each data point instead of the general circles and pie-charts?

    Thanks in advance.Kind regards,

    Aleks

    DB:3.09:Images In Grid Chart Possible? dc


    Can you please help me for how to create QV extensions for the same or how to create the custom object as i am new to qlikview

  • RELEVANCY SCORE 3.08

    DB:3.08:Total And Non-Total Lines In Alv Grid dd



    Hi all,

    Does anyone know if there is any standard SAP functionality for retrieving the non-total/raw item lines that lies beneath a total line in an ALV grid (after the user has selected the total line)?

    All helpful answers will be rewarded!

    Best regards,

    MV

    DB:3.08:Total And Non-Total Lines In Alv Grid dd


    Yes..it is called for each line that is written to the screen.

  • RELEVANCY SCORE 3.05

    DB:3.05:Macro Export On Xls : The Same Format That I Have In Qlikview Charts zj



    Hello All,

    I wish write a macro (vb) to export in xls data! to here no problem, multisheet o more tables.

    But I wish export the same visual format that i have in qlikview charts! color -background and line grid ecc..

    is it possible?

    every advice is important for me

    Thanks a lot

    DB:3.05:Macro Export On Xls : The Same Format That I Have In Qlikview Charts zj


    I'm testing out NPrinting (nprinting.com). It does a good job of exporting your data from QlikView to Excel. To maintain the formats you need to apply them to your Excel template.Hope this helpsJoseph

  • RELEVANCY SCORE 3.03

    DB:3.03:Total Field In Alv Grid zc



    Can i change the values in total column in ALV Grid program. I had made one report with 3 hirerchy level and for first hirerchy i need different total values just for one column as total values are misleading the users. is it possible to change the value total field in ALV?

    DB:3.03:Total Field In Alv Grid zc


    Thanks again for replying. Problem solved.. thanks

  • RELEVANCY SCORE 3.00

    DB:3.00:Controlling Container Positioning pz



    Is it possible to control/change the position of an object within a container? Or possible to change the size of the grid dynamically.

    If I have a container with 3 charts, but one of the charts is only visible in some cases. I would like to reset the grid (without a blank space) when the 3rd chart is not visible.

    Is it possible?

    DB:3.00:Controlling Container Positioning pz


    Instead of Container, use either buttons or Text objects to show the charts conditionally with Actions.

  • RELEVANCY SCORE 2.99

    DB:2.99:Printing Doesnt Work In Oob 1s


    Hello Friends,
    1. Can Print work in Silverlight 4 Apps with OOB?
    2. I am trying to Print LayoutRoot contents but while printing the page is cutting the contents. My content contains Grid Charts.
    Best Regards,
    Krishnpratap

    DB:2.99:Printing Doesnt Work In Oob 1s

    Hi,

    1. Can Print work in Silverlight 4 Apps with OOB?

    From my experience ,you can use the PrintDocument Class which provides printing capabilities for a Silverlight application to open a print dialog box and use the PrintDocument.PrintPage Event to print the silverlight content. I would like to suggest you
    to refer the links below for more information about the PrintDocument Class:
    http://msdn.microsoft.com/en-us/library/system.windows.printing.printdocument(v=VS.95).aspx
    http://msdn.microsoft.com/en-us/library/system.windows.printing.printdocument.printpage(v=VS.95).aspx

    2. I am trying to Print LayoutRoot contents but while printing the page is cutting the contents. My content contains Grid Charts.

    Actually ,you can print the entire Silverlight control by setting the PrintPageEventArgs.PageVisual property to the layout root of the Silverlight content.
    In addition ,here is a sample which describes how to print the DataGrid(or any UIElement) in silverlight ,please check it and see whether it helps.
    http://blogs.telerik.com/silverlightteam/posts/10-01-15/how_to_print_your_datagrid_or_any_uielement_on_multiple_pages_with_silverlight_4.aspx
    Hope it can help you.

  • RELEVANCY SCORE 2.99

    DB:2.99:Linking Analytic Grids And Analytic Charts 31


    Is it possible to link an analytic grid to analytic chart, so that when someone is slicing in the grid the chart accepts the changes as well?

    DB:2.99:Linking Analytic Grids And Analytic Charts 31

    Don't forget that you can set up a filter to act as your slicer for a dimension and then have that filter linked to multiple analytical grids and charts. This will not allow Grid A to drive Chart B but it will allow both to be driven from the same slicer, or even from different functions from the same slicer input. Hope this helps as a work around until we see what is available in beta of V2.Good Luck.

  • RELEVANCY SCORE 2.99

    DB:2.99:Text For Subtotals In Alv Grid ak



    Hi,

    How can we display custom text for subtotals in alv grid?

    Eg: Field1 Field2 Amount

    Total for field1 (Amount Total)

    DB:2.99:Text For Subtotals In Alv Grid ak


    Hi Charles,

    Please go through the below links :

    alv sub total text

    Re: ALV grid Display

    Re: Diplay Subtotals text on ALV GRID Display

    ALV Grid Display - How to display Total and Subtotlal Text ?

    Reward Points if it is useful.

    Regards,

    Prakash.

  • RELEVANCY SCORE 2.98

    DB:2.98:How To Disable The Grid Inside The Line Chart. c3


    Hi friends,
    I don't want to display the grid inside the line chart. Also I want to show a multiple lines in a single line chart(single chart displaying multiple line charts). How can I do it?

    DB:2.98:How To Disable The Grid Inside The Line Chart. c3

    to display multiple lines, you can add a new Series to the Chart for each line
    to not see the grid, you can either set the grid line color or line width
    try this in an app with a Button and a Chart. Each time you click the button a value will be added to each Series.
    Dim rndm As New Random

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
    Dim temp1 As Integer = rndm.Next(0, 31)
    Dim temp2 As Integer = rndm.Next(0, 31)

    Chart1.Series(0).Points.AddY(temp1)
    Chart1.Series(1).Points.AddY(temp2)
    End Sub

    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
    Chart1.Series.Add(Series2)
    For Each cs As Series In Chart1.Series
    cs.ChartType = SeriesChartType.Line
    Next

    With Chart1.ChartAreas(0)
    'set the line color
    '.AxisX.MajorGrid.LineColor = Color.Transparent
    '.AxisY.MajorGrid.LineColor = Color.Transparent
    'or set the width
    .AxisX.MajorGrid.LineWidth = 0
    .AxisY.MajorGrid.LineWidth = 0
    End With

    End Sub

  • RELEVANCY SCORE 2.98

    DB:2.98:Vertical Gridlines In Line Chart f3


    Hi guys,

    I'm quite new in the HTML DB world but I really admire the possibilitys of what you can do with this software.

    For a new project I started using charts. These charts display a usage over time, so I would need a grid that makes it easier to determine the values for a single moment in time.
    My problem is now that I'm not able to show the vertical gridlines in the chart. The horizontal ones show without a problem.

    The documentation is very slim when it comes to the gridlines. The only thing I could find is that the CSS function .gridline takes care of the grid.
    And OEM uses a chart that uses vertical gridlines, so it has to be possible ...

    I searched this forum several times, but everybody seems to be using pie-charts or bar-charts ;o)

    Any help or hints are greatly appreciated!

    -Peter-

    DB:2.98:Vertical Gridlines In Line Chart f3

    Hi,

    I took this up with oracle and currently this is not possible and won't be until after APEX 3.0.
    The only alternative is to 'draw' the lines in SVG. This works well for static graphs.

    Kind regards,
    -Peter-

    ps: above post is also from me.

  • RELEVANCY SCORE 2.98

    DB:2.98:Flash Builder Charts pc



    Any one ever have this. Data source retruns data to grid. And datasource returns data to graph ($ value by month) $ values show on Y axis month name show across X axis but the graphical bars do not show. And there is data values in the datasource and they are returned to a grid using same data source but not showing as bars on graph. Pie chart does same thing.

  • RELEVANCY SCORE 2.98

    DB:2.98:How To Explicitly Set The Header Font Sizes In Grid Constructor Of Alivepdf sx



    Hi All ,

    I am currently developing a flex application which also involves exporting the created charts to a PDF using AlivePDF

    The exported pdf includes a datagrid of the chart values

    For the grid in the pdf,

    var grid:Grid = new Grid ( dp.toArray(), 200, 120, new RGBColor (0x666666), new RGBColor (0xCCCCCC), new RGBColor (0), true, newRGBColor ( 0x0 ), Joint.MITER );

    I need to also set the header font sizes for the above grid.

    How would i be able to do that?

    Thanks

    DB:2.98:How To Explicitly Set The Header Font Sizes In Grid Constructor Of Alivepdf sx


    Hi All ,

    I am currently developing a flex application which also involves exporting the created charts to a PDF using AlivePDF

    The exported pdf includes a datagrid of the chart values

    For the grid in the pdf,

    var grid:Grid = new Grid ( dp.toArray(), 200, 120, new RGBColor (0x666666), new RGBColor (0xCCCCCC), new RGBColor (0), true, newRGBColor ( 0x0 ), Joint.MITER );

    I need to also set the header font sizes for the above grid.

    How would i be able to do that?

    Thanks

  • RELEVANCY SCORE 2.98

    DB:2.98:Create Charts Using A Drop Down List 79


    Hi Guys
    Here is my sample data
    Test type Total Patients Total Cost Year
    a 24 $300 2000
    b 32 $100 2010
    c 100 $40 2009
    d 500$1000 2007

    I want to create a drop down list of the test type
    And then based on the test, I want to display two different charts- one for total patients and one for cost.
    How do I achieve this in excel 2007??

    DB:2.98:Create Charts Using A Drop Down List 79

    I wasn't saying Tables aren't good, infact I included the shortcut key to create them. I just pointed out that it could be done with just a filter. I was under the impression that the user wanted to create 2 charts from one filtered range so the limit
    of one filter did not seem germane. Anyway its good for the user to learn all the options, not just mine or someone elses.

    If this answer helps, please click the Vote as Helpful button. Cheers, Shane Devenshire

  • RELEVANCY SCORE 2.98

    DB:2.98:Grand Total Field In Analytic Grid Report m7


     
    Hi
     
    I am asked to get a Grand total field in an Analytic grid report..
     
    Can this be done?
     Any Idea?
     
    Please help !!!

    DB:2.98:Grand Total Field In Analytic Grid Report m7

     
    Normally, you can put anything anywhere as long as the same attributes are only on one axis. Measures can go to rows along with some other dimensions, but sometimes, a calculated members (measures) need adjustments.
     
    Like in your case where you have that Aggregate of Axis(1). I think you should Extract dimensions other than Measures and then do aggregate on them. Take a look at Extract() function and try it.
     
     
    Tomislav Piasevoli
    Business Intelligence specialist
    http://www.softpro.hr
     

  • RELEVANCY SCORE 2.98

    DB:2.98:Mschart Question (Xaxis) k1


    some of the charts we're trying to replicate are bar charts. Some of the years are centered between the grid/tickmarks. Anyway to get this effect.

    DB:2.98:Mschart Question (Xaxis) k1

    maybe I haven't explained my self properly. See the sample. There's 4 questions drawn in red. See
    http://www.slywaretech.com/chart/gap.jpg

  • RELEVANCY SCORE 2.98

    DB:2.98:Aligning Charts And Graphs zd


    I have roughly 10 bar charts that I want in grid form. The grid will consist of two rows.Five charts will be on the top row and 5 on the bottom row. However, I am having trouble making the grid completely aligned so that each chart is exactly the same
    size and so the outlines of the charts are perfectly aligned.
    I would prefer to not accomplish this in VBA, but will take the Code if that is the only way.
    Thank you

    DB:2.98:Aligning Charts And Graphs zd

    Holding Alt is a great way to move them to the right places, but to get the sizes the same in the first place I would simply use Ctrl+ click to select all the charts you want, then on the Drawing Tools | Format ribbon which appears, enter a size directly
    in the boxes at the right hand end (you need to hit enter after each, or click from on to another, Tab does not work in the Ribbon like it does in dialogs).
    As a further tip, it is always useful to make sure you size the plot area while holding Alt as Hans suggests, since this is the visible bit (usually). If you resize the chart at all, you need to re-align the plot areas again to line up with one
    another.

    Adam Vero MCT, MMI, MBMSS:CRM 4, MCSA:Messaging http://www.meteorit.co.uk

  • RELEVANCY SCORE 2.97

    DB:2.97:One Expression Gives Two Answers In Two Different Charts 89



    Hi,

    I have an Expression used in two different Charts. In the charts I have different Dimensions. The different Dimension is 'ledger_no'.

    I have expected that the totals in the charts would be the same. The correct total result is in the chart that have ledger_no as column.

    But in reality they shows a lot of deviations in total.

    Someone explains why!

    DB:2.97:One Expression Gives Two Answers In Two Different Charts 89


    four of your ledger_no has same ledger_initial_amount_bc value so when you are doing distinct in the expression these two duplicate values are getting ignored however when you add the ledger_no to the chart these duplicates are getting added.


  • RELEVANCY SCORE 2.97

    DB:2.97:Cr.Com Format Issue 7c



    i have two charts pushed up next to each other on a report.

    there are 6 grid lines 0-5.

    in crXI the grid lines line up perfectly.

    when uploaded to cr.com grid lines 3, 4 and 5 are slightly off, whilst 0,1 and 2 line up.

    printing to a pdf from cr.com makes a pdf with the grid lines aligned properly.

    any thoughts on a work around for this?

    DB:2.97:Cr.Com Format Issue 7c


    You can try this:

    Right-click the charts, choose Format, and check 'Lock Size and Position'.

  • RELEVANCY SCORE 2.97

    DB:2.97:Mouse Scrolling Changes Grid Values In Power Point And Ie. 1f



    Exported a file with about 100 components - Charts and Grids to Power Point and IE (as .swf) file AFTER locking all components.

    However, when I scroll the laptop cursor over any cell on the Grid, the value changes along with dependent cell and charts (the columns increase or decrease).

    In IE refresh bring the old values back however in PowerPoint one has to close without saving and then reopen the file.

    This is a very serious issue if financial or other numbers can be changed in management reports.

    Another issue is that one grid is overlapping a chart and am unable to delete (in unlocked mode) or replace that grid.

    Is there some kind of component limit that I have reached???

    Any SOLUTIONS???

    Avi

    DB:2.97:Mouse Scrolling Changes Grid Values In Power Point And Ie. 1f


    Was able to a solution in Behavior Common Uncheck Enable Interaction.

    But this has to be done to all the grids individually.

    Avi

  • RELEVANCY SCORE 2.96

    DB:2.96:Grid Total jc


     
    hi!
     
       i have a form with grid and in grid i have 5 column ( date ,id, amount ,fee,totalamt) now i need  amount ,fee and totalamount sum in form textbox and also i need count  of record  in grid too how can i do that please help me out
     
    thanks
    neal

    DB:2.96:Grid Total jc

    thanks for reply
      but i got same value for all record  from first record of my customer table
    here my code is
     
     thisform.refreshLOCAL lfdtotalSelect orderdetail
    SUM (fee) TO lfdtotal FOR orderdetail.custid = customer.custidthisform.ctextbox3.Value = lfdtotal
     
     

  • RELEVANCY SCORE 2.96

    DB:2.96:Soma De Valores No Grid fx


    Ola my gente buenos dias.
    Estoy com um problema en la soma de valores de una DataTabla coluna do grid. Quer decir el realiza la soma pero no suma la ultima fila del grid. Como salgo de eso.
    /// summary
    /// Calcula o total do grid
    /// /summary
    private void CalculaTotalGrid()
    {
    if (dataGrid.Rows.Count 0)
    {
    labSoma.Text = Total().ToString(c);

    }
    }
    /// summary
    /// Calcula o total
    /// /summary
    /// returns/returns
    private decimal Total()
    {
    decimal total = 0;
    //int i = 0;

    foreach (DataGridViewRow col in dataGrid.Rows)
    {
    total = total Convert.ToDecimal(col.Cells[Valor].Value);
    }


    return total;
    }

    NekFred,Lda

    DB:2.96:Soma De Valores No Grid fx

    Boa tarde Amigo,

    Tente da Seguinte maneira:

    private double Total()
    {
    double tot = 0;
    int i = 0;
    for (i = 0; i dataGrid.Rows.Count; i)
    {
    tot = tot Convert.ToDouble(dataGrid.Rows[i].Cells[Valor].Value);
    }
    return tot;
    }

  • RELEVANCY SCORE 2.96

    DB:2.96:Grid Control Chart/Graph Non Working Without "Reload". af


    Hi,
    There a new GC 10.2.0.3 installation. When access to Database - Performance screen, the Average Active Users and the Instance throughput charts does not show any information. These graph only starts to fill in when a Browser reload/refresh occurs. After the Reload the charts works as expected.
    Any clue would be really appreciated.

    Thanks in advance.

    DB:2.96:Grid Control Chart/Graph Non Working Without "Reload". af

    Does it not display at all after waiting?

    That screen normally takes some time to load. I would suggest you leave it for a while.

    What you can do is to clear you explorer cache and try again. Also check for the settings for when you explorer checks for new versions of pages.

  • RELEVANCY SCORE 2.96

    DB:2.96:Stacked Column Charts 98


    How can I get the total ofthesections ofeachstack to show above thecolumn without putting it in manually?

    DB:2.96:Stacked Column Charts 98

    you will need to use a dummy series, plotted as line.
    use the excel worksheet to calculate the sum of the stacked values for each category.
    add new series, change to line chart. you can format the line to have no Line style or data marker.
    Add data labels to the new series and position above.

  • RELEVANCY SCORE 2.95

    DB:2.95:Flex With Zf Or Cakephp? d3



    Ok I need to build an application that will have some pie charts and bar charts. When user clickers that will open an data grid (tables). So I have planned to supply the result for the chart in the form of xml through php. Which is suggested with flex? cakePHP or ZF? I am going to use flex only for the charting part. Thanks for any reply..

  • RELEVANCY SCORE 2.95

    DB:2.95:Total/Subtotal Alv Object Oriented ff



    Hi,

    How can I active icon of total/subtotal in alv grid object?

    it is disabled.

    Thanks!

    DB:2.95:Total/Subtotal Alv Object Oriented ff


    hi,

    To activate the total/subtotal icon you need to have atleast one numberic field in the output table which you are using to display the data.

  • RELEVANCY SCORE 2.93

    DB:2.93:Alv Grid cd


    hipls tell me how can we display the total no of rows in the output??

    DB:2.93:Alv Grid cd

    Hi Sam,I am sending simple program to use ALV and make the report interactive and display all rows and columns.have a look n u will understand.Reward if useful.Thanks.jUST RUN THIS PROGRAM ON YOUR PC.tables:ekpo.*data itab_ekpo type ekpo occurs 100 with header line.types: begin of itab_new,ebeln type ekpo-ebeln,matnr type ekpo-matnr,netpr type ekpo-netpr,end of itab_new.data itab1 TYPE STANDARD TABLE OF itab_new initial size 0.type-pools: slis.DATA: lt_fieldcat TYPE slis_t_fieldcat_alv, lf_fieldcat TYPE slis_fieldcat_alv.DATA: ws_repid TYPE sy-repid VALUE 'ZHALV2'.selection-screen Begin of block block1 with frame title text-111.select-options : S_EBELN for EKPO-EBELN.selection-screen end of block block1.INITIALIZATION.start-of-selection.select ebeln matnr netpr from ekpo into table itab1 up to 10 rows WHERE EBELN IN S_EBELN.PERFORM build_fieldcatalog.PERFORM GET_DETAILS.end-of-selection.----* Form build_fieldcatalog----text----FORM build_fieldcatalog .PURCHASING DOCUMENT NUMBERCLEAR lf_fieldcat.lf_fieldcat-fieldname = 'EBELN'.lf_fieldcat-ref_tabname = 'EKKO'.lf_fieldcat-ref_fieldname = 'EBELN'.APPEND lf_fieldcat TO lt_fieldcat.MATERIAL NUMBERCLEAR lf_fieldcat.lf_fieldcat-fieldname = 'MATNR'.lf_fieldcat-ref_tabname = 'EKPO'.lf_fieldcat-ref_fieldname = 'MATNR'.APPEND lf_fieldcat TO lt_fieldcat.NET PRICE IN PURCHASING DOCUMENTCLEAR lf_fieldcat.lf_fieldcat-fieldname = 'NETPR'.lf_fieldcat-ref_tabname = 'EKPO'.lf_fieldcat-ref_fieldname = 'NETPR'.*lf_fieldcat-cfieldname = 'WAERS'.lf_fieldcat-do_sum = 'X'.APPEND lf_fieldcat TO lt_fieldcat.ENDFORM. " build_fieldcatalog----* Form GET_DETAILS----text----FORM GET_DETAILS.CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'EXPORTINGI_CALLBACK_PROGRAM = ws_repidIT_FIELDCAT = lt_fieldcatTABLEST_OUTTAB = itab1EXCEPTIONSPROGRAM_ERROR = 1OTHERS = 2..IF SY-SUBRC 0.WRITE: 'SY-SUBRC: ', SY-SUBRC .ENDIF.

  • RELEVANCY SCORE 2.92

    DB:2.92:Dynamic Resizing Of Charts In Browser 9z



    Hi,

    In the Previous versions of Design Studio, when we dynamically change the browser's window, i.e. minimize or maximize, the charts used to re-size accordingly, but in Design Studio 1.2 the charts are re-sizing only when the Browser link is refreshed. The Charts are set to Auto width and Height and put inside a Grid Layout. Is this the case or am I missing something,

    Regards,

    Fazith Ali Z.

  • RELEVANCY SCORE 2.92

    DB:2.92:How To Use Sum In Charts s7



    Hi,

    What does SUM(total Month sales) exactly mean??

    I am using sum(sales)/SUM(total Month sales but not getting the desired output.

    Kindly suggest??

    Regards,

    Rohit

    DB:2.92:How To Use Sum In Charts s7


    Hello Rohit,

    The dimension between angular brackets will be taken into account for the aggregation expression, instead of the aggregation for all dimensions. In your example, the sum will add only for the Month dimension.

    Hope that helps

  • RELEVANCY SCORE 2.92

    DB:2.92:Display Total And Total Text For A Field In Alv Grid 1f



    hello all,

    i am stuck with a problem that i wanted to display Total for a field in ALV Grid at the bottom of the display also the text 'TOTALS'

    should be displayed....

    DB:2.92:Display Total And Total Text For A Field In Alv Grid 1f


    hi prakash,

    in the screen below

    under column COAL i wanted to display KOB1 and in the total(instead of 5) i wanted to display TOTAL COAL,

    i tried all the ways ,but i was not successful , hence i displayed a numeric value like above...

  • RELEVANCY SCORE 2.92

    DB:2.92:How Get Running Total In Grid ( In Form Not In Report) 7a


    hi master
    sir how i get running total in grid
    i have four column in my grid
    sno,title,total,runningtotal
    i need runntotal in lastcolumn
    i use in vanvalidate event
    :runingtotal := :runingtotal+ :total
    but this code not give me right result

    such as
    sno title total runningtotal
    1 dksdl 7 7
    2 ghdgd 4 11
    3 dgdf 3 14
    4 gdfgdf 4 18

    i need this type of grid i have

    please give me idea

    thank's

    aamir

    DB:2.92:How Get Running Total In Grid ( In Form Not In Report) 7a

    user452066, try this..,

    use one non-db item for calculation say A with initial value set to zero 0

    Now A=0, so u can add the first record for example 7 that is,
    A=A+7, now A=7, the second record will do the same,
    A=A+4,now A=11 .......so on...... assign the value A to the running total item and
    u will get the desired output.

  • RELEVANCY SCORE 2.91

    DB:2.91:Scroll Bars For Charts In Design Studio 1.1 m8



    Hi,

    I am working on design studio 1.1. I have one issue with charts. I need to show 6 charts in each tab (total 4 tabs). When I keep dimensions in x-axis, it is not showing all values. Also, I didn't find any scrolling option for charts. Scrolling option is available for cross tab but not for charts.

    Could you please guide me how to get scrolling for charts to show all the values in X-axis.

    Thank you in advance for your help.

    Kind Regards,

    Satyam

    DB:2.91:Scroll Bars For Charts In Design Studio 1.1 m8


    Hi Murali,

    thanks for your answer. Okay, I have no client with design studio in front of me at the moment but I think also there is no way to do that at the moment.

    @Satyam: As I said in my first post, you have to think about another presentation/layout of your data.

    Best regards,

    Benni

  • RELEVANCY SCORE 2.91

    DB:2.91:Em Charts / Graphs d3


    I have enterprise manager configured(non-grid setup). I can get the ASH and AWR reports for a specific timeframe.

    I dont see "reports" options in any of the tabs. Does enterprise manager has standard reports to generate graphical reports / charts load, cpu, io, wait events, throughput etc...

    I searched for "enterprise manager charts" "enterprise manager graphs" in this forum but did not find anything which I am looking for.

    Does any one know of any tools which generate graphs utilzing the EM tables (DBA_HIST*), i think all data is stored in these tables. Thanks for any pointers /help.

    DB:2.91:Em Charts / Graphs d3

    I have enterprise manager configured(non-grid setup). I can get the ASH and AWR reports for a specific timeframe.

    I dont see "reports" options in any of the tabs. Does enterprise manager has standard reports to generate graphical reports / charts load, cpu, io, wait events, throughput etc...

    I searched for "enterprise manager charts" "enterprise manager graphs" in this forum but did not find anything which I am looking for.

    Does any one know of any tools which generate graphs utilzing the EM tables (DBA_HIST*), i think all data is stored in these tables. Thanks for any pointers /help.

  • RELEVANCY SCORE 2.91

    DB:2.91:How To Exclude Empty Dimensions From Grid Chart zc



    I've created a grid chart with 4 distinct values in the first dimension and 20 distinct values in the second dimension. Each value in the second dimension corresponds to exactly one value in the first.

    How can I exclude the empty series from rendering in each of the 4 charts?

    Thanks regards

    Matthias

    DB:2.91:How To Exclude Empty Dimensions From Grid Chart zc


    I tried to use 4 charts before, but there I couln't specify different selections for the same dimension. I was able to achive what I wanted only by "disconnecting" and changing the selection one after another.

    But how can I have multiple charts with diffent selections in the same dimension?

  • RELEVANCY SCORE 2.90

    DB:2.90:Is It Possible To Display Customize Charts In The Result Overview Grid Of The Test Plan? dx


    Hi
    Test Plan by default displays only three charts Tests,Failure by type, Test Analysis by type. 

    DB:2.90:Is It Possible To Display Customize Charts In The Result Overview Grid Of The Test Plan? dx

    There is currently no way to customize the user interface in MTLM.  However, you can build any reports and charts you would like using either SSRS or Excel and the analysis services cube on your TFS Server.

  • RELEVANCY SCORE 2.90

    DB:2.90:Refer To Columns In Other Charts 7k



    Hi folks,

    Is it possible, when writing an expression for a chart field, to refer to columns in other charts?

    I have three existing charts, each of which produce a column which is summed to produce a total. Each of these three charts were calculated using different date ranges.

    Now, I would like to create a fourth table which takes the 'total' fields from each of the other three charts and sums them to produce an overall total.

    Is this possible?

    Thanks,

    Cillian

    DB:2.90:Refer To Columns In Other Charts 7k


    Hi.

    I suggest you can use

    Sum( All Total YourField )

    You can use eithere All or Total

    Rgds

    Anand

  • RELEVANCY SCORE 2.89

    DB:2.89:How To Count The Total Of Sub-Category In Pivot Charts? dj


    Category
    Sub-Category
    Total

    Trucks, Trains Vehicles
    Displays Assortments
    2

    Train Sets and Accessories
    35

    Whittle World Play Sets
    9

    Wooden Trucks
    8

    Wooden Vehicle Sets
    7

    Trucks, Trains Vehicles Total

    61

    Above is a pivot chart.

    DB:2.89:How To Count The Total Of Sub-Category In Pivot Charts? dj

    Category
    Sub-Category
    Total

    Trucks, Trains Vehicles
    Displays Assortments
    2

    Train Sets and Accessories
    35

    Whittle World Play Sets
    9

    Wooden Trucks
    8

    Wooden Vehicle Sets
    7

    Trucks, Trains Vehicles Total

    61

    Above is a pivot chart.

  • RELEVANCY SCORE 2.89

    DB:2.89:3d Charts 9x


    Hi,

    Is it possible to edit the grid on a 3D Chart. I added the snippet of code to make the charts 3D and i know you can edit the colors of the bars in a bar chart, but I was wondering if you can edit the grid the bars are on. I would like to change the color
    if possible. If anyone knows if this can be done please let me know.

    DB:2.89:3d Charts 9x

    Lo,
    According to this blog post (http://niiranen.eu/crm/2010/10/turn-the-flat-dynamics-crm-2011-charts-into-3d/), the settings of the chart can be controlled
    viaMicrosoft Chart Controls for .NET 4.
    So you could try browsing through the list of variables here:http://msdn.microsoft.com/en-us/library/system.windows.forms.datavisualization.charting.aspx
    and here:http://msdn.microsoft.com/en-us/library/system.web.ui.datavisualization.charting.aspx
    BR
    MadsPlease remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

  • RELEVANCY SCORE 2.89

    DB:2.89:Finding Sum Of The Column In Datagrid 9f


    Hiall
    i am using ria service to bind datagird, But i want to show the sum of the column as summary infooter of the grid
    I am looking to sum the columns Like this
    |name1 | num2 | num3 | Total|
    |name2| num2 | num3 | Total|
    |name3| num2 | num3 | Total|
    |Total | Total |Total ||Total|

    Any Idia to do this
    Thanks in Advance

    DB:2.89:Finding Sum Of The Column In Datagrid 9f

    just binding is not enough, you must request the data.
    What is the error you get ?

  • RELEVANCY SCORE 2.89

    DB:2.89:Incorporating Charts With A Grid View. jf


    Hello,
    I want to have a Grid app such that there are 2 tiles on the left and the right hand side filled with charts(scrollable). I wanted to know how to make that possible and also how to incorporate charts in a C# XAML Metro app.

    Rahul

    DB:2.89:Incorporating Charts With A Grid View. jf

    Hi,
    There is no built in chart control in Windows Store App, you should use third-part library to do this. Maybe this library can help you
    http://winrtxamltoolkit.codeplex.com/
    Best regards,
    JesseJesse Jiang
    MSDN Community Support | Feedback to us
    Develop and promote your apps in Windows Store
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

  • RELEVANCY SCORE 2.89

    DB:2.89:Container Issue cz



    Hi,

    This my first post so apologies if it is under the wrong section. I have a container with 12 charts inside it in a Grid view. The client's requirement is to view the 12 charts side by side for comparison purposes, which is the reason I'm using a container. The container is set to 2 columns by 6 rows and is scrollable downwards. Obviously the charts are quite small but big enough to compare trends, etc. What we thought would be good would to then be able to maximise the container to so the charts would become larger. This seems to work fine if there are only 4 charts in the container. However with 12 when you maximise the container it seems to want to fit them all onto one screen so they become stretched and unreadable. I've looked through the properties and can't see anything that would help, does anyone know if it is possible to maximise the container without this happening? I've attached screenshots before and after maximising to show what I mean.

    Also, another requirement was to change the view from Grid to Single object view and resize the container via a button. I can't find the correct code to change the Container Type, ie from Single to Grid and vice versa, does anyone have any sample code or a list of properties for the container object (I've looked in the API guide but can't see this property)?

    thanks in advance

    DB:2.89:Container Issue cz


    Oh Ok. Pardon me if my response seemed a little too basic..

    Any, I am not a huge fan of the container charts since more often than not, they seem to have a mind of their own. And they are very rigid with very little scope for configuration/settings. Hence I tend to avoid those.

    But anyway, good luck with your quest. Hope you do get a solution.

    Rgds,

    SK

  • RELEVANCY SCORE 2.88

    DB:2.88:Alv Report Subtotal And Total za



    Hi to all

    Please tell me how to calculate subtotal and total on a particular field in ALV grid report.

    Thanks regards

    Anubhav

    DB:2.88:Alv Report Subtotal And Total za


    hi anupav,

    just try this simple pgm,

    -

    REPORT ZGALV_SORT.

    TYPE-POOLS : SLIS.

    TYPES : BEGIN OF TYP_EMP,

    ZEID TYPE ZGEMP_DETAIL1-ZEID,

    ZENAM TYPE ZGEMP_DETAIL1-ZENAM,

    ZESAL TYPE ZGEMP_DETAIL1-ZESAL,

    ZEADD TYPE ZGEMP_DETAIL1-ZEADD,

    END OF TYP_EMP.

    DATA : IT_EMP TYPE STANDARD TABLE OF ZGEMP_DETAIL1,

    IT_FIELDCAT TYPE SLIS_T_FIELDCAT_ALV,

    GT_LAYOUT TYPE SLIS_LAYOUT_ALV,

    GT_SORT TYPE SLIS_T_SORTINFO_ALV,

    GW_SORT TYPE SLIS_SORTINFO_ALV,

    VL_LAYOUT TYPE DISVARIANT.

    SELECT ZEID

    ZENAM

    ZESAL

    ZEADD

    FROM ZGEMP_DETAIL1

    INTO CORRESPONDING FIELDS OF TABLE IT_EMP.

    FORM DISPLAY.

    CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'

    EXPORTING

    I_INTERFACE_CHECK = ' '

    I_BYPASSING_BUFFER = ' '

    I_BUFFER_ACTIVE = ' '

    I_CALLBACK_PROGRAM = ' '

    I_CALLBACK_PF_STATUS_SET = ' '

    I_CALLBACK_USER_COMMAND = ' '

    I_CALLBACK_TOP_OF_PAGE = ' '

    I_CALLBACK_HTML_TOP_OF_PAGE = ' '

    I_CALLBACK_HTML_END_OF_LIST = ' '

    I_STRUCTURE_NAME = 'ZGEMP_DETAIL1'

    I_BACKGROUND_ID = ' '

    I_GRID_TITLE =

    I_GRID_SETTINGS =

    IS_LAYOUT = GT_LAYOUT

    IT_FIELDCAT = IT_FIELDCAT

    IT_EXCLUDING =

    IT_SPECIAL_GROUPS =

    IT_SORT = GT_SORT

    IT_FILTER =

    IS_SEL_HIDE =

    I_DEFAULT = 'X'

    I_SAVE = 'A '

    IS_VARIANT = VL_LAYOUT

    IT_EVENTS =

    IT_EVENT_EXIT =

    IS_PRINT =

    IS_REPREP_ID =

    I_SCREEN_START_COLUMN = 0

    I_SCREEN_START_LINE = 0

    I_SCREEN_END_COLUMN = 0

    I_SCREEN_END_LINE = 0

    I_HTML_HEIGHT_TOP = 0

    I_HTML_HEIGHT_END = 0

    IT_ALV_GRAPHICS =

    IT_HYPERLINK =

    IT_ADD_FIELDCAT =

    IT_EXCEPT_QINFO =

    IR_SALV_FULLSCREEN_ADAPTER =

    IMPORTING

    E_EXIT_CAUSED_BY_CALLER =

    ES_EXIT_CAUSED_BY_USER =

    TABLES

    T_OUTTAB = IT_EMP

    EXCEPTIONS

    PROGRAM_ERROR = 1

    OTHERS = 2

    .

    IF SY-SUBRC 0.

    MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

    WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

    ENDIF.

    ENDFORM.

    *DATA : IT_FIELDCAT TYPE SLIS_T_FIELDCAT_ALV.

    START-OF-SELECTION.

    VL_LAYOUT-REPORT = SY-REPID.

    PERFORM GETSORT.

    PERFORM GETLAYOUT.

    *PERFORM GETFIELDCAT.

    PERFORM DISPLAY.

    ----

    * Form GETSORT

    ----

    text

    ----

    -- p1 text

    -- p2 text

    ----

    FORM GETSORT .

    CLEAR GT_SORT.

    GW_SORT-FIELDNAME = 'ZEID'.

    GW_SORT-SPOS = '1'.

    *GW_SORT-TABNAME = '2'.

    GW_SORT-UP = 'X'.

    *GW_SORT-SUBTOT = 'X'.

    APPEND GW_SORT TO GT_SORT.

    CLEAR GT_SORT.

    GW_SORT-FIELDNAME = 'ZESAL'.

    *GW_SORT-SPOS = '1'.

    *GW_SORT-TABNAME = '1'.

    *GW_SORT-UP = 'X'.

    GW_SORT-SUBTOT = 'X'.

    APPEND GW_SORT TO GT_SORT.

    ENDFORM. " GETSORT

    ----

    * Form GETLAYOUT

    ----

    text

    ----

    -- p1 text

    -- p2 text

    ----

    FORM GETLAYOUT .

    GT_LAYOUT-NO_INPUT = 'X'.

    GT_LAYOUT-ZEBRA = 'X'.

    GT_LAYOUT-NO_HLINE = 'X'.

    GT_LAYOUT-WINDOW_TITLEBAR = 'ALV GRID DISPLAY'.

    ENDFORM. " GETLAYOUT

    ----

    * Form GETFIELDCAT

    ----

    text

    ----

    -- p1 text

    -- p2 text

    ----

    FORM GETFIELDCAT .

    data: v_fieldcat type slis_fieldcat_alv.

    data: pos type i value 1.

    define field_cat.

    clear v_fieldcat.

    v_fieldcat-col_pos = pos.

    v_fieldcat-fieldname = 1.

    v_fieldcat-ref_fieldname = 2.

    v_fieldcat-ref_tabname = 3.

    v_fieldcat-key = 4.

    append v_fieldcat to it_fieldcat.

    pos = pos + 1.

    end-of-definition.

    FIELD_CAT: 'ZEID' 'ZEID' 'ZGEMP_DETAILS' 'X',

    'ZENAME' 'ZENAME' 'ZGEMP_DETAILS' 'X',

    'ZESAL' 'ZESAL' 'ZGEMP_DETAIL1' 'X',

    'ZEADD' 'ZEADD' 'ZGEMP_DETAIL1' SPACE .

    ENDFORM. " GETFIELDCATREPORT ZGALV_SORT.

    TYPE-POOLS : SLIS.

    TYPES : BEGIN OF TYP_EMP,

    ZEID TYPE ZGEMP_DETAIL1-ZEID,

    ZENAM TYPE ZGEMP_DETAIL1-ZENAM,

    ZESAL TYPE ZGEMP_DETAIL1-ZESAL,

    ZEADD TYPE ZGEMP_DETAIL1-ZEADD,

    END OF TYP_EMP.

    DATA : IT_EMP TYPE STANDARD TABLE OF ZGEMP_DETAIL1,

    IT_FIELDCAT TYPE SLIS_T_FIELDCAT_ALV,

    GT_LAYOUT TYPE SLIS_LAYOUT_ALV,

    GT_SORT TYPE SLIS_T_SORTINFO_ALV,

    GW_SORT TYPE SLIS_SORTINFO_ALV,

    VL_LAYOUT TYPE DISVARIANT.

    SELECT ZEID

    ZENAM

    ZESAL

    ZEADD

    FROM ZGEMP_DETAIL1

    INTO CORRESPONDING FIELDS OF TABLE IT_EMP.

    FORM DISPLAY.

    CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'

    EXPORTING

    I_INTERFACE_CHECK = ' '

    I_BYPASSING_BUFFER = ' '

    I_BUFFER_ACTIVE = ' '

    I_CALLBACK_PROGRAM = ' '

    I_CALLBACK_PF_STATUS_SET = ' '

    I_CALLBACK_USER_COMMAND = ' '

    I_CALLBACK_TOP_OF_PAGE = ' '

    I_CALLBACK_HTML_TOP_OF_PAGE = ' '

    I_CALLBACK_HTML_END_OF_LIST = ' '

    I_STRUCTURE_NAME = 'ZGEMP_DETAIL1'

    I_BACKGROUND_ID = ' '

    I_GRID_TITLE =

    I_GRID_SETTINGS =

    IS_LAYOUT = GT_LAYOUT

    IT_FIELDCAT = IT_FIELDCAT

    IT_EXCLUDING =

    IT_SPECIAL_GROUPS =

    IT_SORT = GT_SORT

    IT_FILTER =

    IS_SEL_HIDE =

    I_DEFAULT = 'X'

    I_SAVE = 'A '

    IS_VARIANT = VL_LAYOUT

    IT_EVENTS =

    IT_EVENT_EXIT =

    IS_PRINT =

    IS_REPREP_ID =

    I_SCREEN_START_COLUMN = 0

    I_SCREEN_START_LINE = 0

    I_SCREEN_END_COLUMN = 0

    I_SCREEN_END_LINE = 0

    I_HTML_HEIGHT_TOP = 0

    I_HTML_HEIGHT_END = 0

    IT_ALV_GRAPHICS =

    IT_HYPERLINK =

    IT_ADD_FIELDCAT =

    IT_EXCEPT_QINFO =

    IR_SALV_FULLSCREEN_ADAPTER =

    IMPORTING

    E_EXIT_CAUSED_BY_CALLER =

    ES_EXIT_CAUSED_BY_USER =

    TABLES

    T_OUTTAB = IT_EMP

    EXCEPTIONS

    PROGRAM_ERROR = 1

    OTHERS = 2

    .

    IF SY-SUBRC 0.

    MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

    WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

    ENDIF.

    ENDFORM.

    *DATA : IT_FIELDCAT TYPE SLIS_T_FIELDCAT_ALV.

    START-OF-SELECTION.

    VL_LAYOUT-REPORT = SY-REPID.

    PERFORM GETSORT.

    PERFORM GETLAYOUT.

    *PERFORM GETFIELDCAT.

    PERFORM DISPLAY.

    ----

    * Form GETSORT

    ----

    text

    ----

    -- p1 text

    -- p2 text

    ----

    FORM GETSORT .

    CLEAR GT_SORT.

    GW_SORT-FIELDNAME = 'ZEID'.

    GW_SORT-SPOS = '1'.

    *GW_SORT-TABNAME = '2'.

    GW_SORT-UP = 'X'.

    *GW_SORT-SUBTOT = 'X'.

    APPEND GW_SORT TO GT_SORT.

    CLEAR GT_SORT.

    GW_SORT-FIELDNAME = 'ZESAL'.

    *GW_SORT-SPOS = '1'.

    *GW_SORT-TABNAME = '1'.

    *GW_SORT-UP = 'X'.

    GW_SORT-SUBTOT = 'X'.

    APPEND GW_SORT TO GT_SORT.

    ENDFORM. " GETSORT

    ----

    * Form GETLAYOUT

    ----

    text

    ----

    -- p1 text

    -- p2 text

    ----

    FORM GETLAYOUT .

    GT_LAYOUT-NO_INPUT = 'X'.

    GT_LAYOUT-ZEBRA = 'X'.

    GT_LAYOUT-NO_HLINE = 'X'.

    GT_LAYOUT-WINDOW_TITLEBAR = 'ALV GRID DISPLAY'.

    ENDFORM. " GETLAYOUT

    ----

    * Form GETFIELDCAT

    ----

    text

    ----

    -- p1 text

    -- p2 text

    ----

    FORM GETFIELDCAT .

    data: v_fieldcat type slis_fieldcat_alv.

    data: pos type i value 1.

    define field_cat.

    clear v_fieldcat.

    v_fieldcat-col_pos = pos.

    v_fieldcat-fieldname = 1.

    v_fieldcat-ref_fieldname = 2.

    v_fieldcat-ref_tabname = 3.

    v_fieldcat-key = 4.

    append v_fieldcat to it_fieldcat.

    pos = pos + 1.

    end-of-definition.

    FIELD_CAT: 'ZEID' 'ZEID' 'ZGEMP_DETAILS' 'X',

    'ZENAME' 'ZENAME' 'ZGEMP_DETAILS' 'X',

    'ZESAL' 'ZESAL' 'ZGEMP_DETAIL1' 'X',

    'ZEADD' 'ZEADD' 'ZGEMP_DETAIL1' SPACE .

    ENDFORM. " GETFIELDCATREPORT ZGALV_SORT.

    TYPE-POOLS : SLIS.

    TYPES : BEGIN OF TYP_EMP,

    ZEID TYPE ZGEMP_DETAIL1-ZEID,

    ZENAM TYPE ZGEMP_DETAIL1-ZENAM,

    ZESAL TYPE ZGEMP_DETAIL1-ZESAL,

    ZEADD TYPE ZGEMP_DETAIL1-ZEADD,

    END OF TYP_EMP.

    DATA : IT_EMP TYPE STANDARD TABLE OF ZGEMP_DETAIL1,

    IT_FIELDCAT TYPE SLIS_T_FIELDCAT_ALV,

    GT_LAYOUT TYPE SLIS_LAYOUT_ALV,

    GT_SORT TYPE SLIS_T_SORTINFO_ALV,

    GW_SORT TYPE SLIS_SORTINFO_ALV,

    VL_LAYOUT TYPE DISVARIANT.

    SELECT ZEID

    ZENAM

    ZESAL

    ZEADD

    FROM ZGEMP_DETAIL1

    INTO CORRESPONDING FIELDS OF TABLE IT_EMP.

    FORM DISPLAY.

    CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'

    EXPORTING

    I_INTERFACE_CHECK = ' '

    I_BYPASSING_BUFFER = ' '

    I_BUFFER_ACTIVE = ' '

    I_CALLBACK_PROGRAM = ' '

    I_CALLBACK_PF_STATUS_SET = ' '

    I_CALLBACK_USER_COMMAND = ' '

    I_CALLBACK_TOP_OF_PAGE = ' '

    I_CALLBACK_HTML_TOP_OF_PAGE = ' '

    I_CALLBACK_HTML_END_OF_LIST = ' '

    I_STRUCTURE_NAME = 'ZGEMP_DETAIL1'

    I_BACKGROUND_ID = ' '

    I_GRID_TITLE =

    I_GRID_SETTINGS =

    IS_LAYOUT = GT_LAYOUT

    IT_FIELDCAT = IT_FIELDCAT

    IT_EXCLUDING =

    IT_SPECIAL_GROUPS =

    IT_SORT = GT_SORT

    IT_FILTER =

    IS_SEL_HIDE =

    I_DEFAULT = 'X'

    I_SAVE = 'A '

    IS_VARIANT = VL_LAYOUT

    IT_EVENTS =

    IT_EVENT_EXIT =

    IS_PRINT =

    IS_REPREP_ID =

    I_SCREEN_START_COLUMN = 0

    I_SCREEN_START_LINE = 0

    I_SCREEN_END_COLUMN = 0

    I_SCREEN_END_LINE = 0

    I_HTML_HEIGHT_TOP = 0

    I_HTML_HEIGHT_END = 0

    IT_ALV_GRAPHICS =

    IT_HYPERLINK =

    IT_ADD_FIELDCAT =

    IT_EXCEPT_QINFO =

    IR_SALV_FULLSCREEN_ADAPTER =

    IMPORTING

    E_EXIT_CAUSED_BY_CALLER =

    ES_EXIT_CAUSED_BY_USER =

    TABLES

    T_OUTTAB = IT_EMP

    EXCEPTIONS

    PROGRAM_ERROR = 1

    OTHERS = 2

    .

    IF SY-SUBRC 0.

    MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

    WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

    ENDIF.

    ENDFORM.

    *DATA : IT_FIELDCAT TYPE SLIS_T_FIELDCAT_ALV.

    START-OF-SELECTION.

    VL_LAYOUT-REPORT = SY-REPID.

    PERFORM GETSORT.

    PERFORM GETLAYOUT.

    *PERFORM GETFIELDCAT.

    PERFORM DISPLAY.

    ----

    * Form GETSORT

    ----

    text

    ----

    -- p1 text

    -- p2 text

    ----

    FORM GETSORT .

    CLEAR GT_SORT.

    GW_SORT-FIELDNAME = 'ZEID'.

    GW_SORT-SPOS = '1'.

    *GW_SORT-TABNAME = '2'.

    GW_SORT-UP = 'X'.

    *GW_SORT-SUBTOT = 'X'.

    APPEND GW_SORT TO GT_SORT.

    CLEAR GT_SORT.

    GW_SORT-FIELDNAME = 'ZESAL'.

    *GW_SORT-SPOS = '1'.

    *GW_SORT-TABNAME = '1'.

    *GW_SORT-UP = 'X'.

    GW_SORT-SUBTOT = 'X'.

    APPEND GW_SORT TO GT_SORT.

    ENDFORM. " GETSORT

    ----

    * Form GETLAYOUT

    ----

    text

    ----

    -- p1 text

    -- p2 text

    ----

    FORM GETLAYOUT .

    GT_LAYOUT-NO_INPUT = 'X'.

    GT_LAYOUT-ZEBRA = 'X'.

    GT_LAYOUT-NO_HLINE = 'X'.

    GT_LAYOUT-WINDOW_TITLEBAR = 'ALV GRID DISPLAY'.

    ENDFORM. " GETLAYOUT

    ----

    * Form GETFIELDCAT

    ----

    text

    ----

    -- p1 text

    -- p2 text

    ----

    FORM GETFIELDCAT .

    data: v_fieldcat type slis_fieldcat_alv.

    data: pos type i value 1.

    define field_cat.

    clear v_fieldcat.

    v_fieldcat-col_pos = pos.

    v_fieldcat-fieldname = 1.

    v_fieldcat-ref_fieldname = 2.

    v_fieldcat-ref_tabname = 3.

    v_fieldcat-key = 4.

    append v_fieldcat to it_fieldcat.

    pos = pos + 1.

    end-of-definition.

    FIELD_CAT: 'ZEID' 'ZEID' 'ZGEMP_DETAILS' 'X',

    'ZENAME' 'ZENAME' 'ZGEMP_DETAILS' 'X',

    'ZESAL' 'ZESAL' 'ZGEMP_DETAIL1' 'X',

    'ZEADD' 'ZEADD' 'ZGEMP_DETAIL1' SPACE .

    ENDFORM. " GETFIELDCAT

    -

    hope u can get now....

    Rgds,

    guna.

  • RELEVANCY SCORE 2.87

    DB:2.87:Excel Vba To Create Charts And Set Axesxlcategory Font Size And Type, Minor Axis Visible Office 2010 Macro Recorder Problems px


    I would like to personalize the xlcategory axis including: 1) font size and type, 2) show Axis Minor Grid lines (visible, color, and weight). I am able to manually do these steps as I want it. I recorded a macro of these steps and tried to rerun it. It
    did not work and I got various error messages depending on what was executing. I know in Excel 2007 there where many macro problems with macros in charts (Shapes). I thought these had been corrected in Excel 2010. But I am finding many cases where this seems
    to not be true. Am I perhaps (hopefully) doing something wrong?My charts are line charts with markers. Thanks.

    DB:2.87:Excel Vba To Create Charts And Set Axesxlcategory Font Size And Type, Minor Axis Visible Office 2010 Macro Recorder Problems px

    This remains an issue in Office 2011 for Mac.
    A recorded macro that changes a chart scale will not run.

  • RELEVANCY SCORE 2.87

    DB:2.87:Export Layoutroot Contents Into Excel m7


    Hello Friends,
    I want to export Silverlight 4 Pie Charts Column Charts Grid as shown on Silverlight Page in Excel. I tried with COM Interop but do not know how to export charts grid data into Excel. Any ideas? Thanks.
    Best Regards,
    Krishnpratap

    DB:2.87:Export Layoutroot Contents Into Excel m7

    Hi,

    I want to export Silverlight 4 Pie Charts Column Charts Grid as shown on Silverlight Page in Excel.

    I would like to suggest you to refer the links below for some samples that explain how to export silverlight charts:
    http://abubakar-dar.blogspot.com/2010/09/export-silverlight-charts-to-ms-word.html
    http://abubakar-dar.blogspot.com/2010/12/excellite-silverlight-library-for-ms.html

    I tried with COM Interop but do not know how to export charts grid data into Excel

    Here is a step by step article which describes how to export data from the silverlight application to an Excel file by using the COM API, please check it and see whether it helps.
    http://www.codeproject.com/KB/silverlight/SL4InteropWithExcel.aspx
    Hope it can help you.

  • RELEVANCY SCORE 2.87

    DB:2.87:Grid Chart Properties - Axes - Static Scale Options Are Grayed Out cm



    Hi,

    I am working with grid charts and would like to set a static scale. When I navigate to the Axes tab in the Chart Properties dialog box I see that the options for Static scale are grayed out and I can't set them. How can I activate them?

    Thanks,Alexis

    DB:2.87:Grid Chart Properties - Axes - Static Scale Options Are Grayed Out cm


    Hi,

    I am working with grid charts and would like to set a static scale. When I navigate to the Axes tab in the Chart Properties dialog box I see that the options for Static scale are grayed out and I can't set them. How can I activate them?

    Thanks,Alexis

  • RELEVANCY SCORE 2.87

    DB:2.87:Total For A Numeric Field In Alv Grid Display 89


    Hi all,I am not getting the Total for a Numeric field in ALV Grid output. What might be the problem.Regards,Balavardhan.K

  • RELEVANCY SCORE 2.87

    DB:2.87:Display Total On Bar Charts? 8k


    Hi ,

    I have 2D stacked bar Charts and Cost as metric.

    I have to fullfill the Requirement saying that client want to see total on top of the stacked bars. Right now chart can show individual counts (of legends ) when we rollover the cursor on the chart.

    I am using 10gobiee. is it possible to Show the Totals on the top of stacked bar chart ?

    Please Give me early advice.

    Thanks in advance

    DB:2.87:Display Total On Bar Charts? 8k

    You take a new column and calculate the formula in it as grand total and place it in the chart this way
    http://varanasisaichand.blogspot.com/2010/12/aggregate-functions-on-grand-total.html

    For mouse hovering this might help you http://obiee101.blogspot.com/2008/01/obiee-xy-and-data-in-mouse-over-label.html

    hope this helps you.

    Cheers,
    KK

  • RELEVANCY SCORE 2.87

    DB:2.87:Resolution Issue 7c


    hi
    i am woring in SL4 , i am displaying some charts on my silverlight page in a grid
    what i want is to show charts in equal height that i have set , but what i want to show just two chart on screen
    and for the third one i want a scroll bar , i am unable to show two charts on the available screen because any help
    regards .

    DB:2.87:Resolution Issue 7c

    Better to Use two panel and display the charts inside the panel. But if the chart size is big then there will be problem in display the two chart..
    Declare the height and Width as 50% , 50%..
    Hope you get the logic..

  • RELEVANCY SCORE 2.86

    DB:2.86:Grid Totals Records Returned 9f


    Does anyone know if there is anyway of getting the total
    records returned to be displayed in the grid footer (just like in
    the ExtJS grid) for the html type grid in cf 8?

    DB:2.86:Grid Totals Records Returned 9f

    Does anyone know if there is anyway of getting the total
    records returned to be displayed in the grid footer (just like in
    the ExtJS grid) for the html type grid in cf 8?

  • RELEVANCY SCORE 2.86

    DB:2.86:Need Help With Line Charts With A Total And Groups mk


    Hi
    I have SSRS 2008 plain and simple no R2.
    I have a wish of having line charts or staple charts with the Series field being for example various Merchandise Groups the Category fields being the months and then an expression in the data fields.
    But I would like to see all the Merchandise Groups and then a TOTAL in the same chart.
    So we could have say 2 merchandise groups and the nthe total of them 2 as a seperate line making a total of 3 lines in a line chart.
    Oooh yeah almost forgott ... the merchandise groups values are also filtered on a specific company. Not the Total ... the total will have all the companies in the dataset.
    I just cant get my head around this how do I do this?
    Thanks in advanced

    jea

  • RELEVANCY SCORE 2.86

    DB:2.86:Problem About Hyperion Financial Reporting Export Excel 7m


    Hi, I created a Hyperion financial report. There is a grid at the top and some charts below the grid. There's also a footer in the report. When I run the report in Hyperion Workspace, it is perfectly displayed in both HTML and PDF format. There's also no problem when I export it in PDF format. But when I export it in excel format, the footer is wrongly positioned just below the grid and aligned horizontally with the charts instead of positioning at the bottom of the report. Is there any solution to fix this problem? Thx.

    DB:2.86:Problem About Hyperion Financial Reporting Export Excel 7m

    Please post the question in the corresponding forum. Hyperion Query and Reporting forum is [this way|http://forums.oracle.com/forums/forum.jspa?forumID=406].

  • RELEVANCY SCORE 2.85

    DB:2.85:Displaying Grand Total &Amp; Subtotal j9


    Can we display Grand total and subtotal at the top in a table view? Currently it allows only at the bottom of the grid.

    DB:2.85:Displaying Grand Total &Amp; Subtotal j9

    I believe you have an option to show Grand Total After or Before the Values. You need not use any Narrative Views.When you select the Grand Total option in your table view, it should prompt if you want to display after or before values. Choose Before There.

  • RELEVANCY SCORE 2.85

    DB:2.85:How To Show Grand Total In Trellis Chart ? 3a



    Hi, I am looking for solution to show grand total of legends in each charts shown in trellis

    Sample Data:
    STATECITYVOLUMEMHPN100MHMUM200KNBN900KNTN800

    Output: Please see the attachment, output should have a trellis and Grand Total of legends.

    DB:2.85:How To Show Grand Total In Trellis Chart ? 3a


    The best way to do this, add calculated dimension. Something like below,

    =STATEChr(10)'Total Volume='Aggr(Sum(VOLUME),STATE)

  • RELEVANCY SCORE 2.85

    DB:2.85:Print Barcode Labels In Asp.Net Using C# 3k


    Hi All,

    How create Print Label with bar code in ASP.NET using C#.

    Label consists couple of items :

    Product Name and Product Id -- It comes form database.
    Example :

    I have a Product data grid and Display total count of the grid results on the Label.

    Grid consists 2 items..

    I need total print labels -3.

    Label 1. Grid details and grid count
    Label 2. Grid Item 1 - bar code Label - item 1 description details
    Label 3. Grid Item 2 - Bar code Label - item 2 description details

    Please let me know.

    Thanks,
    Austin

  • RELEVANCY SCORE 2.85

    DB:2.85:Is There A Way To Show All Charts For One Host In One Page? 3c


    In our data center, each host has ~ 24 charts associated with it. Our current tool has a page that shows all 24 charts in one page. User can specify any host and then view the charts.

    In OEM Grid Control, is there any way that can show all the charts in one place? The host-Performance tab shows a pre-defined list of charts. The target-home page can be modified to have up to 4 charts. That's the 2 places that I know can have multiple charts, but it does not meet our requirements of showing more customized charts.

    In the group - charts page, user can add more charts, but the charts are based on the group, it's not easy to show chart for a particular host. If I have thousands of hosts in the data center, will it be any problem if I have thousands of groups?

    Thanks for any help/options.

    DB:2.85:Is There A Way To Show All Charts For One Host In One Page? 3c

    You won't be able to have a page showing 24 charts per host.

    I really think that it is a bad idea to create a group per host, just to have the ability to add many charts.

    The maintenance effort will be a big penalty.

    Regards
    Rob

  • RELEVANCY SCORE 2.85

    DB:2.85:Charts With Formulas kx



    Post Author: archon4239

    CA Forum: Charts and Graphs

    I'm using Crystal Reports XI and I can't seem to use the chart functionality with formulas. I see detail formulas available in the chart wizard (data tab), but I don't see my sum formulas in the wizard. The sum formulas are based variables that total numbers in the group footer.

    Anyway I can create charts with these formulas that sum up values in the group footer?

    DB:2.85:Charts With Formulas kx


    Post Author: acarey

    CA Forum: Charts and Graphs

    A big short coming with CR is that it doesn't let you chart WhilePrintingRecords formulas. I tore my hair out for a while with this one.

    Eventually I found a document with a work around on the Business Objects website. Its a SERIOUS pain in the *** but it does work.

    The Doc is for CR9 but I'm using XI and it works. The document is called cr9_charting_print_time.pdf. Unfortunately I can't remember the exact location but you should be able to search for it.

    If anyone knows an easier way don't hesitate to TELL SOMEONE. The thing with these forums is that questions like this don't seem to get answered to often.

    Good luck mate

  • RELEVANCY SCORE 2.85

    DB:2.85:Building Charts In Silverlight 81


    Just looking for some good tutorials or examples on how to create Charts, for example Bar, Pie etc in silverlight.I already have the data coming from a SQL Server DB and displaying in a data Grid,I used LINQ WCFfor this,I found this tutorial very helpful,
    http://silverlight.net/learn/tutorials/sqldatagrid-cs/Anyway im just trying to expand on this and create some nice charts in the same project. Would appreciate any help or advice on how to
    do this.
    Thanks

    DB:2.85:Building Charts In Silverlight 81

    If you're willing to work with some preview technology (which will hopefully be RTW soon), check out RIA data services. I found that it greatly simplifies getting the data to your SL app, and you don't have to rely on WCF (though you certainly CAN still
    use WCF with RIA).
    You can check out some of Brad Abrams blog posts on using SL in conjunction with RIA anda plethora of different technologies here:
    http://blogs.msdn.com/brada/archive/2009/10/27/index-for-business-apps-example-for-silverlight-3-rtm-and-net-ria-services-july-update.aspx
    And once you have the data available in your SL app then the toolkit samples are a good place to see how to bind the data to the actual chart:
    http://silverlight.net/content/samples/sl3/toolkitcontrolsamples/run/default.html
    The visifire website has some good examples of using their charts too.

  • RELEVANCY SCORE 2.85

    DB:2.85:Presenting Multiple Charts In A Tabular Format za



    Hi Everyone, i'm new to qlikview. I would like to know is there any way of presenting multiple charts in a tabular format. For eg- i have charts of sales,income,profits,number of stores,total square feet etc for various retailers from around the world. I want all the charts to appear in a tabluar format. So whenever i pick a particular retailer, all the above charts should fit into a table.

    DB:2.85:Presenting Multiple Charts In A Tabular Format za


    Hi,

    You can define min and max values by

    Chart Properties - Axes - Scale - Select and give Static Min and Max values.

    Hope it helps you.

    Regards,

    Jagan.

  • RELEVANCY SCORE 2.85

    DB:2.85:Show Values In A Grid Chart 1z



    Hi!!

    I have done a grid chart ( I've attached a sample to this post.). I guess if is there any way to show the values over the charts.

    Thanks for your help

    DB:2.85:Show Values In A Grid Chart 1z


    Do you mean to show the values of the expressions next to the pie section? If that is what you want, it is possible in a normal pie chart, but I don't think it is possible in a grid chart. I'm using version 10 and I still don't see that option available. Might be a good suggestion to add.

    Regards.

  • RELEVANCY SCORE 2.85

    DB:2.85:How To Implement Cross Tab Grid In Silverlight 1k


    Guys,
    I'd like to gather some design ideas how to create pivot grid in silverlight.
    The grid looks like below. Thanks.

    yesterday total sales
    last two days total sales
    last week total sales
    last month total sales

    James
    1,000
    1,500
    2,600
    5,000

    Rose
    2,000
    3,500
    6,600
    11,000

    DB:2.85:How To Implement Cross Tab Grid In Silverlight 1k

    Hi Jessmmy,

    Any idea how can we do this type of query based on the timeline? how can we extend the pivot query to get the last day, last weeks total sales for a person?

    Name
    SalesAmount
    Date

    James
    100
    1/10/2009

    Mike
    200
    5/10/2009

    James
    600
    12/10/2009

    You'd better use a WCF, which has two methods. These two methods will returntwo data collections just like you point in your post. Therefore, it shall be a SQL query question.We highly suggestyoupostyour question to Sql forums with your table structure.Also,
    we can use Linq to iterate the data collection ,which is assigned to the DataGrid's ItemsSource property, to generate the collection manually.

    Best regards,
    Jonathan

  • RELEVANCY SCORE 2.85

    DB:2.85:"Breaks" In Charts... xa



    Hi all,

    recently during checking performance charts i saw some "breaks" in charts

    I've attached an example screenshoot.

    Is it normal?

    DB:2.85:"Breaks" In Charts... xa


    I am having this same problem and it is causing several issue with our software when it happens.

    It is usually only quick breaks in communication.

    Anyway I can test to find out what the root cause is?

    I have changed nic cards, ports on the switch, and cables, but it did not stop.

    It is very random.

  • RELEVANCY SCORE 2.85

    DB:2.85:Column Charts 71


    How to generate cloumn charts in jsp?

    DB:2.85:Column Charts 71

    How to generate cloumn charts in jsp?

  • RELEVANCY SCORE 2.85

    DB:2.85:How To Count The Total Of Sub-Category In Pivot Charts 8p


    Category
    Sub-Category
    Total

    Trucks, Trains Vehicles
    Displays Assortments
    2

    Train Sets and Accessories
    35

    Whittle World Play Sets
    9

    Wooden Trucks
    8

    Wooden Vehicle Sets
    7

    Trucks, Trains Vehicles Total

    61

    Above is a pivot chart.

    DB:2.85:How To Count The Total Of Sub-Category In Pivot Charts 8p

    Hi,

    For better suggestions related to Pivot table or chart in Excel, you may post your query in the forum link below:
    http://social.technet.microsoft.com/Forums/en/excel/threads

    Thank you.

  • RELEVANCY SCORE 2.85

    DB:2.85:Grid Chart-Showing Allocated Totals With Pie Charts ca



    Hello,

    I was wondering if anyone knows how to show detailed segments totals in pie charts displayed on grid chart.

    For example-

    My dimensions-

    1-Quarter

    2-Year-

    3-Service Line

    Expression-Sum(Charges)

    Problem-Lets say I have 5 service lines per pie chart. When I hover over the pie it isolates the segment but displays the total charges for all 5 service lines. I see this total is represented in the overall size of the pie chart, but I could like each segment to display its individual total 2012Q1 (SL1-$500, SL2-$2000etc). Most examples I have seen have the same setup which although diplayed as a pie reads the total as if it was a dot.

    Anyone done this before?

    EK

    DB:2.85:Grid Chart-Showing Allocated Totals With Pie Charts ca


    Hello,

    I was wondering if anyone knows how to show detailed segments totals in pie charts displayed on grid chart.

    For example-

    My dimensions-

    1-Quarter

    2-Year-

    3-Service Line

    Expression-Sum(Charges)

    Problem-Lets say I have 5 service lines per pie chart. When I hover over the pie it isolates the segment but displays the total charges for all 5 service lines. I see this total is represented in the overall size of the pie chart, but I could like each segment to display its individual total 2012Q1 (SL1-$500, SL2-$2000etc). Most examples I have seen have the same setup which although diplayed as a pie reads the total as if it was a dot.

    Anyone done this before?

    EK

  • RELEVANCY SCORE 2.84

    DB:2.84:Display Total aa



    Hi

    I have Grid having 3 columns . One amount is column . I want when the value of Amount changes it should refresh the Total of the Grid in the label

    Thanks

    DB:2.84:Display Total aa


    Hi Edy

    I didn't try that way . I will be able to do when user Update record , That is not a problem for me . I wanted the way u have told me because that way is more correct , user wll be able to view update total at the same time . That's why i am requesting u to help me .

    Thanks

  • RELEVANCY SCORE 2.84

    DB:2.84:Subtotals In Two Rows Alv Grid 99



    Hi Every one,

    I want to display subtotals in ALV grid in two rows.

    One total is in Mins and another total is in hours.

    I have time fields at record level.

    thanks in advance.

    DB:2.84:Subtotals In Two Rows Alv Grid 99


    Hi Prasanth,

    thanks for your reply.

    if i do as u suggested it will display the subtotals in one row i.e. in Mins but i need one more row which will display in hours

  • RELEVANCY SCORE 2.83

    DB:2.83:Websheet Charts c3


    Hi,When I create a chart section the icon's for Column, Horizontal Bar and Line charts show multiple series on the same chart. However, after selecting my data grid I can only select one column as the chart value.Does anyone know how I can create a chart in a Websheet section that has multiple series as the icons show?Thanks,James

    DB:2.83:Websheet Charts c3

    Hi James,It isn't feasible to generate a multi-series chart in a Websheet. The icons that we're using to represent the supported chart types are misleading, and should only represent single-series charts, so apologies for any confusion they may have caused.Regards,Hilary

  • RELEVANCY SCORE 2.82

    DB:2.82:Providing Textual Descriptions Of Enterprise Manager Charts ka


    On my 10.2.0.3 Grid Control, I followed the steps described in EM Advanced Configuration, section 1.3.2 Providing Textual Descriptions of Enterprise Manager Charts. BUT, it does NOT work. The mentioned small icon does not appear.

    Has anyone met the same issue?

    Thanks.

    DB:2.82:Providing Textual Descriptions Of Enterprise Manager Charts ka

    On my 10.2.0.3 Grid Control, I followed the steps described in EM Advanced Configuration, section 1.3.2 Providing Textual Descriptions of Enterprise Manager Charts. BUT, it does NOT work. The mentioned small icon does not appear.

    Has anyone met the same issue?

    Thanks.

  • RELEVANCY SCORE 2.82

    DB:2.82:Unable To View Chart In Pdf xp



    Hi All,

    I am using Transaction to create a PDF document with MII Charts in it.

    I am opening it using Runner service and its working fine for a user with developer role.

    The Charts are missing in PDF if I open it with non developer user.

    I am having Dynamic Query role assigned to the user and everything like chart and grid works fine in irpt page for the same user.

    But in the PDF i am unable to get charts.

    Do i need to assign any specific role?.

    My MII version is 12.1.8 Build 24

    Kindly help on this.

    Thanks,

    Selva.

    DB:2.82:Unable To View Chart In Pdf xp


    I'm glad to know my answer was the solution you needed. When developing a custom user role, it can be challenging to provide the missing pieces from the required SAP_XMII_User role to your custom role. The online help docs do a nice job of listing the actions, and even though matching their name/description to the desired functionality in your application can be a bit tedious at times, the names are somewhat straightforward.

  • RELEVANCY SCORE 2.82

    DB:2.82:How To Use One Combo Box To Control Two Spreadsheet/Charts In Web Analysis aj


    In Web Analysis panel, I have one data grid and one chart (two different data sources). I would like to have one combo box, e.g. Q1, Q2, Q3, Q4, in the selection (drop-down). When I select Q1, I would like to show Jan, Feb, Mar, Q1 ( ICHILDREN(Q1)) in my chart, and also only Q1 in my data grid.

    Any suggestions?

    Thanks

    DB:2.82:How To Use One Combo Box To Control Two Spreadsheet/Charts In Web Analysis aj

    I believe you can do this. For example you want to have a Chart and Graph linked to a drop down for products. When you select a product, the two POV's will change on the reports.

    Look at Panels in WA. I create a report with three panels. Make the first panel top aligned, the second top aligned and the third stretched. This should make the report "stretchy". Then add your dropdown to one panel and your reports to the other two panels.

    Finally link the reports to dropdown using the re-linking technique mentioned in the previous post.

    Hope this helps.
    Brian Chow

  • RELEVANCY SCORE 2.82

    DB:2.82:Charts In Richfaces 4 3m


    Hi,

    DB:2.82:Charts In Richfaces 4 3m


    This may be of interest: http://code.google.com/p/jsflot/. I've not used it myself yet.

    Regards,

    Brendan.

  • RELEVANCY SCORE 2.82

    DB:2.82:How To Get Total In The Grid Chart xs



    Hi,

    Am attaching a grid chart where i need to get the total below like say as in the example for week 12 andrew has 5 hours for chemistry Physics.

    How could it be possible that we get the total below?

    Thanks in advance.

    BR

    Subin

    DB:2.82:How To Get Total In The Grid Chart xs


    Does anyone have any idea how can we acieve it?

    Thanks in advance.

  • RELEVANCY SCORE 2.81

    DB:2.81:Total Problem In Exporting Alv Grid To Excel kk



    Hi all,

    I have manipulated the Total of ALV Grid by using GET_SUBTOTALS and REFRESH method of CL_GUI_ALV_GRID. The ALV Output is also correct. When i export to Excel,only the Original total is displaying not the calculated one. How to download the exact output which is displaying in the ALV Grid to Excel.

    Please help me out to solve this.

    Thanks,

    Ramesh

    DB:2.81:Total Problem In Exporting Alv Grid To Excel kk


    DEAR,

    AS U WANT UPLOAD WITH THE SUB TOTAL YOU TRY THIS.

    FIRST to get subtotal in ALV output you select at least one column of total and then press ctrl + F6 . u will see the sub total .

    and now how to download it so press ctrl + shift + F9 .

    now screen appears and select second option ie spreadsheet and press enter

    now a screen appear in wich u have to give file name.

    so double click on search button of file name . click on desktop give ur file name as u want suppose zreport u have given.

    and save type = excel file.

    now save it and then generate it your output bytes will be transmitted .

    now u can see in your desktop in your file name . ur output with subtotal.

    regards

    navin

  • RELEVANCY SCORE 2.81

    DB:2.81:Charts 88



    I'm new to crystal charting. I am trying to create a chart that shows percentage of anonymous/total calls by Business Units as well the total percentage in a horizontal bar graph. How do I create a simple chart that show both calucation in one chart?

    Edited by: Carla Boyd on Jul 5, 2011 6:51 PM

    DB:2.81:Charts 88


    This solutiuon sounds complicated, but I'll try.

    thanks again!

  • RELEVANCY SCORE 2.81

    DB:2.81:Control Charts 1f



    Hi ,

    Any one has Control Charts in Qlikview

    DB:2.81:Control Charts 1f


    Hi ,

    Any one has Control Charts in Qlikview

  • RELEVANCY SCORE 2.81

    DB:2.81:Deleting The Record In Alv Grid p8



    Hi frineds,

    In alv grid am displaying the records with sub total headings but the problem is, finally want display the

    subtotal value under that one blank line and next want display the total .but it is showing the total value in blank line and in total value field.can any if possible give the code..

    Thanks in advance.

    DB:2.81:Deleting The Record In Alv Grid p8


    Hi frineds,

    In alv grid am displaying the records with sub total headings but the problem is, finally want display the

    subtotal value under that one blank line and next want display the total .but it is showing the total value in blank line and in total value field.can any if possible give the code..

    Thanks in advance.

  • RELEVANCY SCORE 2.81

    DB:2.81:Charts In Wad? 91



    Expert's,

    I am working on WAD templates.I have created the bar charts whhere in there are 4 bars in the chart.and actually there is one row called TOTAL which gets its value by the calaclutation.It means the TOTAL Column is filld by the some calculations.When I execute the template I could see only there 4 bars which are directly from the source system.But the Bar partaining to that TOTAL value is appearing.Can any one help me to resovle this.

    Thanks,

    Vasu

  • RELEVANCY SCORE 2.80

    DB:2.80:Stacked Charts xd



    Hi ,

    can anyone tell me how to display charts in blackberry.

    Thanks

    Vijay

    DB:2.80:Stacked Charts xd


    Search the forum, I think similar questions have been asked before. Does this help?

    http://supportforums.blackberry.com/t5/Java-Develo​pment/Create-graph-fields/ta-p/444968

  • RELEVANCY SCORE 2.80

    DB:2.80:Charts 9k



    Hi Guys

    i have used only() function in the chart expression but i want that when user clear the selection he should be able to see the total data.??????

    DB:2.80:Charts 9k


    Hi,

    Use:

    =if(GetPossibleCount(Field)=Count({1}Field), sum(Expression),sum({$Field={$(=Only(Field))}}Expression))

    hope this hepl you

    Regards,

    Arun Goel

  • RELEVANCY SCORE 2.80

    DB:2.80:Hi, zx



    i have a client who want to see only one chart at a time and has total of 3 charts in a single sheet, please tell me how can i do so.???

    DB:2.80:Hi, zx


    You could also use the auto-minimise option under Caption menu by selecting all 3 objects. This way if one object is enabled the other 2 objects in the sheet would be minimised as required.

  • RELEVANCY SCORE 2.80

    DB:2.80:Grand Total In Grid z1



    Hai To All,

    Iam creating some reports for my addon. Iam using Grid to create reports. In my grid iam using Quantity,Amount etc.. fields. Now my issue is For Quantity,amount fields i want to calculate total.

    How to do that???

    For example,

    In bottom of grid i want to total........

    Does anyone have idea??

    Iam using 2005 B Version

    Regards,

    Anitha

    DB:2.80:Grand Total In Grid z1


    Hi Anitha,

    It's the same problem. we can't able to do this with Grid.

    Regards

    Michael.

  • RELEVANCY SCORE 2.79

    DB:2.79:Total Mode Sum Of Rows Not Working In Charts j9



    Hi

    Thanks in advance for any response.

    We have an annoying issue with gauge charts not matching a table on totals

    This expression in table with Total mode sum of rows returns 324 - which is correct

    However in the gauge chart with same expression it returns 322, which is a result of sum of rows not affecting the total

    The expression:

    IF([Lead Type] = 'Conveyancing', count({$[TicketStatusId]={'6'}} caseno),count({$[TicketStatusId]={'6'}} Reference))

    Question - does Total Mode not work in Gauge Charts?

    I have tried playing with dimensions etc

    DB:2.79:Total Mode Sum Of Rows Not Working In Charts j9


    Hello John,

    I have a similar problem to the one you've assisted with above. I was wondering if you could assist on this. All I need to do is divide the sum of Total_proceeds by the sum of Market_Value. The way I'm currently doing it, gives an incorrect total. My expression is:

    *************************************************************************************************************************************************

    Sum({Registration_Code = {'2'}, Vehicle_Status = {'Normal'}, Contract_Prefix = {'A'}, Salvage_Processed = {'1'}, YMDate = DisplayYM} [Total_proceeds])

    /

    Sum

    Sum({Registration_Code = {'2'}, Vehicle_Status = {'Normal'}, Contract_Prefix = {'A'}, Salvage_Processed = {'1'}, YMDate = DisplayYM} Market_Value)

    *************************************************************************************************************************************************

    I would really appreciate your assistance with this.

    Regards,

    S

  • RELEVANCY SCORE 2.79

    DB:2.79:Alv Grid Display Total Text sj



    Hi,

    Not able to display Grand Total Text in ALV Grid Display. I am able to display Subtotal Texts in ALV Grid but not the Grand Total Text..

    not able to find out the exact solution from previous posts..

    Please Help me.

    Thank You,

    Jhansi

    DB:2.79:Alv Grid Display Total Text sj


    Hi,

    You have to use TOTALS_TEXT field of slis_layout_alv to display grand

    total text.

    For your reference please visit these links:

    1. Re: How to get Grand Total Text in ALV GRID

    2. subtotal and grand total in alv

    3. ALV GRID - Text for Grand Total

    May it helps you.

    Regards.

    DS.

  • RELEVANCY SCORE 2.79

    DB:2.79:Help : Add Last Button And Total Record Count To Crm Grid sf


    Dear Sir,
    Scenario :- I have 10,000 records and I need to go to last page, I have to nagivate40 pages (250 Records per page).
    Question :-

    Is it possible to Add Last Button to CRM Grid and
    Add Total Record Count eg. (Total Record Count = 1000) in
    CRM Grid.
    Thanks - Abbas

    DB:2.79:Help : Add Last Button And Total Record Count To Crm Grid sf

    you need to develop or buy custom tool for the same..see following link for the same..
    http://a33ik.blogspot.com/2009/09/supported-record-counter-for-microsoft.html
    http://geek.hubkey.com/2009/02/ms-dynamics-crm-40-record-counter-page.html

  • RELEVANCY SCORE 2.79

    DB:2.79:Limit Fields In Dimension 37



    Hello all,

    Within my data set, I have some groupings that are sub totals, is there a way to remove these from showing in some charts?

    For example, I have a list including Sub Total and Total in a group, can I create a calculated field that removes those two?

    With thanks,

    Simon

  • RELEVANCY SCORE 2.79

    DB:2.79:Alv Grid Report 7p



    Hi friends..

    in report have HEADER, BODY,FOOTER.

    i displayed body in ALV GRID. i got toal value in body.

    now i want to dispaly TOTAL VALUE, 20%MARGIN OF TOTAL VALUE in FOOTER. so how to pickup the total value.

    Plese help me friends..

    Thanks Regrads....

    venkat reddy...

    DB:2.79:Alv Grid Report 7p


    HI,

    You can take the variable for total and calculate in program and use it in footer. This will easy your work.

  • RELEVANCY SCORE 2.79

    DB:2.79:Own Total Text In Oo-Grid 93


    Hi,i will give the total-sum (not subtotal) line in OO-GRID an own text. Is it possible?Regards, Dieter

    DB:2.79:Own Total Text In Oo-Grid 93

    Hi Dieter,nowadays I'm facing the same problem. I have explored whole class CL_GUI_ALV_GRID and there is not any standard possibility to put own text in total line. But there is one solution, which is not ideal but functional - using another subtotal (I'm using function module REUSE_ALV_GRID_DISPLAY instead of class CL_GUI_ALV_GRID directly, but the principle is almost the same):in field catalog put any empty hidden field (this field must exist in your output table too!): CLEAR l_fieldcat.
    l_fieldcat-fieldname = 'TOTAL_TEXT'.
    l_fieldcat-seltext_s = 'Total'.
    l_fieldcat-seltext_m = 'Total'.
    l_fieldcat-seltext_l = 'Total'.
    l_fieldcat-reptext_ddic = 'Total'.
    l_fieldcat-no_out = 'X'.
    APPEND l_fieldcat TO i_fieldcat.

  • RELEVANCY SCORE 2.79

    DB:2.79:How Do I Put Multiple Charts In A Grid 8j


    I need to put 4 charts on a grid, similar to a dashboard. Two are pie charts, 1 is a lineseries, one is a columnseries. If I attempt to add a second charting:Chart in XAML, I get a The property 'Content' is set more than once error. I
    can not use a third party control like telerik for this, it has to come from the silverlight tool kit.
    grid
    charting:Chart... /
    charting:Chart... /
    charting:Chart... /
    charting:Chart... /
    /grid
    This is how I thought it would be arranged but clearly not. Any ideas on how to do this? I should add that this is complicated because each chart has a unique stored procedure behind it for the data.
    Thanks

    DB:2.79:How Do I Put Multiple Charts In A Grid 8j

    Hi,
    The two links are also about how to put multiple charts in grid:
    http://www.visifire.com/forums/index.php?showtopic=2849 .
    http://www.visifire.com/forums/index.php?showtopic=2852.
    Hope it helps.
    Best Regards.Amy Peng
    MSDN Community Support | Feedback to us
    Develop and promote your apps in Windows Store
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

  • RELEVANCY SCORE 2.79

    DB:2.79:Total Of A Grid a1



    hello for example a want to calculate the total of 3 rows, for example:

    profit loses

    October 100 50

    November 150 20

    December 100 50

    Total 350 120

    how can i put the total value in a grid...i know that i can put the total label in a grid in Row Heading but then i create a XML Document but the total appears always,in this example, next loses...

    Could anyone give a tip??

    regards

    Mrio

  • RELEVANCY SCORE 2.79

    DB:2.79:Charts s9



    Shall we have customize charts in qlikview?

    DB:2.79:Charts s9


    Yes,

    You need to create your own extension as required.

    or use already developed from the below link.

    http://www.qlikblog.at/1939/a-comprehensive-list-of-qlikview-object-extensions-012013/

    Regards

    ASHFAQ

  • RELEVANCY SCORE 2.78

    DB:2.78:How Do I Total Daily Multiple Value Columns In Monthly Charts So Sum Is Displayed At Top 3x


    How Do I Total Daily Multiple Value Columns In Monthly Charts So The Sum Is Displayed?

    DB:2.78:How Do I Total Daily Multiple Value Columns In Monthly Charts So Sum Is Displayed At Top 3x

    Checked the sample… but am not able to achieve what you need….
    I think this is not possible….

  • RELEVANCY SCORE 2.78

    DB:2.78:Process Charts a3



    How / can you create process charts in adobe?

    DB:2.78:Process Charts a3


    Thanks I will have a look at that

  • RELEVANCY SCORE 2.78

    DB:2.78:Regarding Alv Grid Cntrl dp



    how can i display total or Sum(of values) in ALV grid control?

    DB:2.78:Regarding Alv Grid Cntrl dp


    hi sree,

    u can use the following type-pool for sum in alv grid

    gs_filedcat-datatype = 'CURR' or 'QUANT'

    gs_fieldcat-do_sum = 'X'.

    this will display the sum of that field...

    hope this will help u out..

    please reward points in case usefull...

    regards,

    Prashant

  • RELEVANCY SCORE 2.78

    DB:2.78:Sql Server 2008 Reporting Server, Graphs/Charts Do Not Appear But The Data In Grid Appears 8z


    i have designed reports using sql server 2008 reporting services and when i run the report, i get to see the data in grid but no graphs.
    same reports if i publish uisng sql 2005 it works fine.

    DB:2.78:Sql Server 2008 Reporting Server, Graphs/Charts Do Not Appear But The Data In Grid Appears 8z

    Thanks Challen. I appreciate you for taking time to respond to my query.Regards Praveen