Sql 2005 Standard Advice SSRS Crystal Reports

Mar 24, 2008

I have visual studio 2008 on my vista ultimate machine. I also have sql express edition, however I have no installed it
I was thinking of installing sql standard edition because I really am interested in development of ssrs,
crystal reports in a commercial development. Is it best to have both sql express and the standard edition
I am excited about sql 2008. What is the best configuaration for an aspiring small comercial developer
like myself. I am looking for input. Thanks

View 5 Replies


ADVERTISEMENT

Seeking Advice On Converting Crystal Reports To SSRS

Aug 20, 2007

Hi. We've decided to convert our Crystal Reports to SSRS 2005. We know (thanks to this forum) there are companies that will convert the reports at a cost; however, we'd like to undertake this ourselves. Are there resources you can point us to that might be specific for Crystal Reports users coming over to SSRS, especially for newbies? Thank you.

View 3 Replies View Related

Converting Crystal Reports To SSRS Reports

Mar 27, 2008


My issue is with converting multi-value parameters:

In Crystal Reports, you can set a parameter to accept multiple vales (Discrete, Range or Discrete and Range).

As an example:

I have a database table with a column called ID.
I can create a parameter called param_id and set the options of the parameter to "Allow multiple range values".

With this setup, I can limit the result set of the report by comparing the param_id parameter to the ID column in the database. Because param_id is a multi-value range parameter, I can pass it the following data:
1 - 50
60 - 80
150 - 127

This will only return results within those ranges.


Does anyone know if SSRS provides this kind of functionality?

Thanks,

Patrick Conway

View 9 Replies View Related

SSRS Or Crystal Reports

Feb 19, 2008

Hello all ...

I want to know which would be the best for reporting in either of the above two. I am working on with SSRS but don't have any idea about crystal reports. So you all please suggest the best one would be for me espcially for web based reporting.

Regards,

View 7 Replies View Related

SSRS Vs. Crystal Reports

Jul 13, 2007

Hi, all. Does Microsoft provide a document comparing SSRS against Crystal Reports? Thanks.

View 1 Replies View Related

Converting Crystal Reports To SSRS

Apr 3, 2007

I came across a website that claimed "There are approximately 116 functions in Crystal Reports that do not have a direct equivalent in VB.NET or Reporting Services (SSRS)." Does anyone know what these functions are?

View 3 Replies View Related

Comparision Of SSRS With Crystal Reports

Apr 23, 2008


1) Crystal Reports provides extensive parameter support. The types of parameters supported are: single value, multi-value, and range value (e.g. Start date to End date), or a combination of all three.
2) SSRS parameters only support entry of a single value. It doesn't support multi-value parameters or range parameters. For example, the user can't be presented with a list of Employees and select more than one for reporting on. Doing so requires writing custom code and writing more complex SQL queries

View 5 Replies View Related

Reporting Services :: Migrating All Crystal Reports Over To SSRS

Oct 16, 2015

I am in the middle of migrating all Crystal Reports over to SSRS and am having some troubles converting formulas used in Crystal Reports to functional expressions in SSRS. For example: My formula for one of the crystal reports is the following. Very simple logic but how would I build it as an expression to work in my SSRS report?

IF {CUST_ORDER_LINE.ORDER_QTY}-{CUST_ORDER_LINE.TOTAL_SHIPPED_QTY} < 0 THEN 0 ELSE {CUST_ORDER_LINE.ORDER_QTY}-{CUST_ORDER_LINE.TOTAL_SHIPPED_QTY}

View 3 Replies View Related

SQL 2005 Connection To Crystal Reports

Dec 15, 2007

I have created a "read only" login on the SQL 2005 database server with rights to the public role with grant connection rights. When I use the "read only" username in Crystal Reports, the database does not show in the dropdown box. When I give "read only" sysadmin rights, all databases appear. I do not want "read only" to have sysadmin rights, is there another way around this that would truly give "read only" read-only rights?

TMDavis

View 3 Replies View Related

Login Failure Issue With Crystal Reports Connecting To SQL Server 2005

Nov 6, 2007

Hi All,


My application uses "crystal reports" control to integrate some reports that can be viewed from within the application.

I'm getting a login failed (due to bad password SQL State 8) error when I bring up the report from within the application. The report runs fine outside the application with the same username password.

- I've checked several times to make sure that I'm passing the correct username/password from the application.
- All letters in the password are lower case. There is not case-sensitive issue.
- I printed the username and password on a pop-up to see what values are passed , and they are correct.
- A single test page that uses the same version of "Crystal Reports" control , using the same username/password, brings up the same report works fine.

I guess , my question is:

Is there a way to trace the login failure event on the SQL Server side to see what is the value of the password that is being sent by crystal reports control?

I'm using Crystal Reports XI with sp2.
SQL Server 2005.

