Report erroe

Hi All ,

i got tired from the component crytsal reports but i need it to finish an application i'm building .

i got the folloiwng error when i try to run the report.

ONE : Cannot implicitly convert type 'CrystalDecisions.Shared.TableLogOnInfos' to 'CrystalDecisions.Shared.TableLogOnInfo'

TWO: foreach statement cannot operate on variables of type 'CrystalDecisions.Shared.TableLogOnInfo' because 'CrystalDecisions.Shared.TableLogOnInfo' does not contain a public definition for 'GetEnumerator'

and here is the code that i'm using:

using CrystalDecisions.CrystalReports.Engine;
using CrystalDecisions.Shared;

namespace Hope
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void ConfigureCrystalReports()
{

ConnectionInfo connectionInfo = new ConnectionInfo();
connectionInfo.DatabaseName = "NorthWind";
connectionInfo.UserID = "";
connectionInfo.Password = "";

string reportPath = Application.StartupPath + "\\" +
"NorthwindCustomers.rpt";
crystalReportViewer.ReportSource = reportPath;



SetDBLogonForReport(connectionInfo);

}

private void Form1_Load(object sender, EventArgs e)
{
ConfigureCrystalReports();

}

private void SetDBLogonForReport(ConnectionInfo connectionInfo)
{
TableLogOnInfo tableLogOnInfos = crystalReportViewer.LogOnInfo;

foreach (TableLogOnInfo tableLogOnInfo in tableLogOnInfos)
{
tableLogOnInfo.ConnectionInfo = connectionInfo;
}


please try to help me find out , what's the problem , i'll get mad soon,hi
this is saurabh

i have creating a crystal report. in this report i want inserting no. of images .
can i put these images directly into the folders.
without saving in database.

plz... give reply as soon as possible....!|||Are you jokking ,

why to post here in my thread , create your own.

i'm so amazed from your action ,

Report deployment

Hello,

I have two questions:

1. When I debug my application it seems it deploys reports to report manager, how can I prevent that from happening, I would like to deploy when I chose deploy command only?
2. I have a report which has many sub-report, when I deploy sub-reports are deployed to report manager to and they become visible in the report manager screen., so user my chose and try to run them, I would like to make only my main report be visible on the report manager, is there anyway to accomplish this?

Thanks,

Disable the deploy of your project in the configuration for the solution in debug mode.

report by multiple parameter with OR relationship

I am trying to create a report with three parameters (date, license number and application number). I want report by License Number or Application number in the date that I put in. I trying following in Record Selection:
1.
{Command.LICENSE_NO} = {?License Number} or
{Command.LICENSE_ID} = {?Application Number}

2.
if isnull({?License Number}) = false then
{Command.LICENSE_NO} = {?License Number};
if isnull({?Application Number})=false then
{Command.LICENSE_ID}={?Application Number};

** license_id is the application number(number). license number(string)

but both of them do not work. somehow I can not leave Application number empty.

Please Help!!!As Application Number is a number, Crystal wants you to specify one.
If you default it to 0 you could have a selection formula like

({?Application Number} = 0 and {Command.LICENSE_NO} = {?License Number})
or
({?Application Number} <> 0 and {Command.LICENSE_ID} = {?Application Number})

which means that if you supply a non-zero application number it will be used in preference to any licence id you provide.|||As Application Number is a number, Crystal wants you to specify one.
If you default it to 0 you could have a selection formula like

({?Application Number} = 0 and {Command.LICENSE_NO} = {?License Number})
or
({?Application Number} <> 0 and {Command.LICENSE_ID} = {?Application Number})

which means that if you supply a non-zero application number it will be used in preference to any licence id you provide.

I have tried using 0 as default, but for some reason. I still can not leave application number empty. I used exactly same as your code

({?Application Number} = 0 and {Command.LICENSE_NO} = {?License Number})
or
({?Application Number} <> 0 and {Command.LICENSE_ID} = {?Application Number})

but search will not start if I leave application parameter empty.

any thought?

Thanks for your help|||As Application Number is a number, Crystal wants you to specify one.
If you default it to 0 you could have a selection formula like

({?Application Number} = 0 and {Command.LICENSE_NO} = {?License Number})
or
({?Application Number} <> 0 and {Command.LICENSE_ID} = {?Application Number})

which means that if you supply a non-zero application number it will be used in preference to any licence id you provide.

Got it working with your code!!!

Thanks your so much!!

Report Builder with Forms Authentication

Hi,

After implementing custom security extension for forms authentication, the report server works fine with Report Manager and web application. However, there is a problem with Report Builder.

It gives SecurityException "That assembly does not allow partially trusted callers.". Its becos I am using my own security assembly for authentication. I resolved this issue by using the following in my assemblyinfo.cs

[assembly: System.Security.Permissions.PermissionSet(System.Security.Permissions.SecurityAction.RequestMinimum, Name="FullTrust")]

However, now when I login to Report Builder it gives me error System.IO.FileNotFoundException. Its not able to find my security assembly.

I also tried giving FullTrust to the assembly using Framework 2.0 Configuration. I read somewhere that the ClickOnce application caches its last called settings in the manifest file and you have to delete the manifest and manually alter the security in the application settings(properties).

Is this true? Is there any solution to this issue? Is this really an issue with clickonce application?

This is really urgent. Any suggestions.

Thanks in advance.

Is there any solution to this?
This is really frustrating. We are duplicating all our security code into CustomSecurity Extension module. At least it stopped giving error at the point, where the call was made to an assembly. Dont know if it will really work, even after moving all the code to extension module.

I just hope someone from MS at least reads this post, if not care to reply.
I hope this helps someone.

Thankssql

Report Builder permissions

I would like to know how can I show parts of tables in report builder,

according to parameters that will be sent from the application.

Is it possible?

help...

can I send parameters to report builder, in order to show specific report model for each user?

report builder embedded

It's possible to have a report generator inside my application ASP 2.0 ?

you can host existing reports using report viewer controls.

hosting Report Builder UI is currently not supported

Report builder and custom security

We need to implement SQL Server 2005 Report Builder using our own security
model. We use application level authentication, in which a user ID and
password is verified against a record in the sql server database. So, we
don't use Windows Authentication. The problem is that we need to implement
the reporting builder as our ad-hoc reporting tool, but we need each user to
have his own private folder on the server. I've found only four articles on
http://msdn2.microsoft.com which talks about custom security extension, but
none of those is even close to what I'm looking for. I'm sure that there're
folks out there who've done this before.
Any suggestion or lead will be greatly appreciated.
Thanks,
Gilgameshhave you activated the "My Reports" option in reporting services?
this create a /My Reports folder and each user will have a private folder.
"Gilgamesh" <gilgamesh4ever@.aol.com> wrote in message
news:ONYLrGK0HHA.5644@.TK2MSFTNGP05.phx.gbl...
> We need to implement SQL Server 2005 Report Builder using our own security
> model. We use application level authentication, in which a user ID and
> password is verified against a record in the sql server database. So, we
> don't use Windows Authentication. The problem is that we need to implement
> the reporting builder as our ad-hoc reporting tool, but we need each user
> to have his own private folder on the server. I've found only four
> articles on http://msdn2.microsoft.com which talks about custom security
> extension, but none of those is even close to what I'm looking for. I'm
> sure that there're folks out there who've done this before.
> Any suggestion or lead will be greatly appreciated.
> Thanks,
> Gilgamesh
>|||Yes, I have. The problem is that My Reports works only if you use Windows
Autehtication. As I explained in the posting, we use database authetication.
-G
"Jeje" <willgart@.hotmail.com> wrote in message
news:Oz1e7LM0HHA.1164@.TK2MSFTNGP02.phx.gbl...
> have you activated the "My Reports" option in reporting services?
> this create a /My Reports folder and each user will have a private folder.
>
> "Gilgamesh" <gilgamesh4ever@.aol.com> wrote in message
> news:ONYLrGK0HHA.5644@.TK2MSFTNGP05.phx.gbl...
>> We need to implement SQL Server 2005 Report Builder using our own
>> security model. We use application level authentication, in which a user
>> ID and password is verified against a record in the sql server database.
>> So, we don't use Windows Authentication. The problem is that we need to
>> implement the reporting builder as our ad-hoc reporting tool, but we need
>> each user to have his own private folder on the server. I've found only
>> four articles on http://msdn2.microsoft.com which talks about custom
>> security extension, but none of those is even close to what I'm looking
>> for. I'm sure that there're folks out there who've done this before.
>> Any suggestion or lead will be greatly appreciated.
>> Thanks,
>> Gilgamesh
>>|||Have you implemented custom security in Reporting Services? I don't use
Report Builder but in the end you end up with a RDL just like if it had been
designed in Report Designer.
So, my question is, do you have your custom security implemented in any way
with RS? That is the first thing you will need to do.
http://msdn2.microsoft.com/en-us/library/ms152825.aspx
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Gilgamesh" <gilgamesh4ever@.aol.com> wrote in message
news:ercOBrW0HHA.4236@.TK2MSFTNGP06.phx.gbl...
> Yes, I have. The problem is that My Reports works only if you use Windows
> Autehtication. As I explained in the posting, we use database
> authetication.
> -G
> "Jeje" <willgart@.hotmail.com> wrote in message
> news:Oz1e7LM0HHA.1164@.TK2MSFTNGP02.phx.gbl...
>> have you activated the "My Reports" option in reporting services?
>> this create a /My Reports folder and each user will have a private
>> folder.
>>
>> "Gilgamesh" <gilgamesh4ever@.aol.com> wrote in message
>> news:ONYLrGK0HHA.5644@.TK2MSFTNGP05.phx.gbl...
>> We need to implement SQL Server 2005 Report Builder using our own
>> security model. We use application level authentication, in which a user
>> ID and password is verified against a record in the sql server database.
>> So, we don't use Windows Authentication. The problem is that we need to
>> implement the reporting builder as our ad-hoc reporting tool, but we
>> need each user to have his own private folder on the server. I've found
>> only four articles on http://msdn2.microsoft.com which talks about
>> custom security extension, but none of those is even close to what I'm
>> looking for. I'm sure that there're folks out there who've done this
>> before.
>> Any suggestion or lead will be greatly appreciated.
>> Thanks,
>> Gilgamesh
>>
>|||Bruce
ok, i need to do the same thing. But i am having some trouble with
configuring the secruity extension (Forms Authenication). i have an
question on the User Accounts database part.
The instructions say to replace the "LocalMachine" towards the end of
the createuserstore.sql. But i don't see any mention of that in the
script at all. Any ideas?
INSTRUCTIONS:
Locate "LocalMachine" towards the end of the script and replace it
with your own computer name. For Windows 2003 users, replace
LocalMachine\ASPNET with NT AUTHORITY\NETWORK SERVICE (except when in
IIS 5 compatibility mode).
createuserstore SCRIPT:
exec ('sp_grantlogin [' + @.ASPUserName + ']');
-- Add a database login for the UserAccounts database for the ASPNET
account
exec ('sp_grantdbaccess [' + @.ASPUserName + ']');
-- Grant execute permissions to the LookupUser and RegisterUser stored
procs
exec ('grant execute on LookupUser to [' + @.ASPUserName + ']');
exec ('grant execute on RegisterUser to [' + @.ASPUserName + ']');
------
Have you implemented custom security in Reporting Services? I don't
use
Report Builder but in the end you end up with a RDL just like if it
had been
designed in Report Designer.
So, my question is, do you have your custom security implemented in
any way
with RS? That is the first thing you will need to do.
http://msdn2.microsoft.com/en-us/library/ms152825.aspx
On Jul 29, 3:15 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> Have you implemented custom security in Reporting Services? I don't use
> Report Builder but in the end you end up with a RDL just like if it had been
> designed in Report Designer.
> So, my question is, do you have your custom security implemented in any way
> with RS? That is the first thing you will need to do.http://msdn2.microsoft.com/en-us/library/ms152825.aspx
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Gilgamesh" <gilgamesh4e...@.aol.com> wrote in message
> news:ercOBrW0HHA.4236@.TK2MSFTNGP06.phx.gbl...
>
> > Yes, I have. The problem is that My Reports works only if you use Windows
> > Autehtication. As I explained in the posting, we use database
> > authetication.
> > -G
> > "Jeje" <willg...@.hotmail.com> wrote in message
> >news:Oz1e7LM0HHA.1164@.TK2MSFTNGP02.phx.gbl...
> >> have you activated the "My Reports" option in reporting services?
> >> this create a /My Reports folder and each user will have a private
> >> folder.
> >> "Gilgamesh" <gilgamesh4e...@.aol.com> wrote in message
> >>news:ONYLrGK0HHA.5644@.TK2MSFTNGP05.phx.gbl...
> >> We need to implement SQL Server 2005 Report Builder using our own
> >> security model. We use application level authentication, in which a user
> >> ID and password is verified against a record in the sql server database.
> >> So, we don't use Windows Authentication. The problem is that we need to
> >> implement the reporting builder as our ad-hoc reporting tool, but we
> >> need each user to have his own private folder on the server. I've found
> >> only four articles onhttp://msdn2.microsoft.comwhich talks about
> >> custom security extension, but none of those is even close to what I'm
> >> looking for. I'm sure that there're folks out there who've done this
> >> before.
> >> Any suggestion or lead will be greatly appreciated.
> >> Thanks,
> >> Gilgamesh- Hide quoted text -
> - Show quoted text -|||Sorry, I have not implemented this. I suggest a separate post specifically
about that. Also, you might want to post it at the web based forums as well.
http://forums.microsoft.com/msdn/showforum.aspx?forumid=82&siteid=1
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Ryan Swann" <swannryan@.gmail.com> wrote in message
news:1185807504.059515.124770@.57g2000hsv.googlegroups.com...
> Bruce
> ok, i need to do the same thing. But i am having some trouble with
> configuring the secruity extension (Forms Authenication). i have an
> question on the User Accounts database part.
> The instructions say to replace the "LocalMachine" towards the end of
> the createuserstore.sql. But i don't see any mention of that in the
> script at all. Any ideas?
>
> INSTRUCTIONS:
> Locate "LocalMachine" towards the end of the script and replace it
> with your own computer name. For Windows 2003 users, replace
> LocalMachine\ASPNET with NT AUTHORITY\NETWORK SERVICE (except when in
> IIS 5 compatibility mode).
> createuserstore SCRIPT:
>
> exec ('sp_grantlogin [' + @.ASPUserName + ']');
> -- Add a database login for the UserAccounts database for the ASPNET
> account
> exec ('sp_grantdbaccess [' + @.ASPUserName + ']');
> -- Grant execute permissions to the LookupUser and RegisterUser stored
> procs
> exec ('grant execute on LookupUser to [' + @.ASPUserName + ']');
> exec ('grant execute on RegisterUser to [' + @.ASPUserName + ']');
> ------
> Have you implemented custom security in Reporting Services? I don't
> use
> Report Builder but in the end you end up with a RDL just like if it
> had been
> designed in Report Designer.
> So, my question is, do you have your custom security implemented in
> any way
> with RS? That is the first thing you will need to do.
> http://msdn2.microsoft.com/en-us/library/ms152825.aspx
>
>
>
>
> On Jul 29, 3:15 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> wrote:
>> Have you implemented custom security in Reporting Services? I don't use
>> Report Builder but in the end you end up with a RDL just like if it had
>> been
>> designed in Report Designer.
>> So, my question is, do you have your custom security implemented in any
>> way
>> with RS? That is the first thing you will need to
>> do.http://msdn2.microsoft.com/en-us/library/ms152825.aspx
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Gilgamesh" <gilgamesh4e...@.aol.com> wrote in message
>> news:ercOBrW0HHA.4236@.TK2MSFTNGP06.phx.gbl...
>>
>> > Yes, I have. The problem is that My Reports works only if you use
>> > Windows
>> > Autehtication. As I explained in the posting, we use database
>> > authetication.
>> > -G
>> > "Jeje" <willg...@.hotmail.com> wrote in message
>> >news:Oz1e7LM0HHA.1164@.TK2MSFTNGP02.phx.gbl...
>> >> have you activated the "My Reports" option in reporting services?
>> >> this create a /My Reports folder and each user will have a private
>> >> folder.
>> >> "Gilgamesh" <gilgamesh4e...@.aol.com> wrote in message
>> >>news:ONYLrGK0HHA.5644@.TK2MSFTNGP05.phx.gbl...
>> >> We need to implement SQL Server 2005 Report Builder using our own
>> >> security model. We use application level authentication, in which a
>> >> user
>> >> ID and password is verified against a record in the sql server
>> >> database.
>> >> So, we don't use Windows Authentication. The problem is that we need
>> >> to
>> >> implement the reporting builder as our ad-hoc reporting tool, but we
>> >> need each user to have his own private folder on the server. I've
>> >> found
>> >> only four articles onhttp://msdn2.microsoft.comwhich talks about
>> >> custom security extension, but none of those is even close to what
>> >> I'm
>> >> looking for. I'm sure that there're folks out there who've done this
>> >> before.
>> >> Any suggestion or lead will be greatly appreciated.
>> >> Thanks,
>> >> Gilgamesh- Hide quoted text -
>> - Show quoted text -
>|||I got evreything working, let me know if someone needs some help with it
"Bruce L-C [MVP]" wrote:
> Sorry, I have not implemented this. I suggest a separate post specifically
> about that. Also, you might want to post it at the web based forums as well.
> http://forums.microsoft.com/msdn/showforum.aspx?forumid=82&siteid=1
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Ryan Swann" <swannryan@.gmail.com> wrote in message
> news:1185807504.059515.124770@.57g2000hsv.googlegroups.com...
> > Bruce
> >
> > ok, i need to do the same thing. But i am having some trouble with
> > configuring the secruity extension (Forms Authenication). i have an
> > question on the User Accounts database part.
> >
> > The instructions say to replace the "LocalMachine" towards the end of
> > the createuserstore.sql. But i don't see any mention of that in the
> > script at all. Any ideas?
> >
> >
> > INSTRUCTIONS:
> >
> > Locate "LocalMachine" towards the end of the script and replace it
> > with your own computer name. For Windows 2003 users, replace
> > LocalMachine\ASPNET with NT AUTHORITY\NETWORK SERVICE (except when in
> > IIS 5 compatibility mode).
> >
> > createuserstore SCRIPT:
> >
> >
> > exec ('sp_grantlogin [' + @.ASPUserName + ']');
> >
> > -- Add a database login for the UserAccounts database for the ASPNET
> > account
> > exec ('sp_grantdbaccess [' + @.ASPUserName + ']');
> >
> > -- Grant execute permissions to the LookupUser and RegisterUser stored
> > procs
> > exec ('grant execute on LookupUser to [' + @.ASPUserName + ']');
> > exec ('grant execute on RegisterUser to [' + @.ASPUserName + ']');
> >
> > ------
> > Have you implemented custom security in Reporting Services? I don't
> > use
> > Report Builder but in the end you end up with a RDL just like if it
> > had been
> > designed in Report Designer.
> >
> > So, my question is, do you have your custom security implemented in
> > any way
> > with RS? That is the first thing you will need to do.
> > http://msdn2.microsoft.com/en-us/library/ms152825.aspx
> >
> >
> >
> >
> >
> >
> >
> >
> > On Jul 29, 3:15 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> > wrote:
> >> Have you implemented custom security in Reporting Services? I don't use
> >> Report Builder but in the end you end up with a RDL just like if it had
> >> been
> >> designed in Report Designer.
> >>
> >> So, my question is, do you have your custom security implemented in any
> >> way
> >> with RS? That is the first thing you will need to
> >> do.http://msdn2.microsoft.com/en-us/library/ms152825.aspx
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Gilgamesh" <gilgamesh4e...@.aol.com> wrote in message
> >>
> >> news:ercOBrW0HHA.4236@.TK2MSFTNGP06.phx.gbl...
> >>
> >>
> >>
> >> > Yes, I have. The problem is that My Reports works only if you use
> >> > Windows
> >> > Autehtication. As I explained in the posting, we use database
> >> > authetication.
> >> > -G
> >>
> >> > "Jeje" <willg...@.hotmail.com> wrote in message
> >> >news:Oz1e7LM0HHA.1164@.TK2MSFTNGP02.phx.gbl...
> >> >> have you activated the "My Reports" option in reporting services?
> >> >> this create a /My Reports folder and each user will have a private
> >> >> folder.
> >>
> >> >> "Gilgamesh" <gilgamesh4e...@.aol.com> wrote in message
> >> >>news:ONYLrGK0HHA.5644@.TK2MSFTNGP05.phx.gbl...
> >> >> We need to implement SQL Server 2005 Report Builder using our own
> >> >> security model. We use application level authentication, in which a
> >> >> user
> >> >> ID and password is verified against a record in the sql server
> >> >> database.
> >> >> So, we don't use Windows Authentication. The problem is that we need
> >> >> to
> >> >> implement the reporting builder as our ad-hoc reporting tool, but we
> >> >> need each user to have his own private folder on the server. I've
> >> >> found
> >> >> only four articles onhttp://msdn2.microsoft.comwhich talks about
> >> >> custom security extension, but none of those is even close to what
> >> >> I'm
> >> >> looking for. I'm sure that there're folks out there who've done this
> >> >> before.
> >>
> >> >> Any suggestion or lead will be greatly appreciated.
> >>
> >> >> Thanks,
> >> >> Gilgamesh- Hide quoted text -
> >>
> >> - Show quoted text -
> >
> >
>
>

Report Builder accessed using https over internet

If you access the report builder application over the internet using a secure connection such as https://<report server name>/reportserver/reportbuilder/reportbuilder.application, will report builder communicate using https? If not, will the data being transferred to/from the report server be encrypted by some other method in the application?

Report Builder actually switches between http and https based on the web service method being called and whether ListSecureMethods indicates that https should be used. You can configure these settings on the report server.

Here are a few links that might be useful:

http://msdn2.microsoft.com/en-us/library/ms345223.aspx

http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsmanagementservice2005.reportingservice2005.listsecuremethods.aspx

Report Builder / Report Models

We would like to support Report Builder / Report Models in our application,
and we know that Report models are generated from SQL Server relational or
Analysis Services multidimensional databases. Based on our superficial
understandings of report models, it seems that we should be able to create an
entity based on more than one source table/view with or without security
filters and even give it a friendly name. Is this correct? If so, is it
possible to create a report model programmatically?
If not programmatically, we would want more help with how to create a report
model in details. The current tutorial in the SQL Server Books online is
actually not detailed enough (most of the time it guides us to accept the
defaults).Hi,
Welcome to use MSDN Managed Newsgroup!
From your descriptions, I understood you would like to whether it is
possible to create a report model programmatically. If I have misunderstood
your concern, please feel free to point it out.
I think BOL contains two useful articles for your reference
How to: Create a Model Using Report Manager
http://msdn2.microsoft.com/en-us/library/ms159118.aspx
How to: Create a Report Model Using the Model Designer Wizard
http://msdn2.microsoft.com/en-us/library/ms156284.aspx
Also, this article explains the major components of Microsoft Reporting
Services' ad-hoc architecture and semantic model, and walks you through an
end-to-end example that demonstrates how to author, manage, and deliver
ad-hoc reports.
Generate Ad-hoc Reports with Microsoft Reporting Services 2005
http://www.devx.com/dbzone/Article/28047
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.

Report Builder - filtering data

We have a web application that supports muliple companies (around 500). All
tables in our SQL Server database have a CompanyId field. We want to use
SSRS Report Builder to let end users create Ad Hoc reports. We need to
build a Model/Data View that allows an end user to veiw data from their
company only. How would we filter the data so that our end users do not see
other companies data in the Model that we design?
We can not allow the end user to create a filter for CompanyID at run time.I am trying to do the exact same thing (as I'm sure are many others), so any
assistance from Microsoft on this topic would be greatly appreciated...
Michael Carr
"Eva M." <Eva M.@.discussions.microsoft.com> wrote in message
news:7C18DD4A-8D07-46CC-A837-CAA2D0D5B156@.microsoft.com...
> We have a web application that supports muliple companies (around 500).
> All
> tables in our SQL Server database have a CompanyId field. We want to use
> SSRS Report Builder to let end users create Ad Hoc reports. We need to
> build a Model/Data View that allows an end user to veiw data from their
> company only. How would we filter the data so that our end users do not
> see
> other companies data in the Model that we design?
> We can not allow the end user to create a filter for CompanyID at run
> time.
>

Report being generated never shows second report

I have a VS2005 Windows application that displays a reportviewer (SQL 2005) report in a tab control, then displays a second report in a second tab with reportviewer, and so on. The really strange thing is that I had this application working for about 3 months. I even had up to 30 reports in 30 tabs at one point. BUT, for some reason now all I get is the first report and the second, third, etc. tabs show a reportviewer with "Report being generated" that never displays the report. Even worse, another user is able to run this application and DOES get all the reports displayed. So what could have been updated on my PC that is causing this problem?

Thanks in advance.

The obvious question to ask is what's changed? Have you installed any service packs or updates recently? Maybe it was some new software?|||

I was hoping someone else could tell me what installations might cause this problem, because I can't be 100% sure what updates have been done to my PC. Our Network Services group pushes updates and with MS always forcing updates, it's difficult nowadays to know what's going on on your own PC. Anyway, in January, I installed Red Gate's SQL Prompt 3 and Net Services pushed McAfee OAS. I don't know the exact day Report Viewer stopped working, but I'm pretty sure it was working after these installs. The SQL Server/SSRS 2005 is running on SP1, my client SQL is on SP1. Here's the header info in the most recent SSRS log:

<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.2047.00</Product>
<Locale>en-US</Locale>
<TimeZone>Eastern Standard Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\LogFiles\ReportServer__02_22_2007_21_43_20.log</Path>
<SystemName>BNTRA</SystemName>
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName>
<OSVersion>5.2.3790.65536</OSVersion>
</Header>

Here are the last few lines in this log, that show me trying to run 2 reports. It looks like it does the same processing for both reports here, but it just can't display the report in the viewer.

w3wp!library!5!02/22/2007-22:08:11:: i INFO: Call to RenderFirst( '/JobReports/EOJreport' )
w3wp!library!1!02/22/2007-22:08:12:: i INFO: Call to RenderFirst( '/JobReports/EOJreport' )
w3wp!webserver!5!02/22/2007-22:08:12:: i INFO: Processed report. Report='/JobReports/EOJreport', Stream=''
w3wp!webserver!1!02/22/2007-22:08:13:: i INFO: Processed report. Report='/JobReports/EOJreport', Stream=''
w3wp!library!5!2/22/2007-22:13:21:: i INFO: Cleaned 0 batch records, 0 policies, 2 sessions, 0 cache entries, 2 snapshots, 12 chunks, 0 running jobs, 0 persisted streams
w3wp!library!a!2/22/2007-22:23:21:: i INFO: Cleaned 0 batch records, 0 policies, 2 sessions, 0 cache entries, 2 snapshots, 12 chunks, 0 running jobs, 0 persisted streams
w3wp!webserver!5!2/22/2007-22:29:04:: i INFO: Reporting Web Server stopped

Need more info? THANKS.

|||

After a lot of searching and matching dlls, it looks like that VS 2005 SP1 is my problem. I've started another thread here:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1279959&SiteID=1

Report being generated never shows second report

I have a VS2005 Windows application that displays a reportviewer (SQL 2005) report in a tab control, then displays a second report in a second tab with reportviewer, and so on. The really strange thing is that I had this application working for about 3 months. I even had up to 30 reports in 30 tabs at one point. BUT, for some reason now all I get is the first report and the second, third, etc. tabs show a reportviewer with "Report being generated" that never displays the report. Even worse, another user is able to run this application and DOES get all the reports displayed. So what could have been updated on my PC that is causing this problem?

Thanks in advance.

The obvious question to ask is what's changed? Have you installed any service packs or updates recently? Maybe it was some new software?|||

I was hoping someone else could tell me what installations might cause this problem, because I can't be 100% sure what updates have been done to my PC. Our Network Services group pushes updates and with MS always forcing updates, it's difficult nowadays to know what's going on on your own PC. Anyway, in January, I installed Red Gate's SQL Prompt 3 and Net Services pushed McAfee OAS. I don't know the exact day Report Viewer stopped working, but I'm pretty sure it was working after these installs. The SQL Server/SSRS 2005 is running on SP1, my client SQL is on SP1. Here's the header info in the most recent SSRS log:

<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.2047.00</Product>
<Locale>en-US</Locale>
<TimeZone>Eastern Standard Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\LogFiles\ReportServer__02_22_2007_21_43_20.log</Path>
<SystemName>BNTRA</SystemName>
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName>
<OSVersion>5.2.3790.65536</OSVersion>
</Header>

Here are the last few lines in this log, that show me trying to run 2 reports. It looks like it does the same processing for both reports here, but it just can't display the report in the viewer.

w3wp!library!5!02/22/2007-22:08:11:: i INFO: Call to RenderFirst( '/JobReports/EOJreport' )
w3wp!library!1!02/22/2007-22:08:12:: i INFO: Call to RenderFirst( '/JobReports/EOJreport' )
w3wp!webserver!5!02/22/2007-22:08:12:: i INFO: Processed report. Report='/JobReports/EOJreport', Stream=''
w3wp!webserver!1!02/22/2007-22:08:13:: i INFO: Processed report. Report='/JobReports/EOJreport', Stream=''
w3wp!library!5!2/22/2007-22:13:21:: i INFO: Cleaned 0 batch records, 0 policies, 2 sessions, 0 cache entries, 2 snapshots, 12 chunks, 0 running jobs, 0 persisted streams
w3wp!library!a!2/22/2007-22:23:21:: i INFO: Cleaned 0 batch records, 0 policies, 2 sessions, 0 cache entries, 2 snapshots, 12 chunks, 0 running jobs, 0 persisted streams
w3wp!webserver!5!2/22/2007-22:29:04:: i INFO: Reporting Web Server stopped

Need more info? THANKS.

|||

After a lot of searching and matching dlls, it looks like that VS 2005 SP1 is my problem. I've started another thread here:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1279959&SiteID=1

Report Application Server

I know very little about Crystal so please bear with me.

I have created a report and copied it to my new Report Application Server. When i try to launch it through eportfolio i get the following:

CrystalReportViewer

Failed to load database information. Details: The database DLL 'crdb_p2bbtrv.dll' could not be loaded. Error in File C:\WINDOWS\TEMP\{A5C8C86B-05EA-4CB3-92B1-DF48C5382F9C}.rpt: Failed to load database information.


webReporting.dll error '800002cd'
Failed to load database information. Details: The database DLL 'crdb_p2bbtrv.dll' could not be loaded. Error in File C:\WINDOWS\TEMP\{A5C8C86B-05EA-4CB3-92B1-DF48C5382F9C}.rpt: Failed to load database information.

/rassamples/en/asp/rPortfolio/HTMLViewers/interactiveViewer.asp, line 30

Any ideas anyone...??Just download crystal report x1 redistributable package to the server