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
Eclipse UserFriend
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
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
Eclipse UserFriend
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?
Re: Data Set Troubles [message #1836150 is a reply to message #1836044] Tue, 22 December 2020 15:30 Go to previous message
Eclipse UserFriend
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.
Previous Topic:Restart page number from 1 when work order number changes in BIRT
Next Topic:birt sql add hour
Goto Forum:
  


Current Time: Mon Feb 10 21:07:28 GMT 2025

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

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

Back to the top