SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Reporting services - datasets


Reporting services - datasets

Poll
fields in datasets

0% - 0 votes How doI link fields with the dataset?
0% 0 votes
Member votes: 0, Guest votes: 0. You don't have permission to vote in this poll
Author
Message
akhale123
akhale123
SSC Journeyman
SSC Journeyman (92 reputation)SSC Journeyman (92 reputation)SSC Journeyman (92 reputation)SSC Journeyman (92 reputation)SSC Journeyman (92 reputation)SSC Journeyman (92 reputation)SSC Journeyman (92 reputation)SSC Journeyman (92 reputation)

Group: General Forum Members
Points: 92 Visits: 17
I imported acess 2007 reports to reporting serivces 2005. i opened one report and created a dataset via the query analyzer. when I open the expression of a field, I highlight the dataset option, I can see field like first(field_name). When I highlight the fields option, i get a message that the fields are not linked to the reports. I can drag and drop fields from the dataset to the report. I would like to select the fields from the fields options in the expression, How do I get the field option to populated on the right pane?
When I switch from design view to preview, VS crashes. I updated it but it still crashes. When i go to the field properties\expression and hightlight dataset and double click on the field, the field expression is:
=first!( .value, dataset1)
When I drag and drop fields from the dataset, the expression is
=first!( .value)
Niraj-627298
Niraj-627298
SSCommitted
SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)

Group: General Forum Members
Points: 1513 Visits: 719
Hi..

Please try once;

Go to layout option and there you may be using tables for creating report(s)....so...please select that table and click Properties tab / F4...

This will open Properties window and den you can see a dataset option listed dere...select the dataset name which is more appropriate or which u may be using for the table...This will surely...bind the dataset fields with the table and u'll b able to use Fields option in Expression window...rather than seeing d very first value of the respective fields...

Please try dis and let me knw..if it helps u..in any means...

Thanks,

Niraj
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search