Post reply

Newbie Question on Fields

  • June 28, 2005 at 10:01 am

    #167523

    I have made a report within a project that calls a stored procedure.  The parameters are passed in and the procedure returns the correct data. 

    Basically, I have built a dynamic string, captured records into a reporting table, selected those records for the report, then deleted those records from the reporting.  The "Data" tab shows the records. 

    Unfortunately, the Fields list is empty.  I have saved, closed, and re-opened the project and still no fields.  No idea why or how to remedy this. 

    Thanks in advance, 

    Farrell

    I wasn't born stupid - I had to study.

  • June 28, 2005 at 11:20 am

    #569063

    You can right-click in the "Fields" window in the left pane and Add your fields one at a time manually. If you have multiple fields with the same name you'll have to append a number after the field.

    I.E. SELECT LOCATION.NAME, ITEM.NAME FROM ....

    You'll have to have NAME for Location and NAME1 for Item or else give them an alias in your select statement.

    Further, if your dataset is an expression (uses Parameters!myParam.Value etc.) what you can do is copy & paste your query somewhere safe, then go back and take our the parameters so that it is a straight forward select statement. Run it to get results using the ! icon. Switch to Layout mode and the Fields should populate themselves. Then go back and change your query to use parameters, provided that the fields retrieved don't change in your query.

    Hope this helps.

  • June 29, 2005 at 6:59 am

    #569291

    On the data tab, execute your query.  Once you have results, click the refresh button.  The fields should now appear.

  • June 30, 2005 at 8:14 am

    #569819

    Thanks for your help. 

    This is driving me nuts.  When I first created it, I declared the Stored Procedure and the parameters were read by Reporting Services and already fulfilled. 

    At some point, those disappeared and I had to make them.   

    Now, I have formatted the report with a header and footer and data section.  Then I populate the data section, I only get one record returned - I should be getting over 1,000 records... 

    Not a happy camper.  I am going to try and build a new report and see what happens.  

    Thanks.

    I wasn't born stupid - I had to study.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply