TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Diane
NA
40
0
sql server report service 2008 error
Apr 1 2010 8:52 AM
'The tablix 'Table1' has a detail member with inner members. Detailed members can only contain static inner memmbers.
I am getting the above error message in sql server reporting service 2008 when do the following when there is nothing on the design surface
(creating a report without the report wizard):
a. I drag on a 'list' item from the tookbox onto the 'design surface'.
b. I drag a few columns from the dataset onto the 'list' item.
c. I then place a 'table' toolbox item within the 'list' item.
d. I then preview the report.
I think I want the control 'row' group to work, but I am having trouble getting that setup.
Basically what I am trying to do overall is have:
1. The report parameters work,
2. I want the table to redisplay every time I come across a new secondary level control break,
3. I want to use the report parameters to only select a of the 'general' population.
Note: I have also used the report wizard and I can get each of the following items to work alone but not together:
1. I can get the report parameters to work,
2. I can get the the report to display everytime there is a change in the change in the control group.
Basically I want to be able to do something like the following:
1. In the parameters, I want to be able to select the country I want.
2. I then want to display a fresh copy of the report everytime the state/province changes.
Let me know what combination of solutions may work here.
Reply
Answers (
0
)
Connection problem in SQL Server 2008
how to display last modified record from sqlserver table?