I appreciate the help.

Thanks,
Satish

View 9 Replies View Related

Comparison Of SQL Server Reporting Services To Access Reports, Crystal Reports, Cognos Or Other Options

Nov 5, 2007

Hello SQL Server Experts, Data Analysts, and Report Writers et al:

re: Reporting Options with SQL Server

I wanted to propose an offshoot to the pryor thread:

Would anyone take a stab at comparing Access Reports, Crystal Reports,
Cognos or other options to all the Reporting Services and its components offered as part ofSQL Server, especially as to extracting data from SQL Server into a report format?

I guess this is a far as capabilites, ease of use, limitations, and especially formatting
or presentation of the end report product?

Thank you to all, and I hope this is a beneficial discussion to others.

Hal1490



Hal9000

View 4 Replies View Related

Can I Write SSRS 2008 Reports To Run On SQL 2005 SSRS?

Sep 12, 2007

Is it possible to write SSRS 2008 reports to run on an existing SSRS 2005 server?

If yes, what do I need to do to be able to write SSRS 2008 reports on my developer PC that will run on the SQL 2005 Server (which also has SSRS 2005 installed on it)?

I installed Visual Studio 2008 beta on the development PC and it appears that it needs SSRS installed on it too. So I installed SQL 2008 SSRS (SQL Server Reporting Services) and SQL 2008 Workstation Components onto the developer PC. Next I run the SQL 2008 "Reporting Services Configuration" tool. When I click on the "Web Service URL" section it hangs indefinitely and I have to force it closed.

The developer PC is Windows Vista Business.

Any suggestions on making this work, or any other information that you can think of that would allow me to use Visual Studio 2008 and the SQL 2008 "Report Designer Preview" tool to develop SSRS reports that will run on the SQL 2005 SSRS server?

Thanks!
-ErikR

View 4 Replies View Related

Can't Create Reports Via VS 2005 Standard

Aug 16, 2007

From what I read about the versions, VS 2005 Standard allows for SSRS development.

If I create a new project, I don't see the option to create anything from the BI section to create a report project.

I have SQL Server Express on my machine, and am able to run the SSRS configuartion management tool.

Do I have to run an .exe file or something?

Thanks!

View 6 Replies View Related

How To Fax Reports From SSRS 2005

Nov 17, 2006



How do I fax out reports from SQL Server Reporting Services (SSRS) 2005? I tried RightFax 6.0 but it didn't work.

View 4 Replies View Related

Migrate SSRS 2005 Reports

Jul 23, 2007

Hi,

I need to move few folders from our DEV SSRS 2005 environment to another
server. Folders will be moved to new parent folders.
Is there any tool that I can use fot this purpose?
I used RSScripter from SQLdbatips.com. Although the tool works great but it
can't script multiple folder reports. I have to script one by one and it is
a big problem.

Thanks
Alex

View 1 Replies View Related

SSRS 2005 Link Reports

May 23, 2007

In SSRS 2005, Is it possible to have a link in one report (i.e. report A) to be directed to report B.
Can you show me guidance on where to start please?

View 3 Replies View Related

Can Reports Be Created In SSRS-2005 Using VB Or VB.NET

Mar 31, 2008

View 6 Replies View Related

Crystal Reports/SQL 7

May 3, 2001

A long shot but someone may have experienced same problem. We are using Crystal Info to run reports against a SQL 7 database. Reports that usually take 1 or 2 minutes to run are taking up to 15 minutes to run. The database is fine ie you run the query through the query analyser and it runs in 1 or 2 minutes. Any ideas... I've spoken to Seagate but not making much progress.
Thanks in advance..

View 1 Replies View Related

Crystal Reports

Sep 6, 2000

Can any one tell me where can I find good online help for Crystal Reports for learning?
Thanks!

View 1 Replies View Related

Crystal Reports

Apr 19, 2006

I am working on creating Crystal Reports from a SQL database.

In CR you can define a multiple range parameter i.e. 1-10, 100-200, 300-400 and Cr will filer records that satisfy this criteria.

How can I transfer this functionality using a stored procedure?

View 1 Replies View Related

Crystal Reports

Mar 6, 2006

Hi,
I am new to crystal reports.

I need to change the database connection in the reports to different sql server database and use the same report layout.

Any help is appreciated.

View 4 Replies View Related

SQL In Crystal Reports

Mar 20, 2007

I'm new to SQL but have quite happily been using Crystal Reports without it until now.

I am creating a letter template and it has the name at the top then the address

<name>

<address1>
<address2>
<address3>
<address4>

There is always an address 1, but maybe not a 3 or a 4, and aparently we dont want any line gaps to show, so I figured i should use an isnull to eliminate the line and to move the other address line up?

Not sure what to put though, any ideas?

Thanks in advance for any help :o)

View 2 Replies View Related

