Friday, March 23, 2012
How to use stored procedures as the dataset for reports?
I want to use a stored procedure as the dataset for a report.
Even though I could execute the stored procedure in the query designer view,
the report designer did not generate the fields list (in the fields window).
Then I specified all the fields explicitly in the fields property of that
dataset. But when I tried to see the report in the preview pane, it gave me
a message that the dataset does not contain the required fields. I verified
the field names and they were exactly matching so no typo out there.
Can anyone tell me how can use a stored procedure as the dataset?
thanks,
NileshThere is a button that looks like the refresh button in IE that if you hover
over it is says refresh fields. Click on that and it will get all the field
information.
Bruce L-C
"Nilesh Oswal" <nilesh_oswal@.persistent.co.in> wrote in message
news:enGR9A3YEHA.3892@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I want to use a stored procedure as the dataset for a report.
> Even though I could execute the stored procedure in the query designer
view,
> the report designer did not generate the fields list (in the fields
window).
> Then I specified all the fields explicitly in the fields property of that
> dataset. But when I tried to see the report in the preview pane, it gave
me
> a message that the dataset does not contain the required fields. I
verified
> the field names and they were exactly matching so no typo out there.
> Can anyone tell me how can use a stored procedure as the dataset?
> thanks,
> Nilesh
>|||After executing the query from the designer, click the refresh button. Your fields should then populate.
Dave
--
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.
Wednesday, March 7, 2012
how to use designer environment in cystal report 11
Please help me !
note : - Crystal Report is really a mess!You need to use Report Viewer
Sunday, February 19, 2012
How to use a table with table name starting "@" symbol in dataset
Hi ,
I have a database with a table name called @.budget_tot.
When I run a query in report designer --dataset, it throws an error thinking this is a variable rather
than a table.
Same query works without error in SQL 2005 query window.
example Query;
Select T1.U_Budget From [@.budet_tot] T1
Sonny
SInce no one answered I'll give you my current workaround.
Create a parameter and either make it hidden (with null) or make it internal.
So the report runs without anyone seeing parameter.
Sonny
|||I am rather new to Reporting Services, but in other places if you will enclose your table name with square brackets the name should be accepted. Try [@.budget_tot] instead of @.budget_tot.|||Hi Kent, Thanks for the reply. This works in SQL qoery analyser but not in report designer.
Sonny
How to use a table with table name starting "@" symbol in dataset
Hi ,
I have a database with a table name called @.budget_tot.
When I run a query in report designer --dataset, it throws an error thinking this is a variable rather
than a table.
Same query works without error in SQL 2005 query window.
example Query;
Select T1.U_Budget From [@.budet_tot] T1
Sonny
SInce no one answered I'll give you my current workaround.
Create a parameter and either make it hidden (with null) or make it internal.
So the report runs without anyone seeing parameter.
Sonny
|||I am rather new to Reporting Services, but in other places if you will enclose your table name with square brackets the name should be accepted. Try [@.budget_tot] instead of @.budget_tot.|||Hi Kent, Thanks for the reply. This works in SQL qoery analyser but not in report designer.
Sonny