How to diplay a dataset in a table

Hi all..
I have a dataset named "Primas" that returns 3 records with 3 fields each.
I want to display a list of those records with a header and a summarize row.
To do that, I placed a Table control into the layout. Assigned "Primas" as
the dataset and I placed a textbox control into it with the value of
=Fields!CODIGOPRIMA.value (CODIGOPRIMA belongs to Primas dataset)
When I build the report, I get the error:
"Expression value of object CODIGOPRIMA reference field CODIGOPRIMA. Report
element expressions can only reference a field in actual dataset scope or, if
they are inside an aggregate, the specified dataset scope"
(I translated the messaege from Spanish, so I'm not sure if it is accurate,
but that's the idea).
The question.. why I get that message although I have the dataset specified
for that table? When I go to a field property inside the table, under
expressions, system shows me only the fields from a dataset that is the
parent of the table (a List)
Any help will be greately appreciated,
Thanks
JaimeYou might check that the Dataset is aware of the field you are trying to
use. You can do this by clicking on the Refresh button on the Data tab with
that dataset selected. I get that same message if I've added or changed a
field in the underlying database and forget to refresh the dataset.
Jared
"Jaime Stuardo" <JaimeStuardo@.discussions.microsoft.com> wrote in message
news:8C285D68-701D-451F-A2A8-363B80874025@.microsoft.com...
> Hi all..
> I have a dataset named "Primas" that returns 3 records with 3 fields each.
> I want to display a list of those records with a header and a summarize
> row.
> To do that, I placed a Table control into the layout. Assigned "Primas" as
> the dataset and I placed a textbox control into it with the value of
> =Fields!CODIGOPRIMA.value (CODIGOPRIMA belongs to Primas dataset)
> When I build the report, I get the error:
> "Expression value of object CODIGOPRIMA reference field CODIGOPRIMA.
> Report
> element expressions can only reference a field in actual dataset scope or,
> if
> they are inside an aggregate, the specified dataset scope"
> (I translated the messaege from Spanish, so I'm not sure if it is
> accurate,
> but that's the idea).
> The question.. why I get that message although I have the dataset
> specified
> for that table? When I go to a field property inside the table, under
> expressions, system shows me only the fields from a dataset that is the
> parent of the table (a List)
> Any help will be greately appreciated,
> Thanks
> Jaime|||Hi Tom...
I have done so but the same problem happens. And when I go to the field
value combobox, only dataset fields associated with the List are shown, not
table daaset fields.
Jaime
"Tom Rocco" wrote:
> You might check that the Dataset is aware of the field you are trying to
> use. You can do this by clicking on the Refresh button on the Data tab with
> that dataset selected. I get that same message if I've added or changed a
> field in the underlying database and forget to refresh the dataset.
> Jared
> "Jaime Stuardo" <JaimeStuardo@.discussions.microsoft.com> wrote in message
> news:8C285D68-701D-451F-A2A8-363B80874025@.microsoft.com...
> > Hi all..
> >
> > I have a dataset named "Primas" that returns 3 records with 3 fields each.
> >
> > I want to display a list of those records with a header and a summarize
> > row.
> > To do that, I placed a Table control into the layout. Assigned "Primas" as
> > the dataset and I placed a textbox control into it with the value of
> > =Fields!CODIGOPRIMA.value (CODIGOPRIMA belongs to Primas dataset)
> >
> > When I build the report, I get the error:
> > "Expression value of object CODIGOPRIMA reference field CODIGOPRIMA.
> > Report
> > element expressions can only reference a field in actual dataset scope or,
> > if
> > they are inside an aggregate, the specified dataset scope"
> > (I translated the messaege from Spanish, so I'm not sure if it is
> > accurate,
> > but that's the idea).
> >
> > The question.. why I get that message although I have the dataset
> > specified
> > for that table? When I go to a field property inside the table, under
> > expressions, system shows me only the fields from a dataset that is the
> > parent of the table (a List)
> >
> > Any help will be greately appreciated,
> > Thanks
> > Jaime
>
>

How to determine in a report if the dataset has data

Is there anyway to tell if a report has data? I am looking for an
expression or something that would allow me to display a message if
the dataset is empty.Stephen Witter wrote:
> Is there anyway to tell if a report has data? I am looking for an
> expression or something that would allow me to display a message if
> the dataset is empty.
If you have a table or other data region that's bound to this data set,
look at the NoRows property in the properties window of that report item.
--
Thanks.
Donovan R. Smith
Software Test Lead
This posting is provided "AS IS" with no warranties, and confers no rights.|||precisely what I was looking for. Thank you for the quick response.
"Donovan R. Smith [MS]" <donovans@.online.microsoft.com> wrote in message
news:OpBXkYEoEHA.3460@.TK2MSFTNGP15.phx.gbl...
> Stephen Witter wrote:
>> Is there anyway to tell if a report has data? I am looking for an
>> expression or something that would allow me to display a message if
>> the dataset is empty.
> If you have a table or other data region that's bound to this data set,
> look at the NoRows property in the properties window of that report item.
> --
> Thanks.
> Donovan R. Smith
> Software Test Lead
> This posting is provided "AS IS" with no warranties, and confers no
> rights.

How to Determine Data Source Associated with Report

Within report design mode, I can see the DataSet, but I can't tell if this
was created using a Shared Data Source or was it created before I created
and started using a Shared Data Source. I have a problem publishing reports
that used the Shared Data Source. Now I want to check and see how I
originally set the DataSet -- to use the Shared Data Source or not. Any way
to see that?
Thanks,
Boolean1On Mar 1, 1:24 pm, "Boolean1" <Boole...@.comcast.net> wrote:
> Within report design mode, I can see the DataSet, but I can't tell if this
> was created using a Shared Data Source or was it created before I created
> and started using a Shared Data Source. I have a problem publishing reports
> that used the Shared Data Source. Now I want to check and see how I
> originally set the DataSet -- to use the Shared Data Source or not. Any way
> to see that?
> Thanks,
> Boolean1
In the 'Data' tab select the datasets for the report in question and
select the Edit Selected Dataset button [...]. On the 'Query' tab,
below Datasource: is the datasource for the dataset. Select the [...]
button to the right. Near the bottom of the General tab look to see if
'Use shared datasource reference' is checked. Hope this helps.
Regards,
Enrique Martinez
Sr. SQL Server Developer

How to deliver a report dynamically based on the dataset with standard edition?

Hi All,

I am working on a report which displays profit and loss discrepancy between two systems. So if there is discrepancy, in other words, the dataset returns value, then I want reporting serive to deliever the report to intended users. I am currently using standard edition with no data-driven subscription support.

I do not know what is the workaround for this implementation. Tks for advise in advance.

Alex

Sounds like you need a custom application to check the condition. You can use the RS FireEvent API to trigger the subscribed delivery.|||

Tks for your reply. Can we also render report inside SSIS, then send out to users? Not sure if that is possible.

Alex

|||I don't see a reason why this shouldn't work. You can write a script task to call down to the SSRS web service and request the report by invoking the Render method.|||

Great, thanks for your answer.

Also, I have another issue with ReportingService2005.FireEvent API, whenever it gets called, the system threw an exception said "insufficient permission for performing this operation". No idea how to fix it. Thanks in advance.

Sample Code:

rs.FireEvent("TimedSubscription", SubID);

Alex

|||

I don't know why it won't work if you are executing the call as a local admin on your local machine where SSRS is installed. If not, does it work if you add the the Windows identity the call is going under to the local Administrators group? If so, you need grant that user System Admin rights in the Report Manager.

|||

Hi,

I found the answer that by default "Generate event" permission is not granted to anyone. You have to go to report manager, security section to check this item. Tks.

Alex