SQL Server Performance

Design layout in Fields window

Discussion in 'SQL Server Reporting Services' started by mkmathi, May 8, 2006.

  1. mkmathi New Member

    Hi,

    I'm using Sp to get data for report. My problem is if I pass the paramater and run the sp
    in data view i am getting rows.

    but in Design layout in Fields window i am not getting fields name to design the report.

    please help me out.. [^]


    Thanks

    Thanks & Regards
    Mathivanan K
    Great work may have to pass through these stages - ridicule, opposition, and then acceptance. Each man who thinks ahead of his time will probably be greatly misunderstood.- vivekananda

  2. smy New Member


    Hi,

    Are you using class file/code behind from the report properties to write following coding in order to retrieve the data view from the stored procedure?

    If so, you got to create a function whereby each column's data will be return to the report (e.g code.functionname(=!YourPassInParameter, 1) where 1 is a integer..
    this '1' will act as the return data of that particular column...

    well, its difficult to explain more in depth..if you dunt get me, please let me know if you are using class file/code behind from the report properties to write the codes..
    From there, i will post a sample for you to see how to code and retrieve the data onto the report...
  3. mkmathi New Member

    Hi Smy,

    Thanks for your post.I am not using Class file/code . for only one sub report i am getting the problem rest of the reports are fine.If I get the fileds then only i can design the report..

    It's not showing fileds in field explorer..):

    but if i run the procedure under data Tab of the report it's returning rows...

    Thanks & Regards
    Mathivanan K
    Great work may have to pass through these stages - ridicule, opposition, and then acceptance. Each man who thinks ahead of his time will probably be greatly misunderstood.- vivekananda

  4. smy New Member

    its a sub report? if you put sub report to main report, you will not see the sub report's fields on the field explorer of the main report.
  5. mkmathi New Member

    Hi Smy thanks for your posts.finally i got the solution by modifiying XML file of the main report.
    Myself I added all the fields and fields type in XML file.
    <fields>
    ...
    ...
    ...
    ...
    <fields>



    Thanks & Regards
    Mathivanan K
    Great work may have to pass through these stages - ridicule, opposition, and then acceptance. Each man who thinks ahead of his time will probably be greatly misunderstood.- vivekananda

Share This Page