SQL reporting Services new table fields added

armela20

Hi there.
I have created a bunch of reports in SQL reporting services and they all work fine.
Now I added a new field to a Navision table and I need to filter on that field on my query. when I go to the query designer and look for that field on that table It is not there.
Now it makes sense that I have to refresh somthing or restart something for the changes to take in effect, kind of like how NAS works, however I am not sure what in SQL reporting services.
Can someone please offer their advice ??

Thanks,

kine

It depends how you are using the Reporting Services, may be that you are using some Model and not directly the tables, or some Queries with listed fields and not * to take all fields etc...

stryk

Is the field you've added to the NAV table a "FlowField"? FF are only available in the NAV C/SIDE designer, not in the SQL site table!

garak

If the Field is a Flowfield add this as field but you can create a separete select statemant with select sum(Fieldname) (if the formula is SUM on flowfield) or if you will use the SIFT tables with joins or subqueries.

Regards

armela20

I am using a query where I select the fields from the table. This new field is not a flowfield. I am picking the fields from the query designer, view tables.

Thanks

kine

And in the query designer, you do not see the field?

armela20

No, I do not see the field in query designer.
Remeber the query was already there and the report is functional and running. I added a new field to one of the tables in the query and I want to add code on the query designer to only show records where the new field is set to True, however I do not see the new field.

Thanks

Armela

kine

It seems that you need to refresh the definitions in the VS. Try to reconnect to the server and do refresh...