Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » Data Set Troubles(Can't Preview a Data Set with Report Parameters)
Data Set Troubles [message #1835976] Thu, 17 December 2020 15:18 Go to next message
Raymond Rebro is currently offline Raymond RebroFriend
Messages: 3
Registered: December 2020
Junior Member
I am having an issue using stored procedure datasets with report parameters.

If I create stored procedure data set and provide the parameters for the procedure within the query text, I can get preview results just fine.

But if I try and use ? instead of an actual value. The preview shows up with the error 'Column binding "1" "has referred to a data set column" "1" which does not exist'.

I looked at the query appearing on the server side and it gets a valid query that returns results. Each parameter has default values.

For the life of me, cannot figure out why this isn't working

Report message to a moderator

Re: Data Set Troubles [message #1836044 is a reply to message #1835976] Fri, 18 December 2020 18:48 Go to previous messageGo to next message
rbaak Mising name is currently offline rbaak Mising nameFriend
Messages: 31
Registered: July 2009
Member
Did you change anything in your stored procedure? Did you try closing the query and see if you can pull back results in your report?

Robert Baakel
https://www.youtube.com/playlist?list=PLht0txJzVxKFp1WRUOouv7rQfkCmLjVas

Report message to a moderator

Re: Data Set Troubles [message #1836150 is a reply to message #1836044] Tue, 22 December 2020 15:30 Go to previous message
Raymond Rebro is currently offline Raymond RebroFriend
Messages: 3
Registered: December 2020
Junior Member
The contents of the stored procedure may have changed however if I am able to manually enter in parameters as opposed to using the Report Parameters and get the results. I would imagine that wouldn't be the source of the problem.

I have tried closing the query and the entire Eclipse environment.

Report message to a moderator

Previous Topic:Restart page number from 1 when work order number changes in BIRT
Next Topic:birt sql add hour
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Oct 02 23:05:09 GMT 2022

Powered by FUDForum. Page generated in 0.06146 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly