dcsimg

Search:

Type: Posts; User: gunapriyan

Page 1 of 2 1 2

Search: Search took 0.11 seconds.

  1. Re: Export Stored Procedure Result to EXCEL through VB

    Sir,

    Thanks Sir. In the above said topic, they dealt with recordset / from one table.

    Sir, I want to extract all the results of the stored Procedures including Column Name which are dynamically...
  2. Export Stored Procedure Result to EXCEL through VB

    Friends,

    I had designed application and running well. I had created a Stored Procedure called "Consolidated" as follows;

    164991

    I need to export the said output directly to EXCEL. Please...
  3. Bind multiple tables values in Data Report

    Friends, I had designed an project using VB 6.0 and SQL 2008. Data Storage part is over. Now i am stuck up with display multiple table values in Data Report.
    ...
  4. Re: Bind multiple tables values in Data Report

    Friends,

    Please reply.

    Thanks & Regards,
  5. Bind multiple tables values in Data Report

    Friends, I had designed an project using VB 6.0 and SQL 2008. Data Storage part is over. Now i am stuck up with display multiple table values in Data Report.

    Please find my tables and values as...
  6. Replies
    2
    Views
    1,994

    Re: Please Suggest and Help

    Updated....
  7. Replies
    2
    Views
    1,994

    Data Reporting Issue....

    I have designed a package for Salary Generation using Visual Basic 6.0 and SQL DB. The final Data Report is placed below in attachment 1.

    The SQL 2008 DB is attached in attachment 2.

    I had done...
  8. Replies
    6
    Views
    732

    Re: Rounded off to nearest 10

    Thank you.....
  9. Replies
    6
    Views
    732

    Re: Rounded off to nearest 10

    Thanks...I will use your code....
  10. Replies
    6
    Views
    732

    Re: Rounded off to nearest 10

    Arno, Please find the CG Increment Procedure as follows;

    ow to calculate the annual increment for Central Government employees as per 6th CPC..?

    The logic is very simple, but everyone should...
  11. Replies
    6
    Views
    732

    Rounded off to nearest 10

    Friends,

    To calculate the salary increment, I need to rounding off to nearest 10.

    For Example,

    If X=390.99, It should be rounded to 390
    If X=391.23, It should be rounded to 400

    Please...
  12. Replies
    8
    Views
    1,351

    Re: Align Justify in DataReport Label

    Sir, Thanks for your help. I learnt how to give indent but the paragraph should align justify. How can we do that sir?
  13. Replies
    8
    Views
    1,351

    Re: Align Justify in DataReport Label

    147789

    Rpt_Factory.Sections("Section1").Controls("Label46").Alignment = "Justify" /* it is throwing Error */

    Thanks & Regards,
  14. Replies
    8
    Views
    1,351

    Align Justify in DataReport Label

    Friends,

    1. I had used a Label in Data Report. I need to use a letter paragraph in the said label. But i was unable to Align Justify.

    There is 3 alignment property is there;
    ...
  15. Replies
    6
    Views
    503

    Re: Need Query - Pls

    Dear Sammi,

    First up sorry that i didn't think that you are hired coders. I just forgot to post the queries which i had tried.

    Thanks for your "Valuable" comments.

    Guna
  16. Replies
    6
    Views
    503

    Need Query - Pls

    Friends,

    Please find the following attachment.

    128997

    Please help me to write the queries to get the said output.

    Thanks in advance.
  17. Replies
    7
    Views
    1,002

    Re: Runtime Error

    Thank you very much.
  18. Replies
    7
    Views
    1,002

    Re: Runtime Error

    Thanks for your reply.

    I had used Replace function, but i had faced the error.

    Please find the error in attachment.

    126105
  19. Replies
    7
    Views
    1,002

    Re: Runtime Error

    Friend, Thanks for your reply. But i wish to inform you that, I don't know which company have that quotes (since 6000 companies there).

    So How to fix in that query....

    Thanks & Regards,
  20. Replies
    7
    Views
    1,002

    Runtime Error

    Friends,

    I had used the following code;

    SQL = "SHAPE {select distinct(Company_Name) from exporter_returns where company_name='" & Combo3.Text & "' and returns_month between '" & stretmon & "'...
  21. Replies
    9
    Views
    633

    Re: Install on Network

    Comrades,

    Thanks for your suggestion. But your explanation is too technical.

    As a intermediate person, I don't have much knowledge to understand your replies. [Sorry....]

    I request you to...
  22. Replies
    9
    Views
    633

    Install on Network

    Dear Friends,

    I had designed many application using VB6 and SQL 2005/2008.

    But my only problem, If there is any new update in my package, i need to place the exe file in each system for...
  23. Replies
    10
    Views
    1,576

    Re: Scroll Combo Box

    Friend,

    Thanks for your great post.

    Suppose if the typed item is not matched with existing item means?

    Please update the code.
  24. Re: Type and Point out the specified text in Combo Box

    Please somebody help.
  25. Re: Type and Point out the specified text in Combo Box

    Thanks my dear friend.

    I used the following code from Code Library.



    Dim blnAuto As Boolean
    Private Sub cmbicd_Change()
    Dim strPart As String, iLoop As Integer, iStart As Integer,...
  26. Type and Point out the specified text in Combo Box

    Friends,

    I need to type and select one specified item in Combo Box.

    For Example,

    One Combo Boxes loaded with Country Master.

    If it type "I" and "R" and "E" means "IRELAND" should be...
  27. Replies
    1
    Views
    1,085

    Formatting Issue

    Friends,

    I have 3 columns in numeric data type.

    In report i had used "Sum" built-in function.

    106433

    It is showing like 4,689,878,709 in output.
  28. Calculate Average of 2 Sum Function Values?

    Friends,

    I had used 2 Sum Functions in Report.

    I want to calculate average of the 2 sum functions value instead of data field i.e Average(Sum(a)+Sum(b)) instead of Average(c)

    Thanks in...
  29. Replies
    2
    Views
    1,583

    Re: Problem in Shape Command

    Dear Friends,

    Finally i had avoid error in Shape Command;

    SHAPE {select distinct(Country_name) from Country_Master} APPEND ((SHAPE {select...
  30. Replies
    4
    Views
    710

    Re: Data Report Issue

    Dear Friends,

    Finally i had avoid error in Shape Command;

    SHAPE {select distinct(Country_name) from Country_Master} APPEND ((SHAPE {select...
  31. Replies
    2
    Views
    1,583

    Problem in Shape Command

    P.S Post need to be moved from Visual Basic 6.0 or Earlier....

    Dear Friends,

    I want to 3 level grouping. To achieve that, I had write the following code;


    SHAPE {select...
  32. Replies
    1
    Views
    454

    Problem in Shape Command

    Dear Friends,

    I want to 3 level grouping in Data Report. To achieve that, I had write the following code;



    SHAPE {select distinct(Country_name) from Country_Master}
    APPEND ((SHAPE {select...
  33. Condition in SHAPE for Data Grid Report

    Friends,

    I have 3 Tables;

    1. Exporter Returns

    rt_id numeric(18, 0) Unchecked
    exporter_id nchar(10) Checked
    icd_name nvarchar(50) Checked
    port_name nvarchar(50) Checked
  34. Replies
    4
    Views
    710

    Re: Data Report Issue

    Friend,

    Thanks for your reply.

    I had received error "Report sections do not match data source"

    Actually i have basic problem. I don't know how to create groups with out Data Environment.
    ...
  35. Replies
    4
    Views
    710

    Data Report Issue

    Friends,

    I had designed an application.

    I want Report like as follows using Data Grid.

    TITLE
    Date: Page 1 of 1

    Region : North
  36. Re: Type and Point out the specified text in Combo Box

    Sir,

    Please find my code....

    I had done everything. But there is no change...

    Guna
  37. Re: Type and Point out the specified text in Combo Box

    Dear Friend,

    Thanks for your reply and i will check and let you know the status.

    Thanks for your immediate reply.

    Thanks & Regards,

    Guna
  38. Type and Point out the specified text in Combo Box

    Dear Friends,

    In .NET there is an option to select a specified value by typing continuous letter.

    But in VB6, when i type, It will search first letter and showing the value which is equal to...
  39. Replies
    13
    Views
    989

    Re: Data Grid Issue

    Dear Friends,

    Finally I had achieved.

    1. Change the Data Grid Properties from adcmdtable to adcmdtext
    2. Adodc2.RecordSource = "SELECT * FROM TABLE2 where Emp_ID='" & CStr(id1) & "'"

    Thanks...
  40. Replies
    13
    Views
    989

    Re: Data Grid Issue

    Yes my Friend,

    ADODC1 for Text Boxes Values....ADODC2 for Data Grid.

    And I didn't get any runtime error....

    Its running....But shows all the Table2 records in Data Grid...

    Even i had...
Results 1 to 40 of 63
Page 1 of 2 1 2



Featured


Click Here to Expand Forum to Full Width