stored proc + crystal report - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

stored proc + crystal report

Author

Topic

swatib
Posting Yak Master

173 Posts

Posted - 2007-03-30 : 06:07:10

HI All

I have a stored procedure that takes a whole query as a parameter like following:

Create proc test @query varchar(1000)
as
execute(@query)

Now this stored proc runs fine in QA. but i am using this SP in crystal report 8.5. when i am selecting this SP in crystal report creation wizard, it asks for a discrete value. i have tried all values but the wizard is not completing properly which in turn failure in preparation of report.

what's wrong in this. please guide me

thanks in advance.

Njoy Life

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-03-30 : 06:15:43

I don't see any reason to use such SP...I think you should reconsider design of your database if that is what forcing you to write such weird proc.

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

swatib
Posting Yak Master

173 Posts

Posted - 2007-03-30 : 06:35:18

Actually its a part of R&D.

I just wanted a dynamic report and put the same into PDF file using .NET and thats why i am going thru crystal report.

Njoy Life

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-03-30 : 06:53:51

And how crystal is going to understand which columns should be included to report, when everything is dynamic?

I think you need to take a look here if this is what you are trying to do:
[url]http://aspalliance.com/776[/url]

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-04-02 : 03:27:24

quote:
Originally posted by swatib

HI All

I have a stored procedure that takes a whole query as a parameter like following:

Create proc test @query varchar(1000)
as
execute(@query)

Now this stored proc runs fine in QA. but i am using this SP in crystal report 8.5. when i am selecting this SP in crystal report creation wizard, it asks for a discrete value. i have tried all values but the wizard is not completing properly which in turn failure in preparation of report.

what's wrong in this. please guide me

thanks in advance.

Njoy Life

You cant design a Crystal Report whose result set dynamically changes
Only way is designing seperate reports for each resultset

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources