connecting to data source issue

I'm having a problem connecting to an access database from
http://localhost/reports. I can connect from the computer I developed the
reports but when I goto another computer it gives me this error message
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'DataSource1'.
(rsErrorOpeningConnection)
I've created the same exact odbc connection in the systems tab as on the
computer I've created the project with. I've looked at there online help
but it didn't have any suggestions.
Is there anything else I need to do on the other computer in order for this
to work?
TIA,
JacksonHi Jackson
I am having the exact same problem. Did you find a solution? Should I find
one I will post it here.
Tina - MSFTE
"Jackson" wrote:
> I'm having a problem connecting to an access database from
> http://localhost/reports. I can connect from the computer I developed the
> reports but when I goto another computer it gives me this error message
> An error has occurred during report processing. (rsProcessingAborted)
> Cannot create a connection to data source 'DataSource1'.
> (rsErrorOpeningConnection)
> I've created the same exact odbc connection in the systems tab as on the
> computer I've created the project with. I've looked at there online help
> but it didn't have any suggestions.
> Is there anything else I need to do on the other computer in order for this
> to work?
>
> TIA,
> Jackson
>
>|||Jackson and Tina
I am having the same problem and have posted everywhere trying to find a
fix. This supposedly works. I have turned it over to the Network Mgr and he
is reviewing it. Hopefully, it will solve the problem. If it works, please
let me know or, if you find another solution I wuld really appreciate hearing
about it.
Roy
1. Kerberos is enabled
2. The servers are trusted for delegation
3. The SPN's are configured
"http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_security_2gmm.asp"
4. If you have several domain controllers wait for replication to complete.
If you don't wait you will pull your hair out because nothing you try will
works and all of sudden a few hours latter it starts working and you can't
figure out why.
5. Make sure all users have the option 'Enable Integrated Windows
Authentication' enabled in internet explorer, without it they will still get
the authentication error.
"Jackson" wrote:
> I'm having a problem connecting to an access database from
> http://localhost/reports. I can connect from the computer I developed the
> reports but when I goto another computer it gives me this error message
> An error has occurred during report processing. (rsProcessingAborted)
> Cannot create a connection to data source 'DataSource1'.
> (rsErrorOpeningConnection)
> I've created the same exact odbc connection in the systems tab as on the
> computer I've created the project with. I've looked at there online help
> but it didn't have any suggestions.
> Is there anything else I need to do on the other computer in order for this
> to work?
>
> TIA,
> Jackson
>
>|||It took a while but I finally got a work around.
I'm currently taking daily snapshots of the access reports. So now I don't
even need to create odbc connections on other user computers.
"Tina (MSFTE)" <Tina (MSFTE)@.discussions.microsoft.com> wrote in message
news:212D3E5F-C8D8-412F-9493-EBB9EACADA1A@.microsoft.com...
> Hi Jackson
> I am having the exact same problem. Did you find a solution? Should I find
> one I will post it here.
> Tina - MSFTE
> "Jackson" wrote:
>> I'm having a problem connecting to an access database from
>> http://localhost/reports. I can connect from the computer I developed
>> the
>> reports but when I goto another computer it gives me this error message
>> An error has occurred during report processing. (rsProcessingAborted)
>> Cannot create a connection to data source 'DataSource1'.
>> (rsErrorOpeningConnection)
>> I've created the same exact odbc connection in the systems tab as on the
>> computer I've created the project with. I've looked at there online help
>> but it didn't have any suggestions.
>> Is there anything else I need to do on the other computer in order for
>> this
>> to work?
>>
>> TIA,
>> Jackson
>>|||Roy,
Your post put me on the right track. The IIS server we deployed to is not in
a domain, neither was any of the users. I did not even think of looking for
this scenario, I assumed we were on the domain.
1) I requested a user to be created on the domain.
2) I gave this user Data reader rights on all the SQL and AS servers that
forms part of my solution
3) In RS I used the full username and password to be saved securely in RS
4) Selected "Use as WIS credentials to make the connection"
5) Selected "Impersonate user after connection created"
It works like a charm. Due to the client's unique network configuration -
servers on the network, but not in the domain - this is the only way the
solution will work.
"Roy" wrote:
> Jackson and Tina
> I am having the same problem and have posted everywhere trying to find a
> fix. This supposedly works. I have turned it over to the Network Mgr and he
> is reviewing it. Hopefully, it will solve the problem. If it works, please
> let me know or, if you find another solution I wuld really appreciate hearing
> about it.
> Roy
> 1. Kerberos is enabled
> 2. The servers are trusted for delegation
> 3. The SPN's are configured
> "http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_security_2gmm.asp"
> 4. If you have several domain controllers wait for replication to complete.
> If you don't wait you will pull your hair out because nothing you try will
> works and all of sudden a few hours latter it starts working and you can't
> figure out why.
> 5. Make sure all users have the option 'Enable Integrated Windows
> Authentication' enabled in internet explorer, without it they will still get
> the authentication error.
> "Jackson" wrote:
> > I'm having a problem connecting to an access database from
> > http://localhost/reports. I can connect from the computer I developed the
> > reports but when I goto another computer it gives me this error message
> >
> > An error has occurred during report processing. (rsProcessingAborted)
> >
> > Cannot create a connection to data source 'DataSource1'.
> > (rsErrorOpeningConnection)
> >
> > I've created the same exact odbc connection in the systems tab as on the
> > computer I've created the project with. I've looked at there online help
> > but it didn't have any suggestions.
> >
> > Is there anything else I need to do on the other computer in order for this
> > to work?
> >
> >
> > TIA,
> >
> > Jackson
> >
> >
> >|||I ran into the same issue. I have modified security to report howeve
I noticed that it is using the users credentials who is accessing th
report to initiate Oracle connection. It looks like the use
requires elevated permissions on C:\Program Files\Oracle and possibl
other directories
Still investigating...
Rya|||If you creaye a secure use in RSthat user can have the elevated priviledges
and not your real life users - better from a security point of view - that is
why I selected the options I did. See if that works to Oracle as well.
Cioa
Tina
"rjohnstone" wrote:
> I ran into the same issue. I have modified security to report however
> I noticed that it is using the users credentials who is accessing the
> report to initiate Oracle connection. It looks like the user
> requires elevated permissions on C:\Program Files\Oracle and possibly
> other directories.
> Still investigating...
> Ryan
>

