Showing posts with label designer. Show all posts
Showing posts with label designer. Show all posts

Friday, March 23, 2012

How to use stored procedures as the dataset for reports?

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,
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

I have used crystal report 8.5 in a vb6.0 project using designer activex environment. Now i have installed crystal report11. But 11 does not apear in the activex environment. Vb refrence also shows activex run time library missing.
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