Comments by ShaikhM (Top 66 by date)

May be even this: But this one involves creating your own.

http://code.msdn.microsoft.com/windowsdesktop/Creating-Your-Own-Windows-5b8c7fad

http://stackoverflow.com/questions/6190271/how-to-run-photoviewer-dll-in-command-line

does that help?

Can you please give some more details.

Mate, you dont have to give clarifications to me. I am not judging you or your past. There's obviously a difference in opinions here.

Sweet.. +5. So true.

the first line is your answer? Great. I would call it over assumption of things. And not to miss Over Confidence. The fact is only because you have to keep up with your daily and monthly competitors, sometimes taking a shot in the bush helps. And although you may not accept this on the forum, but you know you have done this before.

@thatraja.. this is what happens when you copy paste links as answers left-right-center without understanding what the OP wants. If it were only a suggestion why was it posted as a Solution and not a comment. No wonder I can see your name on the right side.

I am sure you must have done some googling. But did you hit this link?

http://social.msdn.microsoft.com/Forums/en-US/7e33f198-9a25-4e62-a371-3cb7b4d16113/retrieving-the-com-class-factory-for-component-with-clsid-11bd526015b6412d80db12bb60b8fe50

Looks as though something to do wrong with the crsytal msi. Just try uninstalling it and restarting the box and then installing it again.
Thanks

Try using a subreport in your detail section for the Totals value.

Thats made me think..Cool thanks

IMO I dont think thats possible. Because if the field has already been exported as an INT, you cannot have any further control on it i.e. changing it to decimal. Unless you change the excel to show decimals after you have exported the report.

Check if the formula is resulting in INT or STRING. Could be a string thats why u are not able to sum it.

Yup thats where I am stuck. I dont want to filter on anything. And most important data for me is BRANCH_NO. I want all branch_no as I am using them in the RDL. BUt filtering removes some branch_nos which leaves my report incomplete.

Have you tried running the sql query in the SQL studio.

Can you give some more details.

Was the link helpful?

Do you get any error?

There's not sufficient information for us to comment.

Can you Copy paste the entire exact error

Can you please give an example of what you want. I cant understand the questions. Thanks

Have your tried Reporting Services. Its easy to build a report on that. You can compare the times on both crystal reports and SSRS and then decide.

Whats the point of this question?

Thanks.

Yes I wouldnt mind that. I need some direction.

I am using WinForms

Are you even using SQL 2005? And C# as your backend?

I like the last line of your answer Vani Kulkarni. Good on you.

Yup you are right

May be you should add a RECORDSELECTION statement to you code for the application to filter the search records.

Thanks for the idea of a Stored procedure. That never struck my mind.

I like it bro! Not exactly want I wanted but not far away from what I wanted. I just have to make one report (report 2). I have a question though. What does 1 = 1 mean and what does it do.

There you go. The bold part.

Could you please Right-Click the Subreport section and tell what checkboxes are ticked. It has to do something with it. trying playing with them.

Good that you took back your words.

Now I can see the difference between Stackoverflow and Codeproject. If the whole point is just to "start of" and not solve a question, I would still think it should go as a comment and not a SOLUTION. I can guess how experts have been scoring easy 10 points for pasting overly out-of-scope links. No wonder. Its like the competition who pastes links first.

And what about the language Mr Sandeep. :thumbsup ???
It is sad that top experts cant do or rather dont do anything about it.

Please mind your language.

What's the point if you just Google and paste links that cover such a broad area and are not specific to the question. Anybody can do that. You links include VB.net, ASP.net, Sql Server and one also involving web-pages which in this case it not required at all.

This would have been completely acceptable, had it been a suggestion or a comment. How can you provide a solution to a question that is not clear itself.

Is using crystal reports your only option? have you thought about using Reporting Services?

Can you please elaborate and add some more details to question. The solution below just lists out links that you can find yourself on Google.

That wasnt a solution. Its just how to use Google to find things. You didnt even care to ask what backend the person is using. That solution is extremely broad and out of scope.

Infact the question itself doesnt have proper instructions on what is wanted.

Ok. So atleast you know that your font is working. For size, I would suggest that you try different sizes and also try including enough space in the text field for the text to fit in it. Play some more with it, because thats what I would do.

I seriously dont understand the second paragraph of the solution. Probably needs editing. Looks like a solution is provided just for the sake of it. Can you be more clear.

As far as I know, crystal reports supports only True Type fonts.
Check link to understand the difference between both the fonts
( http://answers.yahoo.com/question/index?qid=20080621145425AAuKtgk ).
The font you are using may be a Open type font, that CR doesnt support. Just for testing try using a True type font and see if PDF prints, if it doesnt then the problem may not be fonts, and may be somewhere else.

please provide more detail. Whats the error. Also how have you linked the Main report and subreport. This is very little information to provide a solution.

Would be good to see the question poster come back and mark it as Answer. Most dont.

A tablular format of the required report for us to understand better will be of great help. Also what code base you are using? Please give more details.

Also using crystal reports your only option? I am asking this because such things are less complex using SSRS.

Can you post the Exact words of the error?

Very difficult. Can you elaborate.

I think the approach you have taken is probably the most obvious one. I would do the same.

But instead of an array can you try a shared variable. Idea remains the same.

And theres no better way I can think of.

First of all. Check this link.

http://www.dpriver.com/pp/sqlformat.htm

It is a very helpful link that formats all you sql statements for you. That makes it a lot easier to read.

And now getting back to you question. I think you have to include more details.
1) What version of CR you are using.
2) Do you have any groups?
3) Is all the data in the detail section?
4) What sequence is it displaying records .. 1 item twice together or One set of 4 records after the other.


Quickest way to check is Run SQL Profiler and see what sql query your report is executing when it runs. You will have a better idea then.

may be you have include a join or something and relate both the datatables. I am not sure. What else have you tried.

And if you seriously want to use crystal report, then why dont you create one instead of doing this dynamic thing. And then pass your data to the report

And why have you included Crystal reports in your tags? there is no mention of crystal reports in your question itself.

Is using Crystal Reports your requirement or choice? You might consider SQL Reporting Services. Though CR can achieve such things, but needs the developer to give a lot of pressure to his brains. SQL Reporting Services do not. Comparatively.

Did you solve the prblem? What did you do?

I am not sure about this in your case, but most of the time that I have faced Logon issues in reports, i fixed them by Checking the INTEGRATED SECURITY check box.

What happens when you try to export the report to PDF from Crystal report itself? Any error?
Also does any part of your code adds or changes any fields from the "tablename" at runtime?
As an alternative try running a different dummy report that uses the same "tablename"

If he had to use Google, why would he come here.

I suspect it is not a problem with Crystal. I think it has something to do with the query that you wrote. Try running a sql profiler and see whats happening behind when the report shows "In Progress". That will tell you where to start.

In the rpt file, right click

Design --> Page Setup --> Select Adjust Automatically.

That should help you

As an alternative you can also try selecting the Adjust Automatically checkbox.

Try playing with the Can Grow property of the Subreport as well as the Text feild within the subreport.