Report Viewer trying to get it running and having problems

I have a website with two textboxes. I am passing those text boxes as parameters into the Report Viewer. I receive this error: "An error has occurred during report processing. ObjectDataSource 'ObjectDataSource1' could not find a non-generic method 'GetData' that has no parameters."

I thought I had the xsd and rdlc set up properly but obviously I am missing something. If you can step me through this I would appreciate it.

Look in the control ObjectDataSource this control have the Property Select Method and Select Parmaters .

The Select Method must be with the parameters EJ: GetData(idcity)

In Select Parameters you have to add the parameter -- one for each textbox

You can send me the code for more help :victormartineze@.gmail.com

Sorry i dont speack english

Report Two Data Subsets in the same Grid

This is likely very easy, but I'm not sure which direction is the best
way to go...
Dimension:
Time: Date and Hour the record occurred
Cube:
Has a field that counts the number of times an event occurred in a
given hour
I want to show a grid that has for each day of the month how many times
an event occured between 8:00 and 16:00 and from 16:00 to 20:00 hours.
What is the best way to role up the records in the report?
I've seen two possible ways to do it...
1) Use calculated fields with IIF statements to try to role up the
records.
Problem: IIF statement doesn't seem to work correctly.
2) Use a Matrix control to Filter the records correctly.
Problem: I can't seem to have two Filters on the Hour Group in the same
Matrix. One for 08:00 to 16:00 and one for 16:00 to 20:00.
Clearly I'm missing some key concept, because what I'm asking has to be
commonplace. Can someone point me in the right direction?
Thanks,
Paul WI might have missed something, but this is my suggestion:
Create a dataset that returns the number of events in two section, one for
8-16 and the other for 16-20. You should be able to do this with a
calculated member and filter in your MDX query. (No good examples spring to
mind, but you can always ask in the microsoft.public.sqlserver.olap news
group.)
Then create a matrix, and have two coloums (one for each section of the day)
and group on date.
Kaisa M. Lindahl Lervik
"Paul W" <pbwedz@.yahoo.com> wrote in message
news:1155143250.949345.213080@.n13g2000cwa.googlegroups.com...
> This is likely very easy, but I'm not sure which direction is the best
> way to go...
> Dimension:
> Time: Date and Hour the record occurred
> Cube:
> Has a field that counts the number of times an event occurred in a
> given hour
> I want to show a grid that has for each day of the month how many times
> an event occured between 8:00 and 16:00 and from 16:00 to 20:00 hours.
> What is the best way to role up the records in the report?
> I've seen two possible ways to do it...
> 1) Use calculated fields with IIF statements to try to role up the
> records.
> Problem: IIF statement doesn't seem to work correctly.
> 2) Use a Matrix control to Filter the records correctly.
> Problem: I can't seem to have two Filters on the Hour Group in the same
> Matrix. One for 08:00 to 16:00 and one for 16:00 to 20:00.
> Clearly I'm missing some key concept, because what I'm asking has to be
> commonplace. Can someone point me in the right direction?
> Thanks,
> Paul W
>

Report Server error

I have a RS200 server with many reports that work fine. There is one report
that comes up with the following error:
An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
Query execution failed for data set 'StockCoverage'.
(rsErrorExecutingCommand) Get Online Help
Error converting data type nvarchar to smalldatetime.
The dataset invokes a stored procedure. The report renders perfectly in the
development environment, VS.Net. The stored proc produces the desired results
with Query Analyser and various other tools. Once deployed to the Report
Server the error comes up. Can you help ?Hi Claude,
RS have very close for datetime format.
You have 2 solutions:
-User a corect format mm/dd/yyyy 0:00:00, ex 10/21/2005 14:55:25
-Or converter the string to smalldatetime with convert() funtion in the
expresion where you use the value.
I hope help you
"Claude" wrote:
> I have a RS200 server with many reports that work fine. There is one report
> that comes up with the following error:
> An error has occurred during report processing. (rsProcessingAborted) Get
> Online Help
> Query execution failed for data set 'StockCoverage'.
> (rsErrorExecutingCommand) Get Online Help
> Error converting data type nvarchar to smalldatetime.
> The dataset invokes a stored procedure. The report renders perfectly in the
> development environment, VS.Net. The stored proc produces the desired results
> with Query Analyser and various other tools. Once deployed to the Report
> Server the error comes up. Can you help ?|||Hey Manuel,
Thanks for the response. The report runs perfectly in the preview tab while
designing it in VS.Net. So I think all the datetime handling is correct.
(The Report server is local by the way)
Any other ideas ?
Cheers,
Claude
"Manuel" wrote:
> Hi Claude,
> RS have very close for datetime format.
> You have 2 solutions:
> -User a corect format mm/dd/yyyy 0:00:00, ex 10/21/2005 14:55:25
> -Or converter the string to smalldatetime with convert() funtion in the
> expresion where you use the value.
> I hope help you
>
> "Claude" wrote:
> > I have a RS200 server with many reports that work fine. There is one report
> > that comes up with the following error:
> >
> > An error has occurred during report processing. (rsProcessingAborted) Get
> > Online Help
> > Query execution failed for data set 'StockCoverage'.
> > (rsErrorExecutingCommand) Get Online Help
> > Error converting data type nvarchar to smalldatetime.
> >
> > The dataset invokes a stored procedure. The report renders perfectly in the
> > development environment, VS.Net. The stored proc produces the desired results
> > with Query Analyser and various other tools. Once deployed to the Report
> > Server the error comes up. Can you help ?|||Oh silly boy ! The data type of the report parameter needs to be DateTime !
In the dev environment it is obviously interpreted correctly . . .
"Claude" wrote:
> I have a RS200 server with many reports that work fine. There is one report
> that comes up with the following error:
> An error has occurred during report processing. (rsProcessingAborted) Get
> Online Help
> Query execution failed for data set 'StockCoverage'.
> (rsErrorExecutingCommand) Get Online Help
> Error converting data type nvarchar to smalldatetime.
> The dataset invokes a stored procedure. The report renders perfectly in the
> development environment, VS.Net. The stored proc produces the desired results
> with Query Analyser and various other tools. Once deployed to the Report
> Server the error comes up. Can you help ?