Reports not showing any output

Srivas
Srivas Member Posts: 89
edited 2009-01-08 in NAV Three Tier
Hi,

I am trying to run reports in role tailored but can not see any data.
All the reports comes up with message (in the preview pane)
"An error occured during local report processing"
"A datasource instance has not been supplied for the data source Dataset_Result".

Any Suggestions please.

Thanks
Srivas

Comments

  • Belias
    Belias Member Posts: 2,998
    you mean ANY report you try to run?
    -Mirko-
    "Never memorize what you can easily find in a book".....Or Mibuso
    My Blog
  • Srivas
    Srivas Member Posts: 89
    yes. all reports show data on classic client but not on role tailored client.
    All forms on role tailored client are showing data.
    do you think that I may have broken some report file while creating new reports.?

    Regards,
  • Belias
    Belias Member Posts: 2,998
    yes. all reports show data on classic client but not on role tailored client.
    do you know how reports are managed in classic and RTC?
    classic --> as usual: Dataitem/section design etc...
    rtc --> through reporting services: go to a report design which of a report is not working (from the object designer), then click view, layout.
    firstly i tought that you have not a rdlc layout for the report, but the error that comes up is different.
    i'll do some test...
    -Mirko-
    "Never memorize what you can easily find in a book".....Or Mibuso
    My Blog
  • Srivas
    Srivas Member Posts: 89
    Yes I have created 2 reports in same fashion.
    To add to this :
    when we right click the report body (on Visual studio) and open the property window. I have dataset name as DataSet_Result. as per the attached image.
  • Belias
    Belias Member Posts: 2,998
    did you alrady try use "create layout suggestion" function?if not, try it and then try to run the report: if it works, match the differences between the working and non-working one (i mean rdlc layout)
    -Mirko-
    "Never memorize what you can easily find in a book".....Or Mibuso
    My Blog
  • Srivas
    Srivas Member Posts: 89
    I do not seem to have "Create layout suggestion" under tools menu.
    I am using Visual Studio SP1. I reinstalled the whole visual studio to check whether problem is becuase of the software version.
    Can anyone guide me if I am doing it wrong?
  • Belias
    Belias Member Posts: 2,998
    "create layout suggestion" is in the report designer in NAV!!!
    -Mirko-
    "Never memorize what you can easily find in a book".....Or Mibuso
    My Blog
  • Srivas
    Srivas Member Posts: 89
    Yes!!! I am sorry! please ignore my previous post.
  • Srivas
    Srivas Member Posts: 89
    But this has not changed the error i was getting before its still the same. I think i have missed some link here.
    I am getting this same error in standard reports as well which I expected will work anyhow.
    I am not able to resolve the error "A datasource instance has not been supplied for the data source Dataset_Result"
  • Belias
    Belias Member Posts: 2,998
    try to check the "DataSetFieldName" of the controls of your sections. it must be filled (i don't know if this is the problem, just try :mrgreen: )
    -Mirko-
    "Never memorize what you can easily find in a book".....Or Mibuso
    My Blog
  • Srivas
    Srivas Member Posts: 89
    Datasetfieldname property is set. As mentioned earlier same error is showing up on all standard reports as well.
  • Srivas
    Srivas Member Posts: 89
    found some thing new. I did a complete installation of Nav 2009.
    Ran the local database on a role tailored client. Report showing data. hurrah!
    But when I connect to the server , report does not show data.
    :roll:
  • Belias
    Belias Member Posts: 2,998
    Srivas wrote:
    !
    But when I connect to the server ,
    :roll:
    you mean: when you connect to a db which is on a server (not local) with your pc?
    :-k :-k :-k
    maybe somone know these thins better than me...let's wait...unfortunately i can try nav2009 only on my (local) server
    -Mirko-
    "Never memorize what you can easily find in a book".....Or Mibuso
    My Blog

Categories