CRYSTAL REPORTS 8.5

Sep 27, 2007

THE TIME PORTION OF THE DATE/TIME IS NOT DISPLAYING IN CRYSTAL 8.5
IT SEES THE DATE...BUT NOT THE TIME


ANY SUGGESTIONS

View 3 Replies View Related

Crystal Reports &&amp; Pdf

May 17, 2007

Hi,



I have a question. How can i fill a report made in CrystalReports in .net



Thanks in advance

View 1 Replies View Related

Crystal Reports

Mar 14, 2008

what are the good resources for crystal reports.
Also is it something which is difficult to work with ? Suggestion, experiences and notes please.

View 4 Replies View Related

Sql Server 2005 SP2 Affect SSRS Reports.

Mar 19, 2008

Hi,

I had a report (.rdl) using sql reporting services in sql server 2005, where it was running quite good.
I have just installed sql server 2005 sp2. After that, when I run the report through report viewer, the result of the report contains the first record of the dataset keep on repeating for all other records. If I run the dataset the results are correct,but if I preview it, then the first record alone repeating for all other records.

I feel that sp2 might cause this rendering problem. Any suggestion please?

Murali.

View 1 Replies View Related

Converting Reports FROM SQL RS 2000 TO SSRS 2005

Apr 23, 2007

I have abt 30 reports currrently in SQL 2000. My data still resides in SQL SERVER 2000. However, I need to convert these reports to SSRS 2005.

I want to use the cool features like sorting, multi-value parameters from the RS 2005.

Can you pl advise how I shud go abt converting these reports from RS 2000 TO RS2005 .

Thanks.

View 5 Replies View Related

Cannot View Reports After Upgrading To SSRS 2005

Aug 29, 2007

Hello,

We recently did an "in place" upgrade of SQL Server and SSRS 2000 to 2005.

After the upgrade we cannot view the exisiting reports. (although we can publish new reports using the VS2005 Designer and they show up just fine.)

We have SP2 installed for SSRS2005 and all SPs for SQL are up to date.

When we navigate to an existing report via the reporting services website, the report acts like it is trying to run and then returns and error message:
















An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help

When we look at the logs we see that the report server cannot initialize the stream from the Catalog table.

aspnet_wp!library!1!08/28/2007-16:52:29:: Call to GetPropertiesAction(/Report Administration/All Process Dates, PathBased).
aspnet_wp!chunks!1!08/28/2007-16:52:29:: i INFO: Returning old chunk for: (fd690975-ec5b-4033-9664-81335e3990c0, 'CompiledDefinition', 0)
aspnet_wp!library!1!08/28/2007-16:52:29:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., Could not initialize stream;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
aspnet_wp!library!1!08/28/2007-16:53:01:: i INFO: Exception dumped to: C:Program FilesMicrosoft SQL ServerMSSQL.2Reporting ServicesLogFiles flags= ReferencedMemory, AllThreads, SendToWatson
aspnet_wp!chunks!1!08/28/2007-16:53:01:: e ERROR: ### SnapshotConverter(fd690975-ec5b-4033-9664-81335e3990c0, True), Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
aspnet_wp!library!1!08/28/2007-16:53:01:: Call to GetSystemPropertiesAction()

We welcome any suggestions.

View 4 Replies View Related

Migrating RS 2000 Reports To SSRS 2005

Jan 8, 2007

Hi,

Can anyone point me to any reference material, resources etc. on migration of SQL Server 2000 Reports to 2005?

Thanks,

Dave

View 3 Replies View Related

Connecting With Crystal Reports

Feb 2, 2006

Hi,
I'm very new to SQL Server, I'm coming from an Oracle background.
I've set up a server with windows authentication but I'm having no luck connectiong to it with Crystal Reports XI.
Can anybody go through the basics with me?
Regards
Sean

View 6 Replies View Related

Sql Server && Crystal Reports

Jul 23, 2005

Hi,I'm semi-new to crystal reports & sql server and what i want is toextract data from a sql server file. I've been able to connect to sqlserver directly and get the info. i need but is there a way to just openthe data file (in crystal reports) without making a server connection?TIA

View 1 Replies View Related

Crystal Reports And Sql Server 2k

Jul 23, 2005

Has anyone had any luck getting Crystal Reports 8.5 to work with theSql Server 2000?I keep getting a "Unable to open Database" error. I've tried openingwith either the .Connect property and the LogOnServer method and getthe same message from either approach.I am using the OCX control.Does this version work with Ms Sql?Any thoughts and suggestions would be most appreciated.Thanks.-Dave

View 4 Replies View Related

Numbers And Crystal Reports 9

Jul 23, 2005

I exported a column of type float to SQL Server using DTS. In Crystalreports, it 'sees' the column as a string! Is 'float' the best type touse? Must I create a formula field in CR to 'correct' for this?

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved