Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Nable to fetch data in crystal report designer Post Reply Post New Topic
Author Message
Naveen Reddy
Newbie
Newbie


Joined: 04 Feb 2016
Location: India
Online Status: Offline
Posts: 2
Quote Naveen Reddy Replybullet Topic: Nable to fetch data in crystal report designer
    Posted: 09 Feb 2016 at 7:26pm
Hi All,

I am new to crystal report and there are some reports in our environment. There is one input parameter which prompts for project number(input parameter name). Issue I am facing is when I run for a particular project numbers,no data is displayed. The same query when I ran in database, results are displayed. This I am running in crystal report designer.

It is a very simple query and I am able to run for some other project numbers.
I will be happy if any one help me on this.
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet Posted: 10 Feb 2016 at 4:28am
Hard to say.  Have you examined the SQL that Crystal generates and see if that work in the database?
IP IP Logged
Naveen Reddy
Newbie
Newbie


Joined: 04 Feb 2016
Location: India
Online Status: Offline
Posts: 2
Quote Naveen Reddy Replybullet Posted: 10 Feb 2016 at 11:02pm
Hi,

How can I check that? I ran the query that I written in the crystal report, in database. I am able to get the result for the issue project number.
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet Posted: 11 Feb 2016 at 4:17am
Sounds like a very odd issue.  If the query generated by Crystal produces results when there is no parameter present, then somehow the parameter must be set up incorrectly.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.