|
Data Source of Crystal Report 11 Can be a Dataset or store procedure.Can any one tell me which one is better.Either fetch data from Database and fill it in dataset and assign it to crystal report or give crystal report datasource direct to store procedure.?
Please explain benifits and draw backs of them
And what about speed issue.If Crystal report has data soure stored procedure will be loaded fast or Report having datasource Dataset will be loded fast?
|
|
|
|
|
I would lean towards a SP, that is what I use on all reports. If you decide to use SP, I would suggest that you would use a SP in each of your reports. This makes working with reports especially nicer if you are working with Infoview/Business objects.
The only downside that I can think of is the limitation of is passing multiple values in a parameter from Crystal to the SP, a work around is to parse a comma separated strings. I don’t care to have a Crystal Record selection with a SP it seems redundant and a waste of resources. I can probably think of quite few pros for using a SP but I will just list a few:
1. You have more control of data result, there are many data routines that just is not efficient to try to do in one query statement.
2. You separate your data logic from your report design. Many time I will provide the data and someone else will write the report.
3. If you decide that you don’t like Crystal anymore and you will likely have an easier time with a conversion.
4. You control how the query is written thus if you have performance issues later you can adjust the query without even opening the report.
5. Without go in situations, you also can have a Crystal report execute a SP and that SP updates other tables.
I hope this helps
John
|
|
|
|
|
wasting time in this web site and forum!!
|
|
|
|
|
So this is your attitude simply becuase you ask a very broad question and expect someone to spend their time writing code for you to use. The people who respond to questions do so unpaid, in their own time. If you refuse to accept their advice then you probably need to go to a paid for sercvice on some other site. There are many article on google relating to exporting to PDF, the original problem you had, so get off you lazy ass and do your own research.
Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP
|
|
|
|
|
So please stop wasting OUR time and stop spamming this forum 
|
|
|
|
|
hi,
I have a file upload control on a website.I have given validations to this control. When I click on a browse button by a mouse it show a browse panel, but when i go through a keyboard and when a control is on a browse button and i press the enter key, it shows error message that i have given in validation control.
how should i get the solution for this????
|
|
|
|
|
Hi,
How to use postback trigger in code behind for dynamically creating controls, if any one knows plz answer me...
kannak
|
|
|
|
|
I have a FormView InsertItemTemplate which has a databound dropdownlist. The dropdownlist displays a list of names retrieved through a SQL Server stored proc. The user has an option to add a new name to the database by clicking a button next to the dropdownlist. Clicking the button fires a javascript function, which opens a modal window. This "popup" window is where a new name and other pertinent data is entered. When the modal window closes the dropdownlist needs to refresh in order to display the new name (which was just entered in the modal window).
What is the best approach to refresh the dropdownlist? Where and when should a refresh occur (in what event)? I've searched for a solution and found many but none worked for me.
Thanks for your help!
- R A S
|
|
|
|
|
hi, i do have two command field in my gridview one is edit and another is delete, i want to disable delete for the specific row, For the first time when page load my code disable the delete button but when i click edit button and then update the data , the delete button is enabled again. Isn't there any way to disable the delete button always for the specific row i want. my code is as follow a/c to my application.
If Session.Item("UserId") <> Nothing Then<br />
For i As Integer = 0 To GridView1.Rows.Count - 1<br />
Try<br />
userID = CType(Me.GridView1.Rows(i).FindControl("lblUserID"), Label).Text<br />
Catch<br />
userID = CType(Me.GridView1.Rows(i).FindControl("tbUserID"), TextBox).Text<br />
End Try<br />
If userID = Session.Item("UserId") Then<br />
GridView1.Rows(i).Cells(1).Enabled = False<br />
End If<br />
Next<br />
End If<br />
thanks in advance.
|
|
|
|
|
trimandir prajapati wrote: For the first time when page load my code disable the delete button
Where did you written the code for disable button ? is it in Page_Load()?
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
|
solved using javascript 
|
|
|
|
|
hello everybody,
I descovered lately that SetDatabaseLogon will not allow us to change the server name.... i find some blogs but all of it ends up n vain.... my code below encountered an error "Procedure 'gg_TestSource' expects parameter '@pServer', which was not supplied"....
im almost running out of time with myu project deadline.... i need someone who could help..... please please please... tnx n advance....
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using CrystalDecisions.CrystalReports.Engine;
using CrystalDecisions.Shared;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
ParameterDiscreteValue discreteBranch = new ParameterDiscreteValue();
ParameterFields paramFields = new ParameterFields();
ReportDocument rpt = new ReportDocument();
rpt.Load(Server.MapPath("~/MyCrystalReport.rpt"));
// changing my testing servername to production servername
Database crSubDB;
Tables crTables;
ConnectionInfo cInfo = new ConnectionInfo();
cInfo.ServerName = "ProductionServer";
cInfo.UserID = "myUserID";
cInfo.Password = "myPassword";
cInfo.DatabaseName = "MyTable";
crSubDB = rpt.Database;
crTables = crSubDB.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables)
{
TableLogOnInfo crTableLogOnInfo = crTable.LogOnInfo;
crTableLogOnInfo.ConnectionInfo = cInfo;
crTable.ApplyLogOnInfo(crTableLogOnInfo);
}
///
ParameterDiscreteValue paramDiscreteBranch = new ParameterDiscreteValue();
ParameterField paramFieldBranch = new ParameterField();
paramFieldBranch.Name = "@pServer";
paramDiscreteBranch.Value = "XX";
paramFieldBranch.CurrentValues.Add(paramDiscreteBranch);
paramFields.Add(paramFieldBranch);
rpt.SetParameterValue("@pServer", paramDiscreteBranch);
CrystalReportViewer1.ParameterFieldInfo = paramFields;
CrystalReportViewer1.ReportSource = rpt;
}
}
xxx
|
|
|
|
|
How to export images to Excel/PDF/WORD in ASP.NET using VB?
I can only export the gridview to excel, but not images.
Help will be greatly appreciated.
Thanks
|
|
|
|
|
This has nothing to do with ASP.NET, working with different formats is a pure VB task. You export to office using the Microsoft tools, and to PDF by buying an SDK.
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
|
Dear Graus,
Would you please teach me in detials how to archieve this or any web site that can teach me to archieve my purpose?
Thanks
|
|
|
|
|
|
Everyone knows "google"
if I can find my answer in "google", i wil not post this questions in this web site.
Telling me to "google" is a very bad answer!!
|
|
|
|
|
leungoiyu wrote: Everyone knows "google"
oh yea. Prove it.
leungoiyu wrote: if I can find my answer in "google", i wil not post this questions in this web site.
what do you do if I pulled off the answer right from google?
leungoiyu wrote: Telling me to "google" is a very bad answer!!
Quote Selected Text
So, do you this asking someone to "teach you in detail" is good question?
|
|
|
|
|
I Do not want to waste my time talking to you.
So DO NOT write anything in my questions forum!!!
Thanks
|
|
|
|
|
I have to agree with Yusef. If you don't know how to do this, a forum is the wrong place to ask . You could pay me to write it for you, or you could do some research and ask specific questions when you get stuck, but 'how do I write xxx' is not a valid question, nor is a forum a place to expect an in depth answer to so broad a question
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
|
OK, Since i haven seen in the FAQ column that this web site is free to share knowledge, so i ask questions here!
if i had known that it was not a free forum, i would NOT posted a questions here.
I will go and asked for other programmers for help since i do not think this web site offers a good service nor is helpful.
I will not post questions again and recommend my friends to see this web site since this fourm is the most terrible and unhelpful forum i have ever seen!!
|
|
|
|
|
leungoiyu wrote: i do not think this web site offers a good service
You get what you pay for
Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP
|
|
|
|
|
Hi friends i have one serious problem i m unable to pass an array like string[] seatLayout=new string[100]; from one page named SelectBus.aspx to PassDetails.aspx.....i m stuked there? i need to pass array from one page to another. Can any one please help? 
|
|
|
|
|
well there are several ways you can pass data between pages, Query String, Session variables etc. string[100] is potentially huge data, depending on the content of each element.
Why don't you persist the data to either database or file and pass a handle from one page to another
page1.aspx: Save string[100] to database then call page2.aspx?id=some_id
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