Connecting to Access2000 database at runtime from VB

Hi,

I want to connect to Crystal reports from VB.I am using CR ver 8.5 The database should be set at runtime instead of design time so that where ever I place my application the report should work from that directory (it could be d:\ or e:\ or N:\). The path should not be hardcoded in the report where we give the set location path. plssss help me out, this is very urgent

venkyHi Venky,
See if this will help:
http://www.dev-archive.com/forum/showthread.php?t=337289|||strDBPath = App.Path & "\CTS.mdb"
Set conRep = conAPP.OpenReport(App.Path & "\reports\PCCost.rpt", 1)
Set crxDatafiles = conRep.Database.Tables
crxDatafiles(1).SetLogOnInfo (strDBPath)

but still i am getting the error "File could not be found" "PCMonAmtQ" at file location "CTS.mdb"

pls let me know what is the error

thanks in advance

venky|||Hmmmm, that's a strange error message. It seems like it is looking for a file called "PCMonAmtQ". Could that be associated with your db?

I wish I could be of more help, but I am at a lose here...

Keep me posted =)

Connecting to a different stored procedure at runtime

Hello..
I am using Crystal Reports 10. Am running the report through some asp pages. The report is tied to a stored procedure at design time. Can I make the report connect to a different stored procedure at runtime? Both these stored procs have the same output in terms of columns. They differ only in the data.
Thanks,
ManishTry this
In your Application Use

CR.Database.tables(0)="SP Name"

Connecting Data with Groups

I'm creating Reporting Services reports in Visual Studio. I'm in the
interface that shows the Data, Layout, and Preview tabs.
I've recently learned that I can drag a list control onto the design surface
from the toolbox, then drag a field from the dataset onto the list control.
I can click the list control properties, click "Edit details group..." In
the top line of the expression list, I choose my field from the dropdown. I
check "Page break at end." If my data is from "select name from mytable", and
there's 4 names, I get 4 pages. This works great!
Here's the problem. I want my data to be from "select name, itemsordered,
itemsbought from mytable". I want itemsordered and itemsbought to go into a
table, leaving name in the list control. How do I reference the table control
to the list control?
I have 4 records. In everything I've tried, pages 1-4 show the names in the
list control, and pages 5-8 show the items in the table. Page 1 should show
the name from record 1, and the items in the table from record 1. Page 2
should show the name from record 2, and the items in the table from record
2...
--
RandyI believe I was one of those who answered before and thought this may be an
issue. There are a couple of approaches you can take. The first is to
continue using the list control. You can actually drag any fields you want
into it. Resize it if you don't have enough room. You can arrange the
additional fields in a table format.
If you want a real table format then you should replace the list control
with the table control.
You'll start out with three rows, the header, detail and footer.
Right click on the gray row selector on the far left of the detail row.
Click "Insert Group"
In the first row of the expressions list pick the name field from the combo
box.
Check the "Page break at end" check box below.
Click "OK"
You'll now have two new rows in the table, one above and one below the
detail row. These are the group header and footer rows.
You can drag the name field to the group header.
You can drag the other fields to the detail row.
Based on your first post it sounds like you'll need more than one detail row
to accomodate all of the fields. If this is the case, simply right click on
the row selector for the detail row and click "Insert row above" or "Insert
row below" and this will add detail rows. You can also right click on the
group footer row selector and choose "Delete rows" to delete it if you don't
need a group footer. You should also know that if you need more columns to
arrange your fields you can right click on the column selectors and insert
additional columns.
Hope that helps.
"randy1200" wrote:
> I'm creating Reporting Services reports in Visual Studio. I'm in the
> interface that shows the Data, Layout, and Preview tabs.
> I've recently learned that I can drag a list control onto the design surface
> from the toolbox, then drag a field from the dataset onto the list control.
> I can click the list control properties, click "Edit details group..." In
> the top line of the expression list, I choose my field from the dropdown. I
> check "Page break at end." If my data is from "select name from mytable", and
> there's 4 names, I get 4 pages. This works great!
> Here's the problem. I want my data to be from "select name, itemsordered,
> itemsbought from mytable". I want itemsordered and itemsbought to go into a
> table, leaving name in the list control. How do I reference the table control
> to the list control?
> I have 4 records. In everything I've tried, pages 1-4 show the names in the
> list control, and pages 5-8 show the items in the table. Page 1 should show
> the name from record 1, and the items in the table from record 1. Page 2
> should show the name from record 2, and the items in the table from record
> 2...
> --
> Randy|||Hi Randy,
Welcome to use MSDN Managed Newsgroup Support.
From your description, my understanding of this issue is: You want to show
reference a table in a list. If I misunderstood your concern, please feel
free to point it out.
You can just drag a table in to the list control and put the fields into
the table.
Hope this will be helpful.
Wei Lu
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================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.|||Many thanks for the responses. They are appreciated. Your previous response
did help a lot.
The idea is I'd like to sync different toolbox containers to display from
the same record.
I get the idea that I can just position items from the DataSet within a
large listbox. I'm just surprised that Microsoft didn't provide a facility
to allow items from the same record to display in different tools such as
table and list. I can imagine times when it would be very useful.
Randy
"Limey" <Limey@.discussions.microsoft.com> wrote in message
news:F8DA3AB0-25D7-4EF6-ACEB-0CF0E6CF899B@.microsoft.com...
>I believe I was one of those who answered before and thought this may be an
> issue. There are a couple of approaches you can take. The first is to
> continue using the list control. You can actually drag any fields you
> want
> into it. Resize it if you don't have enough room. You can arrange the
> additional fields in a table format.
> If you want a real table format then you should replace the list control
> with the table control.
> You'll start out with three rows, the header, detail and footer.
> Right click on the gray row selector on the far left of the detail row.
> Click "Insert Group"
> In the first row of the expressions list pick the name field from the
> combo
> box.
> Check the "Page break at end" check box below.
> Click "OK"
> You'll now have two new rows in the table, one above and one below the
> detail row. These are the group header and footer rows.
> You can drag the name field to the group header.
> You can drag the other fields to the detail row.
> Based on your first post it sounds like you'll need more than one detail
> row
> to accomodate all of the fields. If this is the case, simply right click
> on
> the row selector for the detail row and click "Insert row above" or
> "Insert
> row below" and this will add detail rows. You can also right click on the
> group footer row selector and choose "Delete rows" to delete it if you
> don't
> need a group footer. You should also know that if you need more columns
> to
> arrange your fields you can right click on the column selectors and insert
> additional columns.
> Hope that helps.
>
> "randy1200" wrote:
>> I'm creating Reporting Services reports in Visual Studio. I'm in the
>> interface that shows the Data, Layout, and Preview tabs.
>> I've recently learned that I can drag a list control onto the design
>> surface
>> from the toolbox, then drag a field from the dataset onto the list
>> control.
>> I can click the list control properties, click "Edit details group..." In
>> the top line of the expression list, I choose my field from the dropdown.
>> I
>> check "Page break at end." If my data is from "select name from mytable",
>> and
>> there's 4 names, I get 4 pages. This works great!
>> Here's the problem. I want my data to be from "select name, itemsordered,
>> itemsbought from mytable". I want itemsordered and itemsbought to go into
>> a
>> table, leaving name in the list control. How do I reference the table
>> control
>> to the list control?
>> I have 4 records. In everything I've tried, pages 1-4 show the names in
>> the
>> list control, and pages 5-8 show the items in the table. Page 1 should
>> show
>> the name from record 1, and the items in the table from record 1. Page 2
>> should show the name from record 2, and the items in the table from
>> record
>> 2...
>> --
>> Randy|||Many thanks for the response.
What you said here is exactly right. The problem is that my DataSet is a
select statement which uses both inner and outer joins. If there's not a
one-to-one relationship for a joined record, then the table can end up
displaying more than one record for a given item in the list control.
It really seems funny to me that Microsoft doesn't provide a mechanism to
link different tools from the toolbox (such as table and list) to a given
record.
Randy
"Wei Lu" <t-weilu@.online.microsoft.com> wrote in message
news:OHaY6b9RGHA.3492@.TK2MSFTNGXA03.phx.gbl...
> Hi Randy,
> Welcome to use MSDN Managed Newsgroup Support.
> From your description, my understanding of this issue is: You want to show
> reference a table in a list. If I misunderstood your concern, please feel
> free to point it out.
> You can just drag a table in to the list control and put the fields into
> the table.
> Hope this will be helpful.
> Wei Lu
> Microsoft Online Partner Support
> Get Secure! - www.microsoft.com/security
> =====================================================> 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.
>|||I have needed to do what you are talking about many times (if I understand
correctly). When using list boxes ... if you have multiple groupings then
you need to nest the list boxes within each other. For instance ... if you
have data like city, state, country. You can create a table that has
groupings by country, state, and city and display detail info about the city
within the table. If you want to have a similar display using lists ... then
you must have 3 list boxes nested. The outer is grouped by country, next
inner list is state, and inside state is city. That might get you started.
"Randy" wrote:
> Many thanks for the response.
> What you said here is exactly right. The problem is that my DataSet is a
> select statement which uses both inner and outer joins. If there's not a
> one-to-one relationship for a joined record, then the table can end up
> displaying more than one record for a given item in the list control.
> It really seems funny to me that Microsoft doesn't provide a mechanism to
> link different tools from the toolbox (such as table and list) to a given
> record.
> Randy
> "Wei Lu" <t-weilu@.online.microsoft.com> wrote in message
> news:OHaY6b9RGHA.3492@.TK2MSFTNGXA03.phx.gbl...
> > Hi Randy,
> >
> > Welcome to use MSDN Managed Newsgroup Support.
> >
> > From your description, my understanding of this issue is: You want to show
> > reference a table in a list. If I misunderstood your concern, please feel
> > free to point it out.
> >
> > You can just drag a table in to the list control and put the fields into
> > the table.
> >
> > Hope this will be helpful.
> >
> > Wei Lu
> > Microsoft Online Partner Support
> >
> > Get Secure! - www.microsoft.com/security
> > =====================================================> > 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.
> >
>
>