Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: lyu
  • Order by date
  1. lyu

    How to pass mutiple-value parameters to a SQL server stored procedure?

    I just tried the main/sub report approach in both CR XI and 10, it doesn't work for me either, the same problem as bobschr, any ideas? Thanks a lot!!!
  2. lyu

    How to pass mutiple-value parameters to a SQL server stored procedure?

    Yeap, to use a subreport is a really a good idea, except that subreport doesn't support page. In my report, I need to at least have a page counter in each page since the report will be long. I know that we can fake a page header and footer in subreport using grouping, however, it sometimes...
  3. lyu

    How to pass mutiple-value parameters to a SQL server stored procedure?

    Thank you very much, MisterMo If you set the parameter as a single string, Then how do you design the parameter interface so it will take multiple values? I tried both CR10 and CRXI, they both won't allow me to set multiple values for the parameter @MyId, the option is simply disabled. Any...
  4. lyu

    How to pass mutiple-value parameters to a SQL server stored procedure?

    Hi, I use CRXI and Sql Server 2000. I want a report, that users can choose multiple student IDs they want to see, then the report passes these mutliple IDs to a stored procedure as parameters, the sp runs and returns records which are only related to the students the user has chosen. The...
  5. lyu

    How to pass mutiple-value parameters to a SQL server stored procedure?

    Hi, I use CRXI and Sql Server 2000. I want a report, that users can choose multiple student IDs they want to see, then the report passes these mutliple IDs to a stored procedure as parameters, the sp runs and returns records which are only related to the students the user has chosen. The...
  6. lyu

    dynamic xml datasource in CRXI

    Hi, guys, here is my problem. I already have a jsp website, now I want to generate some reports whose data are taken from my jsp website. (The database only has raw data, and after after complicated calculation, my jsp page shows the end metrics. I once tried to put all the calculation into...
  7. lyu

    dynamic xml datasource in CRXI

    Hi, guys, here is my problem. I already have a jsp website, now I want to generate some reports whose data are taken from my jsp website. (The database only has raw data, and after after complicated calculation, my jsp page shows the end metrics. I once tried to put all the calculation into...
  8. lyu

    cannot add reports onto BOEXI

    No, the orginal report is not in C:\Windows\temp. Actually the report and the Central Manager Server are on two different computers. Thanks for your ideas, though. I just found another interesting thing, that I have no problems at all when adding a report thru Publishing Wizard, it reports...
  9. lyu

    cannot add reports onto BOEXI

    A strange thing happened after I upgraded from CE10 to BOEXI. Whenever I tried to add a report from Central Manager Server, it returns a Retrieve Error: There was an error while retrieving data from the server: Failed to read data from report file C:\WINDOWS\TEMP\tmp37.rpt. Reason: Internal...
  10. lyu

    Xi and Dynamic Parameters

    Sorry I cannot answer ur question here. But can I have a question for you? I have been playing with CRXI these days with dynamic parameter prompts and it really makes me sick. My database is SQL Server 2000. I have two data sources in my report: one is a stored procedure which takes a parameter...
  11. lyu

    "secWinAD security plugin is not available"

    Hi, I met basically the same problem here, though I am using businessobjects enterprise XI. Can you tell me how did you solve the problem? Thanks!
  12. lyu

    secWinAD plugin is not avaiable

    I just upgraded from CE10 to BusinessObjects enterprise XI. We used to use WindowsAD authentication in CE10, however, now when I tried to logon, it shows "The secWinAD security plugin is not available. Please contact your system administrator for details " Please help me, Thanks!
  13. lyu

    parameter help again, CR XI

    I posted this question several weeks ago here, and was told that there are no easy ways to do it in CR10 and below. I want to know whether this can be achieved with CR XI and how, if so, I would probably go and get CRXI. Thanks a lot!! I have a stored procedure which takes a parameter...
  14. lyu

    bottleneck when loading a large report from CE10?

    Hi, my company created a .net website which communicates with CE10 to display reports on our own website. It works but I just found a seemingly bottleneck: if I open a very large report(which takes 10+ minutes to run the stored procedure), then at the same time if I try to to open another page...
  15. lyu

    win AD authentication and impersonation on CE10

    Thanks synapsevampire, I already found this link before posting my question here. but this is not single sign on method as stated in the article. we need SSO and impersonation at the same time.
  16. lyu

    win AD authentication and impersonation on CE10

    I am using SQL Server. All reports in our company are created using windows authentication (Integrated Security), and inside the background stored procedure, we do somthing to limit what a user is allowed to see based on the current user who runs the stored procedure. This works fine on my...
  17. lyu

    win AD authentication and impersonation on CE10

    My company uses windows AD authentication and single sign on for CE10. But then we find that the database server will attempt to authenticate the report using the account under which the Crystal Server is running. This is not what we want. We want impersonation, i.e, to authenticate the database...
  18. lyu

    parameter help!!!!

    Thanks, that helps a lot!
  19. lyu

    parameter help!!!!

    Sorry, I am using CR 10. Can you explain more of the default value method? I can load all StundetIDs from the studentInfo table and add them as the default values of parameter StudentID, but how can I load the descriptions? All my description for these defualt values are empty, and of course I...

Part and Inventory Search

Back
Top