Design layout in Fields window | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Design layout in Fields window

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

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…

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
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.
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
]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |